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:
>
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
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