update
from 表A,表B
set 表A.class='aaa',表B.class='aaa'
where 表A.class=表A.classdelete
from 表A,表B
set 表A.class='aaa',表B.class='aaa'
where 表A.class=表A.class
from 表A,表B
set 表A.class='aaa',表B.class='aaa'
where 表A.class=表A.classdelete
from 表A,表B
set 表A.class='aaa',表B.class='aaa'
where 表A.class=表A.class
delete
from 表A,表B
set 表A.class='aaa',表B.class='aaa'
where 表A.class=表A.class
应该是:
delete
from 表A,表B
where 表A.class=表A.class
the update command i agree with CMIC(大象)
but the delete command i agree with zhehui(小慧)