2016-7-19 Mysql 更新子查询

sqlserver中更新子查询的语法在Mysql中报错

Mysql:

UPDATE student a,
    (SELECT 
        No
    FROM
        award
    WHERE
        grade = 95) b 
SET 
    a.level = 5
WHERE
    a.No = b.No;

执行前:

  => student

 => award

 

执行后: