Jeremy Zawodny writes:
> On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
> > Hi People,
> >
> > I'm trying to execute this Simple query:
> >
> > SET SQL_SAFE_MODE=0;
> >
> > The server doesn't like it; However, SET any other option will work fine
> > except this one.
> >
> > I'm still using mysqld v3.23.36 . If someone can try it on the
> > latest version.
>
> On 3.23.41:
>
> mysql> SET SQL_SAFE_MODE=0;
> ERROR 1064: You have an error in your SQL syntax near 'SQL_SAFE_MODE=0' at line 1
>
> It would seem to be documented here:
>
> http://www.mysql.com/doc/S/E/SET_OPTION.html
>
> But I can't make it work.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 0 days, processed 3,341,714 queries (93/sec. avg)
It seems to have changed into:
SQL_SAFE_UPDATES
We will have to fix some docs.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php