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 vote251 views1 answer
Oracle index hint multiple tables example
SQL
25 votes341 views5 answers
Mysql replace text
SQL
0 vote254 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote291 views1 answer
Mssql unique key accept nulls
SQL
24 votes263 views4 answers
Mssql get all table names
SQL
0 vote281 views2 answers
Oracle create tablespace autoextend
SQL
13 votes256 views2 answers
Display users in mysql
SQL
0 vote266 views1 answer
Heidisql check how much space a row
SQL
0 vote290 views1 answer
Influxdb clone measurement
SQL
0 vote303 views1 answer
Mysql faster delete
SQL