yau meileng <[EMAIL PROTECTED]> wrote:
> I try to run MySQL with ansi mode but failed. This was
> what I did:
> 
> mysql> SET GLOBAL sql_mode='ansi';
> ERROR 1064: You have an error in your SQL syntax near
> 'sql_mode='ansi'' at line 1

What version do you use? The above syntax is supported since 4.1.1.
 
> Why I can't manage to change to ansi mode?
> 

Start MySQL server with --ansi option.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to