您是否正在寻找这样的东西？
UPDATE textile_events e, (SELECT @n := 249) m SET e.seq_no = @n := @n + 1 WHERe e.eid = 'headsup' AND e.paid = 'paid'
SQLFiddle
您是否正在寻找这样的东西？
UPDATE textile_events e, (SELECT @n := 249) m SET e.seq_no = @n := @n + 1 WHERe e.eid = 'headsup' AND e.paid = 'paid'
SQLFiddle
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
