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 vote119 views1 answer
Which MySQL data type to use for storing boolean values
SQL
4 votes65 views1 answer
Install postgres 12 on ubuntu
SQL
1 vote134 views1 answer
How to group by month using sql server
SQL
20 votes113 views1 answer
Sql change column types
SQL
0 vote122 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote126 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote137 views1 answer
Query for backup a database at another location in file system
SQL
0 vote120 views1 answer
Kill slow queries mysql
SQL
0 vote116 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote109 views1 answer
Sql put two columns into one
SQL