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]