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 vote374 views1 answer
Oracle sql developer closed connection
SQL
1 vote281 views1 answer
Postgres grant read only access to database
SQL
-1 vote331 views1 answer
Extract Data from SQL Server into XML Format
SQL
3 votes332 views1 answer
MySQL DELETE JOIN
SQL
1 vote364 views1 answer
Mysql take number in string
SQL
2 votes320 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote337 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
3 votes351 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
1 vote325 views1 answer
Mysql show long running queries
SQL
1 vote352 views1 answer
Key validation sql
SQL