mysql修改查询语句

eg:

UPDATE `表A` AS A
INNER JOIN (   SELECT   列名a,   列名b FROM  表b WHERE 列名c = 1) AS B ON A.列名a = B.列名a  AND a.列名b='123'
SET A.列名b = '值', A.列名c = CONCAT( '365',   b.列名b);

update score as a inner join(select stuno from student where stuno>20) as b on a.stuno=b.stuno set a.score=a.score+20

 

 

 

 

转载于:https://my.oschina.net/u/3799758/blog/1858771