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 vote160 views2 answers
How to get json data mysql
SQL
2 votes160 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote173 views1 answer
Tsql get beginning of year
SQL
0 vote185 views2 answers
Jsonb
SQL
1 vote172 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote167 views1 answer
Copying query result to excel
SQL
1 vote170 views2 answers
Replace text in sql
SQL
0 vote178 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote165 views1 answer
Oracle right characters
SQL
0 vote195 views1 answer
How to print some string in mysql
SQL