How to delete a table

by

mysql> drop table tablename;

In MySQL, you can delete a table using the DROP TABLE statement. Here’s the basic syntax:

sql
DROP TABLE table_name;

Replace table_name with the name of the table you want to delete. Be cautious when using this statement, as it permanently removes the table and all of its data. Make sure to have a backup if needed.

Example:

sql
DROP TABLE mytable;

This will delete the table named “mytable” from the database.