Answers for "mysql query delete all rows from table except one"

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;

Posted by: Guest on December-29-2020

Code answers related to "mysql query delete all rows from table except one"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql query delete all rows from table except one"

Code answers related to "mysql query delete all rows from table except one"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql query delete all rows from table except one"

Code answers related to "mysql query delete all rows from table except one"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us