Re: 3.22 database on 3.23 with field names 'when' will causes errors

2001-01-23 Thread Tomi Junnila 

* 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.


-- 
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland

-
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

Re: 3.22 database on 3.23 with field names 'when' will causes errors

2001-01-23 Thread Tim Bunce 

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