Re: [SQL ] update 遞增數列

[chipai (...)]

※ 引述《chipai (...)》之銘言：
: 我的DBMS是Mysql
: 如果想要update 一欄位為遞增的數列
: 請問該如何下script?
: 謝謝

SET @var =0;
 UPDATE table a,
 (
     SELECT id,@var := @var +1 AS place
     FROM table
     ORDER BY id
 )b
 SET a.place = b.place WHERE a.id = b.id;


--


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 118.160.236.240
→ chenstin:update也可以這樣寫
→ chenstin:UPDATE table SET place = @var := @var + 1 ORDER BY id