56,678
社区成员
发帖
与我相关
我的任务
分享
declare @i int
declare @s VARCHAR
set @i=5
while @i<18652
BEGIN
set @s= select MD5(right((select uname from es_member where member_id=@i),6))
update es_member set password=@s where es_member.member_id=@i
set @i=@i+1
end
CREATE PROCEDURE p_test()
BEGIN
-- declare @i int;
-- declare @s VARCHAR;
set @i=5;
while @i<18652 DO
set @s= ( select MD5(right((select uname from es_member where member_id=@i),6)) );
update es_member set password=@s where es_member.member_id=@i;
set @i=@i+1;
END WHILE;
END;