drop data in table mysql code example

Example 1: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];

Example 2: delete all content in table mysql

TRUNCATE tablename