Answers for "mysql drop all rows from table"

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

delete all rows from table mysql

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

Posted by: Guest on January-23-2021

Code answers related to "mysql drop all rows from table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql drop all rows from table"

Code answers related to "mysql drop all rows from table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql drop all rows from table"

Code answers related to "mysql drop all rows from table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us