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 vote206 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
8 votes270 views1 answer
Oracle search code in packages
SQL
1 vote264 views1 answer
Find size of all DB's postgres
SQL
0 vote191 views1 answer
Will graphql replace sql
SQL
0 vote199 views1 answer
Mysql server not running
SQL
0 vote195 views1 answer
Primary key multiple colums
SQL
2 votes214 views2 answers
How to rename column name in sql server using query
SQL
5 votes244 views1 answer
Purge undo tablespace usage
SQL
0 vote182 views1 answer
Sqlite to csv statement
SQL
1 vote187 views1 answer
Round function in sql oracle
SQL