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 vote123 views1 answer
Sql insert tuple
SQL
1 vote128 views1 answer
Sql trigger before delete
SQL
2 votes122 views1 answer
Get first 3 letters name in sql
SQL
0 vote141 views1 answer
How to create a table based on another table in mysql
SQL
0 vote125 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote165 views1 answer
Postgres foreign key multiple columns
SQL
0 vote142 views2 answers
How to get the date from datetime in mysql
SQL
4 votes125 views1 answer
Mysql set max connections
SQL
0 vote131 views1 answer
Sum values by month mariadb
SQL
4 votes136 views3 answers
Count with where
SQL