Clear a table in mysql

Remove all records from table mysql

/* Will delete all rows from your table. Next insert will take next auto increment id. */
DELETE from tableName;
/* Will delete all rows from your table but it will start from new row with 1. */
TRUNCATE tableName;

Clear a table in mysql

TRUNCATE tablename

Similar codes

0 vote269 views1 answer
Mysql error 1452
SQL
0 vote263 views1 answer
How to get data between a last week in mysql
SQL
0 vote255 views2 answers
Azure sql-datenbank
SQL
6 votes259 views2 answers
Join vs union
SQL
5 votes250 views1 answer
Oracle asynchronous procedure
SQL
3 votes245 views1 answer
Mysql UPDate with enner join
SQL
0 vote259 views1 answer
Can sqldatareader be null
SQL
0 vote254 views1 answer
Opensuse stop MySQL
SQL
0 vote256 views1 answer
Sql file in postgres with pgadmin
SQL
2 votes257 views1 answer
Oracle list grants on procedure
SQL