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

10 votes186 views1 answer
Oracle dba_dependencies
SQL
2 votes295 views2 answers
How to DROP a table in mysql
SQL
0 vote205 views1 answer
Check if mysql db is used
SQL
0 vote169 views1 answer
Inser into example
SQL
-2 votes286 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote204 views2 answers
Find nth highest salary of an employee
SQL
10 votes187 views4 answers
Primary key sql
SQL
0 vote213 views1 answer
Alter domain sql
SQL
4 votes179 views1 answer
Sql any
SQL
0 vote185 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL