mysql delete data from table code example

Example 1: mysql delete

DELETE FROM table_name
WHERE some_column = some_value

Example 2: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];

Example 3: delete all content in table mysql

TRUNCATE tablename

Example 4: how to delete a table in mysql

DROP TABLE tablename;

Example 5: mysql delete rows

DELETE FROM table_name
WHERE condition;