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

1 vote202 views2 answers
Login to mysql
SQL
0 vote221 views2 answers
Search stored procedures by name
SQL
0 vote172 views1 answer
Sql order by except one row
SQL
0 vote164 views1 answer
Get who is hired in february in sql
SQL
45 votes243 views5 answers
Grant all privileges mysql
SQL
4 votes160 views1 answer
Mysql biginteger size
SQL
0 vote153 views1 answer
Oracle archivelog usage
SQL
7 votes181 views1 answer
Alter sequence set current value oracle
SQL
1 vote160 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote158 views1 answer
Sql select all tables from database change url
SQL