'when' is a reserved word in 3.23
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -----Original Message-----
> From: Noah Romer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 14:38
>
> In the process of moving a database to a new server, I
> decided to upgrade to
> the 3.23 series MySQL, as it had been declared "stable" and
> has some new
> features I want to investigate. However, I've had to drop
> back to 3.22.22, as I
> started getting an "invalid SQL syntax" error on certain
> insert commands.
> Specifically, when I try to do an insert into a change
> logging table in our bug
> tracking database, I get "ERROR 1064: You have an error in
> your SQL syntax". An
> example would be the following, which I tried from the
> command line mysql
> client when our bug tracking software started complaining
> about not being able
> to log changes:
>
> mysql> insert into bugs_activity
> (bug_id,who,when,field,oldvalue,newvalue)
> values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
> ERROR 1064: You have an error in your SQL syntax near
> 'when,field,oldvalue,newvalue) values
> (334,18,20010131145149,'bug_status','NEW','' at line 1
>
> I can't find anything in the above SQL command that would
> constitute invalid
> syntax, and MySQL 3.22.22 doesn't have any problems with it,
> so I was wondering
> if anyone on this list might have an idea as to what's going on.
>
> The systems involved here are dual processor Linux machines.
> I've tried this
> using the MySQL-3.23.32-1 rpms (installed on the new system,
> which is running
> RedHat 6.2 on dual PIII 933's) and using the source code
> (mysql-3.23.32.tar.gz), compiled and running on the old
> system (a dual PPro
> system running a heavily modified RedHat 5.1). The result are
> the same in
> either case.
---------------------------------------------------------------------
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
