how to drop table in mysql code example

Example 1: how remove column in mysql

ALTER TABLE "table_name" DROP "column_name";

Example 2: drop table in mysql

DROP TABLE table_name;

Example 3: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];

Example 4: to delete a table in mysl

drop table table_name;

Example 5: how to DROP a table in mysql

-- 'DROP TABLE' followed by the name of the table you would like
-- to drop.
DROP TABLE `test_table`;

Example 6: delete table in mysql

delete table query

DROP TABLE <table name;
e.g. DROP TABLE students;

Tags:

Sql Example