delete all columns from table mysql code example

Example 1: how delete a column in mysql

ALTER TABLE table_name
  DROP COLUMN column_name;

Example 2: delete all records from table

DELETE FROM table_name;

Example 3: delete all content in table mysql

TRUNCATE tablename