how to clear all data in a mysql table code example

Example 1: clear a table in mysql

truncate tableName

Example 2: delete all content in table mysql

TRUNCATE tablename