Solved

EQUIVALENT OF ANSI_NULLS ON on mysql

Posted on 2008-10-01
3
2,942 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:vijji_lakshmi
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22612286
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

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now