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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql how to truncate table with foreign keys"
Giovanni
29 Jan 2020
1SET FOREIGN_KEY_CHECKS = 0;
2
3TRUNCATE table1;
4
5SET FOREIGN_KEY_CHECKS = 1;