In the last episode (Jun 09), Blake Schroeder said:
> Query
> UPDATE table SET 1 = '1' WHERE id = '1'
>
> |#1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '1 = '1' WHERE id = '1'' at line 1
Mysql is seeing the 1 as a literal number 1. You can force it to be a
column/table name by putting backtics around it: `1`. You will
probably be happier if you change the column names to something that
doesn't require special treatment, though, like "col1" .. "col28".
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
