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 vote185 views2 answers
Postgresql gset
SQL
0 vote170 views1 answer
Sql server remove primary key without dropping table
SQL
7 votes183 views2 answers
Postgres concat
SQL
0 vote214 views1 answer
How to check rollback status in oracle
SQL
0 vote166 views1 answer
Convert sql server guid to varbinary
SQL
0 vote178 views1 answer
How to to get time in sql
SQL
3 votes198 views2 answers
Oracle drop sequence
SQL
0 vote166 views1 answer
Jooq replace
SQL
0 vote175 views1 answer
Selecting from a view SQL
SQL
3 votes315 views9 answers
Linq to sql converter online
SQL