Answers for "truncate table in my sql"

truncate table mysql

TRUNCATE TABLE `fourniture`

Posted by: Guest on April-01-2020

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

Code answers related to "truncate table in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "truncate table in my sql"

Code answers related to "truncate table in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "truncate table in my sql"

Code answers related to "truncate 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