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.