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
- How to import SQL file (previously dumped) into database
- Get largest tables list
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
- How to duplicate table structure and data
- Create user with root privileges
- Replace string with regex
- Export database tables structure without data
- Skip certain tables while doing dump
See more codes...