17,377
社区成员
发帖
与我相关
我的任务
分享
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;
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的啊?我非常非常的菜。