On Tue, Jan 23, 2001 at 01:26:59PM +0200, Tomi Junnila wrote:
> * Santeri Paavolainen <[EMAIL PROTECTED]> wrote on 23.01.01 13:05:
> > >Fix:
> > SELECTs can be worked around with table aliases, others not.
>
> Oops, I forgot to include the cure. The first way to do this I encountered
> is to simply mysqldump the whole table into a text file, then search and
> replace "when" with something else, and finally drop the table and run the
> text file into mysql.
>
> Another way to do this might be with "create table temporary_table ({fields
> valid in 3.23}) select {fields from old table with aliases} from old_table"
> but I haven't tried this myself.
And another way would be to put the offending in quotes.
>From memory you can use the non-portable form:
`when`
or, if running with --ansi, use the standard
"when"
Tim.
---------------------------------------------------------------------
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