Re: Run MySQL with ANSI mode

2004-06-04 Thread Victoria Reznichenko
m> But not working. Because you try to start mysql client with --ansi option, not the server. Run mysqld with the above option or put to the my.cnf file: [mysqld] ansi ym> --- Victoria Reznichenko ym> <[EMAIL PROTECTED]> wrote: >> yau meileng <[EMAIL PROTECTED]> wrote: >

Re: Run MySQL with ANSI mode

2004-06-04 Thread Victoria Reznichenko
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 Wha

Run MySQL with ANSI mode

2004-06-04 Thread yau meileng
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 Why I can't manage to