Friday, June 04, 2004, 1:24:35 PM, you wrote: ym> Hi Victoria,
ym> Am running mysql Ver 11.18 Distrib 3.23.54, for ym> redhat-linux-gnu (i386) ym> Yes. In the documentation it asked us to specify ym> option --ansi.I try to type this at the shell: ym> $ mysql --ansi ym> 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: >> > 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]