mysqlHow to disable foreign keys constraints
SET FOREIGN_KEY_CHECKS = 0;ctrl + cFOREIGN_KEY_CHECKSthis option disables/enables foreign keys integrity checks |
More of Mysql
- Truncate all tables in a specific database
- What is the INT column max value and size
- Insert/update multiple rows in single query
- Skip certain tables while doing dump
- How to find my.cnf config file
- Export database tables structure without data
- How to import SQL file (previously dumped) into database
- Get largest tables list
- Disable query caching for specific query
- Rename table column
See more codes...