DELETE Commands

Sun Jul 15, 2012 10:34 pm

To delete all the records from a table in mysql we can use TRUNCATE :

You can delete a specific parts of records from database using DELETE command with where clause :

To delete an entire table from the database we use DROP command :

We can also add if exists to it :

You can also delete multiable tables in one sentence :

You can use DROP command to delete an index from a table :

You can use DROP command to delete an database :