MySQL: Is there any possible way to get notified about mysql-server FOREIGN KEY CONSTRAINT violation during INSERT, if FOREIGN_KEY_CHECKS=0 ?
Check out here - the point about using this system (or session) variable is to load tables in an order which is " different from that required by their parent/child relationships". You switch it off for that reason - if you want warnings of breaches of RI (Referential Integrity), then set it to 1 and you will get warnings. It can be set on the session level.