What is the scope of 'SET foreign_key_checks = 0'?

Question

Can't really find any details on this, but is the scope of 'SET foreign_key_checks = 0' the current connection, current session or current transaction?

I'd say that my question is formulated better than the one referred to above. At least my question ends with a question mark... — sbrattla, Aug 16 '13 at 20:19

score 8 · Accepted Answer · answered Jan 22 '13 at 14:36

8

It's a session-based statement.

This is to temporarily break the Foreign Key Constraint. It is sometimes necessary to change data in a way that referential integrity needs to be broken during the modification process.

answered Jan 22 '13 at 14:36

John Woo

249,283
65
481
481

you answered first, so I'll mark your question as correct. – sbrattla Jan 22 '13 at 15:01
gee thanks, you're welcome! – John Woo Jan 22 '13 at 15:04

Giacomo1968 · Answer 2 · 2018-10-09T15:55:34.600

7

It is session-based. Full answer and explanation can be found in this other Stack Overflow answer:

“It is session-based. Do a test to be sure, but that's my understanding of it.”

edited Oct 09 '18 at 15:55

answered Jan 22 '13 at 14:36

Giacomo1968

24,837
11
67
96

1

Thanks! I've upvoted your question. – sbrattla Jan 22 '13 at 15:02
Thumbs up for giving the source – Yonn Trimoreau Oct 09 '18 at 15:46

What is the scope of 'SET foreign_key_checks = 0'?

2 Answers2

Linked