Learn online DBMS “Delete Command in MySQL” Complete Lesson 13

DELETE COMMAND– In order to delete one or more tuples, DELETE command is used. If we want to delete the tuple for Teacher with ID=2345 the command is:

DELETE FROM Teacher

WHERE Teacher_ID=234;

If the WHERE clause is missing then it will delete all the tuples in a table.

     DELETE FROM Teacher;

     The above command would delete all the tuple in the table Teacher.

     Alike UPDATE command, the WHERE clause of DELETE command can also    

contain SELECT command which is used to delete tuples based on the result of a

query.