On Fri, Feb 02, 2001 at 03:38:09PM -0500, Noah Romer wrote:
> 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
The MySQL manual, Reference >> Reserved Words. 'WHEN' is listed
as a reserved word. Change your field's name.
G'luck,
Peter
--
Nostalgia ain't what it used to be.
---------------------------------------------------------------------
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