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 vote163 views1 answer
Table user postgres
SQL
0 vote161 views1 answer
Character count sql
SQL
2 votes148 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
1 vote198 views1 answer
Oracle transaction rollback not working
SQL
0 vote149 views1 answer
Can sqldatareader be null
SQL
23 votes145 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes154 views1 answer
Sql percentage with % rounded down
SQL
1 vote128 views1 answer
Stop mysql server mac
SQL
0 vote169 views1 answer
Wordpress sql find and replace
SQL
0 vote179 views1 answer
Sql count matching group by
SQL