作者koehie (开喜乌龙茶)
看板Database
标题Re: [SQL ] 如何下此update指令
时间Sat Oct 22 00:38:32 2011
试试看!!
update a
set a.no = (select b.no from b where a.id = b.id)
where exists (select b.no from b where a.id = b.id)
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.233.168.82
1F：推 mitsui0309:谢谢，我受用无穷 10/25 14:12