mysqlHow to disable foreign keys constraints
SET FOREIGN_KEY_CHECKS = 0;
ctrl + c
FOREIGN_KEY_CHECKS this option disables/enables foreign keys integrity checks |
More of Mysql
- Disable ONLY_FULL_GROUP_BY mode
- How to find duplicate varchar/text column values in table
- Truncate all tables in a specific database
- How to find my.cnf config file
- Get largest tables list
- Insert new values only if row doesn't exist already
- Make a pager (limit / offset) select query
- What is the LONGTEXT column max size (length) in Mysql
- Create unique key
- What is the MEDIUMTEXT column max size (length) in Mysql
See more codes...