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 vote333 views1 answer
Datetime postgres typeorm
SQL
3 votes309 views1 answer
How to remove characters from string in mysql
SQL
11 votes326 views5 answers
How to install sqlite3 python
SQL
1 vote318 views2 answers
Restart identity cascade
SQL
0 vote330 views1 answer
Mariadb select limit offset
SQL
13 votes314 views4 answers
Mysql select last 10 rows
SQL
4 votes322 views2 answers
Oracle sql group by date year
SQL
0 vote286 views1 answer
Java spring boot connect to sql server
SQL
0 vote321 views1 answer
Postgress append string in select
SQL
0 vote376 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL