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 vote335 views1 answer
Cahnge column name apex oracle
SQL
0 vote330 views1 answer
Get only one row in mysql
SQL
0 vote311 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote324 views1 answer
Import mysql dump database command line linux
SQL
0 vote288 views1 answer
Mysql select row with min date
SQL
8 votes285 views2 answers
Phpmyadmin password
SQL
46 votes367 views4 answers
Create column sql
SQL
0 vote299 views2 answers
How to update date in oracle
SQL
1 vote298 views1 answer
Mysql show table character set
SQL
2 votes278 views1 answer
Oracle sql drop column if exists
SQL