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 vote301 views3 answers
Duplicate row mysql
SQL
8 votes287 views2 answers
Safe update mode in mysql
SQL
0 vote283 views1 answer
Empty table sqlite
SQL
0 vote274 views1 answer
Date diff sql
SQL
0 vote297 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote274 views1 answer
Inner joint
SQL
0 vote274 views1 answer
A network or instance-specific error sql server
SQL
8 votes275 views2 answers
Mysql query dates between two dates
SQL
3 votes287 views1 answer
Fk in insert mysql
SQL
6 votes278 views2 answers
WHERE value IS sql
SQL