在mssql中的语句
"update tab2 set grade = q.grade from tab2 as p,tab1 as q where p.dwdm=q.dwdm"翻译成 mysql
"update tab2 set grade = q.grade from tab2 as p,tab1 as q where p.dwdm=q.dwdm";
语法报错
请教mysql 5.1中是否支持 update from 语句
如不支持如何处理这种情况
"update tab2 set grade = q.grade from tab2 as p,tab1 as q where p.dwdm=q.dwdm"翻译成 mysql
"update tab2 set grade = q.grade from tab2 as p,tab1 as q where p.dwdm=q.dwdm";
语法报错
请教mysql 5.1中是否支持 update from 语句
如不支持如何处理这种情况
update tab2 as p,tab1 as q set p.grade = q.grade where p.dwdm=q.dwdm;