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

13 votes184 views3 answers
Sql select from multiple tables without join
SQL
0 vote205 views1 answer
Linux upload database to mysql
SQL
1 vote166 views1 answer
Sqlite create index
SQL
3 votes159 views1 answer
Select sequence oracle
SQL
0 vote149 views1 answer
Criteria builder select subset of column
SQL
0 vote156 views1 answer
Oracle sql drop table
SQL
1 vote146 views1 answer
How to install mysql 8.0 windows service
SQL
11 votes140 views1 answer
Oracle view ddl
SQL
0 vote154 views1 answer
Stratified sampling sql
SQL
5 votes170 views6 answers
Sql foreign key
SQL