1191.MySQL 的 insert 和 update 的 select 语句语法

SQL insert into student (stuid,stuname,deptid) select 10,'xzm',3
from student where stuid > 8;
update student a inner join student b on b.stuID=10 set
a.stuname=concat(b.stuname, b.stuID) where a.stuID=10 ;