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

1 vote102 views3 answers
Remove unique key from a table
SQL
0 vote110 views1 answer
Mysql default timestamp value to be current timestamp
SQL
1 vote115 views1 answer
Convert to hexadecimal sql
SQL
0 vote114 views3 answers
How to increase size of column in sql
SQL
8 votes110 views1 answer
Oracle add months to sysdate
SQL
0 vote99 views1 answer
Drop all tables in azure sql database
SQL
0 vote114 views1 answer
Disableforiegn key check
SQL
0 vote101 views1 answer
Alter table fulltext
SQL
11 votes106 views5 answers
How to install sqlite3 python
SQL
0 vote122 views1 answer
Oracle last connexion
SQL