insert into cdb_memberfields select '2238','',......
union all select '2239','',......
union all select '2240','',.....
..
..
..
union all select '2883','',...
我想不出更好的办法了
union all select '2239','',......
union all select '2240','',.....
..
..
..
union all select '2883','',...
我想不出更好的办法了
BEGIN
DECLARE i INT DEFAULT 2238;
WHILE i <= 2883 DO
INSERT INTO `cdb_memberfields` ( `uid` , `nickname` , `site` , `alipay` , `icq` , `qq` , `yahoo` , `msn` , `taobao` , `location` , `customstatus` , `medals` , `avatar` , `avatarwidth` , `avatarheight` , `bio` , `signature` , `sightml` , `ignorepm` , `groupterms` , `authstr` ) VALUES (i, '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '');
set i = i + 1;
END WHILE;
END;