mysql how to truncate table with foreign keys

Solutions on MaxInterview for mysql how to truncate table with foreign keys by the best coders in the world

showing results for - "mysql how to truncate table with foreign keys"

1SET FOREIGN_KEY_CHECKS = 0;
2
3TRUNCATE table1;
4
5SET FOREIGN_KEY_CHECKS = 1;

similar questions

fk in insert mysql mysql add foreign key mysql foreign key constraints mysql create table columns with spaces truncate left characters mysql create table mysql with foreign key alter table add column and foreign key mysql mysql remove foreign key constraint how to connect database foreign key in mysql update foreign key value in mysql alter table add foreign key mysql mysql find foreign key references turn on foreign keys check mysql how to truncate foreign key constraint table mysql alter add foreign key foreign key mysql how to truncate table with foreign key constraint how to force truncate a table in mysql add column mysql with foreign key drop foreign key mysql cannot truncate a table referenced in a foreign key constraint mysql foreign key truncate table mysql drop all foreign key constraints mysql how delete foreign key in mysql how to truncate all table in mysql workbench

queries leading to this page

truncate table mysql with foreign key sql server truncate table mysql with foreign key cannot truncate table foreign key constraint mysql truncate table having foreign key constraint mysql truncate foreign key constraint mysql truncate table with foeign key contraint mysql mysql truncate table with foreign key mysql truncate table with foreign keys truncate table ignore foreign key mysql truncate mysql table with foreign key truncate table mysql with foreign key constraint truncate table foreign key constraint mysql how to force truncate a table with foreign keys in mysql truncate command not work in my table foreign key row in sql mysql how to truncate table with foreign keys mysql truncate table foreign key cannot truncate table foreign key mysql mysql cannot truncate foreign key mysql truncate without foreign key mysql truncate foreign key table mysql truncate ignore foreign key constraints mysql truncate with foreign key truncate table with references in mysql truncate table with foreign key mysql how to truncate table in mysql with foreign key constraint mysql how to truncate table with foreign keys