sql delete all rows from a table code example

Example 1: delete all records from table

DELETE FROM table_name;

Example 2: how to delete all the rows in a table without deleting the table in mysql

delete from tableName;

Example 3: sql delete all values in a column

UPDATE TableName SET ColumnName = NULL