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 vote392 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote418 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote366 views1 answer
Oracle tablespace autoextend
SQL
1 vote379 views1 answer
Replace all numbers in mysql
SQL
0 vote378 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote360 views4 answers
What is unique key in sql
SQL
0 vote349 views1 answer
Sql contains vs like
SQL
25 votes371 views5 answers
Date in mysql
SQL
12 votes355 views4 answers
Mysql get date difference in hours
SQL
1 vote331 views1 answer
Mysql find tables with column name
SQL