Computer Science
Answer
The statement DELETE ALL FROM TABLE EMPL;
is in error due to the misuse of the keyword ALL
and the unnecessary inclusion of TABLE
before the table name. In SQL, the syntax of DELETE statement is :
DELETE FROM <TABLENAME>
[ WHERE <PREDICATE> ] ;
According to this syntax, the correct command to remove all the contents of EMPL table is :
DELETE FROM EMPL ;
Related Questions
Table Empl has same structure as that of table EMPL. Write a query statement to insert data from table NewEmpl into EMPL where salary and comm is more than Rs. 4000.
What is the error in following statement ?
UPDATE EMPL ;
Differentiate between DDL and DML.
Consider the following SQL statement. What type of statement is this ?
CREATE TABLE employee (name VARCHAR, id INTEGER)
- DML
- DDL
- DCL
- Integrity constraint