mysql reset table data

Posted . Visible to the public.

mysql table reset

TRUNCATE TABLE <tablename>;
ALTER TABLE <tablename> AUTO_INCREMENT = 1;

Alternate to truncate is

DELETE FROM <tablename>;
Profile picture of Cuauhtemoc
Cuauhtemoc
Last edit
Cuauhtemoc
Posted by Cuauhtemoc to Cuauhtemoc's Deck (2018-06-13 15:39)