update score
set score.stuno=
(
select student.stuno
from student
where student.name=score.name
)
set score.stuno=
(
select student.stuno
from student
where student.name=score.name
)
调试欢乐多
to liupingsk(往事随风.......) :重名的怎么办?to skyboy0720(飞) ( ) :比如说student表中有两个zhangto lidengdeng(lidengdeng) ( ) :数据量只有几千条to lzymagi(lzy_xy) :马上试试看
SET id =
(SELECT id
FROM _stu
WHERE _stu.name = _cou.name)
WHERE ((SELECT COUNT(*)
FROM _stu
WHERE _stu.name = _cou.name) = 1)