Re: Changing UNIQUE_CHECKS, FOREIGN_KEY_CHECKS & SQL_MODE
Posted by: Rick James
Date: November 25, 2012 09:41PM

No problem.

SET @... is setting variables that are local to the "session". So, if the script dies, so does the session.

Session variables do not affect any other connections.

SET @@GLOBAL.xx -- This would be setting a global variable.

Options: ReplyQuote


Subject
Written By
Posted
Re: Changing UNIQUE_CHECKS, FOREIGN_KEY_CHECKS & SQL_MODE
November 25, 2012 09:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.