S
S
simplecode2011-08-18 11:36:07
MySQL
simplecode, 2011-08-18 11:36:07

MySQL. RESTRICT blocking?

There are 2 InnoDB tables related by foreign key. The association has a RESTRICT type constraint. For example: tables `country` and `city`.
I'm trying to remove the country that is referenced from `city` - it is not deleted. Everything is correct!
Is it possible to temporarily "ask" the server to forget about this connection and let me delete the record?
I would like to hear any possible options.
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman Gogolev, 2011-08-18
@simplecode

SET FOREIGN_KEY_CHECKS=0;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question