TRUNCATE TABLE in MySQL Example

TRUNCATE TABLE In MySQL, the TRUNCATE TABLE statement is used to truncate or remove table records but not the structure. Syntax: TRUNCATE TABLE table_name Example: TRUNCATE TABLE items; Output: Query OK, 0 rows affected <0.07 sec> Explanation: The “items” is an already existing table that is truncated thus deleting all the data. Verify the result … Read more