What is the purpose of the MySQL DROP command?

As the name suggests, it is used to completely delete the table from the database.

Syntax

Drop table table_name;

Example

mysql> Drop table Student;
Query OK, 0 rows affected (0.09 sec)

The above query completely deletes the "Student" table from the database. We can observe that MySQL returns an error message after running the following query -

mysql> Select * from Student;
ERROR 1146 (42S02): Table 'query.student' doesn't exist

The above is the detailed content of What is the purpose of the MySQL DROP command?. For more information, please follow other related articles on the PHP Chinese website!