Home » Online Computer Education » Learn online DBMS “Delete Command in MySQL” Complete Lesson 13

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;

del1

 

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.

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published.