The type is a varchar.
-Blake
Ronan Lucio wrote:
Blake,
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
Is the column 1 string type?
If itīs numec type. You should use SET 1=1 instead of SET 1='1'
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]