UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]orUPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
不支持 UPDATE ... SET ... SELECT
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]orUPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
不支持 UPDATE ... SET ... SELECT
set city=s.title
where u.id=log.userid
and s.id=log.sid
and u.id=896这样??也不行啊,说“1109 - Unknown table 'log' in where clause”
set u.city=s.title
where u.id=log.userid
and s.id=log.sid
and u.id=896