Re: about deferrable constraint in Google cloud SQL

We focus on ACID transaction ,In particular the data should be consistent at the end of transaction ,but the integrity rules could be temporarily broken during the transaction.
So MySQL cannot break the integrity rules during the transaction right? 

เมื่อ วันพฤหัสบดีที่ 9 สิงหาคม ค.ศ. 2012, 8 นาฬิกา 58 นาที 08 วินาที UTC+7, Razvan Musaloiu-E. เขียนว่า:

I'm not familiar with DB2. In MySQL you can disable the foreign key constraints [1] but you cannot bypass the normal constraints.

[1] http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_foreign_key_checks 

-- Razvan ME

On Wed, Aug 8, 2012 at 6:44 PM, Rast Rastapana <tung_...@hotmail.com> wrote:

Due to some task needed to bypass some value in the beginning (NULL value can't insert into DB because of the integrity constraint) ,

Can i defer integrity constrain on my work like DB2 in each transaction or have another way to defer validation /checking at first but it works  ?

(Like "DEFERRABLE"  declaration on Google Cloud SQL )

Best regards.