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

9 votes102 views3 answers
Mysql show table column full description
SQL
0 vote110 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote108 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote109 views1 answer
Drop all procedures sql server
SQL
1 vote90 views1 answer
Delete triger pl pg sql
SQL
0 vote114 views1 answer
How to reset the database value in SQL server
SQL
1 vote109 views2 answers
Snowflake alter column data type
SQL
0 vote105 views1 answer
Mysql docker image arjun
SQL
0 vote99 views1 answer
Json_remove mysql
SQL
1 vote100 views1 answer
Postgresql not in
SQL