EQUIVALENT OF ANSI_NULLS ON on mysql

Hi all, we are migrating our database from mssql to mysql.
while migrating a triigger i have a code in mssql trigger as below
SET ANSI_NULLS ON
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET QUOTED_IDENTIFIER ON

if i do the same in mysql trigger it is giving error as Unknown system variable 'ANSI_NULLS'.
please let me know the equivalent of the above syatem varibles in mysql.
Regards,
vijaya
vijji_lakshmiAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
MySQL does not have any of those.
>SET ANSI_NULLS ON
in MySQL, that is the behaviour anyhow.
SET ANSI_NULLS OFF -> would mean that NULL + something = something, with SET ANSI_NULLS ON   -> NULL + something = NULL

etc...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.