Dan
Great suggestion also.
-Blake
Dan Nelson wrote:
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".
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
