declare cursor aa is SELECT item FROM item_template WHERE name LIKE '%无形%' LIMIT 0, 1000; begin for aaa in aa loop INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES ('15550',aaa.item , '1', '1', '0', '1', '1', '0', '0', '0'); end loop; end;我是这么想的。谁能帮我转换成mysql的啊?我非常非常的菜。
用了游标貌似麻烦了 insert into creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) select '15550',item , '1', '1', '0', '1', '1', '0', '0', '0' FROM item_template WHERE name LIKE '%无形%' LIMIT 0, 1000;
cursor aa is
SELECT item FROM item_template WHERE name LIKE '%无形%' LIMIT 0, 1000;
begin
for aaa in aa loop
INSERT INTO creature_loot_template
(entry,
item,
ChanceOrQuestChance,
lootmode,
groupid,
mincountOrRef,
maxcount,
lootcondition,
condition_value1,
condition_value2)
VALUES
('15550',aaa.item , '1', '1', '0', '1', '1', '0', '0', '0');
end loop;
end;我是这么想的。谁能帮我转换成mysql的啊?我非常非常的菜。
insert into creature_loot_template (entry,
item,
ChanceOrQuestChance,
lootmode,
groupid,
mincountOrRef,
maxcount,
lootcondition,
condition_value1,
condition_value2)
select '15550',item , '1', '1', '0', '1', '1', '0', '0', '0' FROM item_template WHERE name LIKE '%无形%' LIMIT 0, 1000;