mysql查询选择键并插入

SELECt

您应该将子弹对加载到表中：

CREATE TABLE pairs        (        slug1 VARCHAr(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,        slug2 VARCHAr(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL        );

，将其与您的货币对一起加载，然后发出以下语句：

INSERT IGNOREINTO    Articles (slug)SELECT  slug1FROM    pairs;INSERT IGNOREINTO    Articles (slug)SELECt  slug2FROM    pairs;INSERTINTO    pairs (from_id, to_id)SELECt  a1.id, a2.idFROM    pairsJOIN    articles a1ON      a1.slug = slug1JOIN    articles a2ON      a2.slug = slug2;