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
- What is the INT column max value and size
- What is the LONGTEXT column max size (length) in Mysql
- Truncate all tables in a specific database
- Disable ONLY_FULL_GROUP_BY mode
- How to find duplicate varchar/text column values in table
- How to find my.cnf config file
- Get largest tables list
- Export database tables structure without data
- Rename table column
- Insert new values or update if row exists
See more codes...