Delete MySQL Tables

How to drop or delete Mysql tables Data?

Explanation

MySQL Delete :


The DROP statement is used to delete one or more tables completely from a database.

Syntax :


DROP TABLE tbl_name
The following example deletes the student table.

Example :

mysql> drop table student;

Query OK, 0 rows affected (0.00 sec)
This query will permanently remove or delete mysql tables (student).
DROP TABLE query drops all fields in the table and deletes the table. Once the DROP TABLE statement is used, we cannot use that table. So, we should be careful with this statement.

Ask Questions

Ask Question