MYSQL增加自增列并更新
SET @mycnt = 0;
UPDATE xxxxx
SET RowNum=(@mycnt := @mycnt + 1)
posted @ 2016-07-14 13:33 allenjsl 阅读(1130) 评论(0) 推荐(0)
SET @mycnt = 0;
UPDATE xxxxx
SET RowNum=(@mycnt := @mycnt + 1)
posted @ 2016-07-14 13:33 allenjsl 阅读(1130) 评论(0) 推荐(0)
posted @ 2010-01-20 14:36 allenjsl 阅读(1422) 评论(0) 推荐(0)
posted @ 2009-07-11 12:30 allenjsl 阅读(2415) 评论(16) 推荐(0)