Syntax looks fine to me.
Sub-queries are only supported in 4.1.x+ , I'm guessing that's your problem.
Chris
Lieven De Keyzer wrote:
UPDATE account
SET role_id = (SELECT role_id FROM role WHERE rolename = "admin")
WHERE username = "test"
This gives me an:
ERROR 1064 (00000): 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 'SELECT role_id from role WHERE rolename="admin")'
at line 1
I can't see anything wrong with the syntax?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
