执行第一行后sql查询停止

Question

Using navicat and the problem is I would like to create an event, name it, schedule it, and fill the event with instruction for carry out at a later date. I have the code and when I run the query to create the event it will only paste the very first line of instruction set into the event schedule. example here is the code......

CREATE EVENT `replaceTents` ON SCHEDULE EVERY 1 HOUR COMMENT 'Changes Tents to Map Items' DO

UPDATE `Object_DATA` SET `Classname` = 'Land_Campfire_burning' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar2oz"],[2]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'WarfareBunkerSign' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar2oz"],[2]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'Land_Fire_barrel_burning' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar10oz"],[2]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'HeliHCivil' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar10oz"],[5]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'Land_Ind_TankSmall' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar10oz"],[9]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'Land_Ind_IlluminantTower' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemBriefcase100oz"],[1]],[[],[]]]';

UPDATE `Object_DATA` SET `Classname` = 'WarfareBAirport' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemBriefcase100oz"],[3]],[[],[]]]';

So the problem is this is the only one that shows up saved inside the event because its first on the list, How would I carry on with the SQL to print the entire set into a single event schedule?

UPDATE `Object_DATA` SET `Classname` = 'Land_Campfire_burning' AND `Inventory` = '[]' WHERE `Classname` = 'TentStorage' AND `Inventory` = '[[[],[]],[["ItemGoldBar2oz"],[2]],[[],[]]]';

Thanks in advance..

Answer 1

I believe you need to use the DO BEGIN ... END as shown in the last example of http://www.sitepoint.com/how-to-create-mysql-events/

EDIT 1: Also, as mentioned at http://dev.mysql.com/doc/refman/5.1/en/create-event.html:

As with stored routines, you can use compound-statement syntax in the DO clause by using the BEGIN and END keywords