摘要：
UPDATE t_users SET t_users.id=u.num1 FROM t_users INNER JOIN (SELECT row_number() over(order by id) AS num1,UserName FROM t_users) u ON u.UserName=t_u 阅读全文
posted @ 2016-05-13 23:23 hehoge 阅读(655) 评论(0) 推荐(0)
|
|||
|
摘要：
UPDATE t_users SET t_users.id=u.num1 FROM t_users INNER JOIN (SELECT row_number() over(order by id) AS num1,UserName FROM t_users) u ON u.UserName=t_u 阅读全文
posted @ 2016-05-13 23:23 hehoge 阅读(655) 评论(0) 推荐(0) |
|||
浙公网安备 33010602011771号