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 vote390 views1 answer
Postgres get database encoding
SQL
0 vote377 views1 answer
Shows all databases created by user in ms sql
SQL
2 votes376 views1 answer
Sql server case sensitive search
SQL
1 vote343 views1 answer
Mysql server does not start mac
SQL
0 vote403 views1 answer
Postgres list tables and row counts
SQL
0 vote420 views1 answer
Virtuoso sql query tutorial
SQL
0 vote357 views1 answer
Codigo crear tablas sql server
SQL
0 vote374 views1 answer
Oracle step procedure
SQL
0 vote387 views1 answer
Mysql show category once count how many products
SQL
0 vote377 views1 answer
Insert or update sql firebird
SQL