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 vote140 views1 answer
Sql server user permissions and roles
SQL
0 vote147 views1 answer
Modifier une valeur sql
SQL
0 vote143 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote142 views1 answer
Mysql foreach insert
SQL
0 vote141 views1 answer
Datatables server side filter where clause
SQL
0 vote134 views1 answer
Can't connect to postgresql mac os
SQL
4 votes134 views1 answer
Oracle error line
SQL
3 votes129 views2 answers
Mysql create database
SQL
0 vote130 views3 answers
Get free card roblox
SQL
0 vote133 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL