嗯. 两个方法 A: 必须使用临时表. set @rownum:=0; INSERT INTO tmpTable select @rownum:=@rownum+1 as 'ListId', id, name from members;INSERT INTO ResultTable SELECT id, name FROM members WHERE ListId % 2 = 1;B: set @rownum:=0; INSERT INTO IGNORE ResultTable SELECT IF((@rownum:=@rownum+1) % 2 = 1, id, Null) id, name FROM members这里要注意的是 ResultTable 表的 Id 字段必须是有设了 NOT NULL 属性 :)
两个方法
A:
必须使用临时表.
set @rownum:=0;
INSERT INTO tmpTable
select @rownum:=@rownum+1 as 'ListId', id, name from members;INSERT INTO ResultTable
SELECT id, name FROM members WHERE ListId % 2 = 1;B:
set @rownum:=0;
INSERT INTO IGNORE ResultTable
SELECT
IF((@rownum:=@rownum+1) % 2 = 1, id, Null) id,
name
FROM members这里要注意的是 ResultTable 表的 Id 字段必须是有设了 NOT NULL 属性
:)