ANSI Mode and Date Validation

ANSI Mode and Date Validation

am 30.12.2004 14:04:25 von Hassan Shaikh

Hi,

(1) I need to run MySQL in ANSI mode. How and where do I mention --ANSI
in the my.ini file? I don't wanna do it on the command-line.

(2) Similarly, I want MySQL to check for all invalid dates and avoid
storing them. How and where do I mention
sql_mode= NO_ZERO_IN_DATE,NO_ZERO_DATE in my.ini ?


Thanks.


Hassan

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org