how to clear entire table in my sql

mysql empty a table

-- If you do not need a condition or limit the rows:
TRUNCATE TABLE tblYourTable; -- Not Foreign key constrained

-- Or

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE YourTable1;
TRUNCATE YourTable2;

SET FOREIGN_KEY_CHECKS = 1;

-- --------------------------------------------------------
-- Otherwise:
DELETE FROM tblYourTable WHERE condition;

-- Or

DELETE FROM tblYourTable LIMIT row_count;

Posted by: Guest on May-11-2020

/* 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;

Code answers related to "how to clear entire table in my sql"

Browse Popular Code Answers by Language

Answers for "how to clear entire table in my sql"

Code answers related to "how to clear entire table in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us