How to delete a MySQL table

It is very easy to delete a table in MySQL, but you must be very careful when doing so, because all data will disappear after the deletion command is executed.

grammar

The following is the general syntax for deleting a MySQL table:

DROP TABLE table_name ;

Deleting a table in the command prompt window

In the mysql> command prompt window, the SQL statement to delete the data table is DROP TABLE

Method extension:

There are two ways to delete data in MySQL, one is the DELETE statement and the other is the TRUNCATE TABLE statement. The DELETE statement can select the records to be deleted through WHERE. Using TRUNCATE TABLE will delete all records in the table. Therefore, the DELETE statement is more flexible.
If you want to clear all records in a table, you can use the following two methods:

1. DELETE FROM table1
2. TRUNCATE TABLE table1
   

The TABLE in the second record is optional.

If you want to delete some records in a table, you can only use the DELETE statement.

DELETE FROM table1 WHERE ...;

This is the end of this article about how to delete MySQL data tables. For more information about simple methods to delete MySQL data tables, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!