-
Notifications
You must be signed in to change notification settings - Fork 0
/
update.sql
12 lines (11 loc) · 1.08 KB
/
update.sql
1
2
3
4
5
6
7
8
9
10
11
12
/*
UPDATE `mega`.`options` SET `choice` = 'Al Badia Golf Club <span>(18th Hole, Par 5)</span>' WHERE `options`.`option_id` =14;
UPDATE `mega`.`options` SET `choice` = 'Emirates Golf Club <span>(Majlis course)</span>' WHERE `options`.`option_id` =7;
UPDATE `mega`.`options` SET `choice` = 'Abu Dhabi HSBC Golf Championship <span>(in association with the Abu Dhabi Tourism and Cultural Authority)</span>' WHERE `options`.`option_id` =107;
UPDATE `mega`.`options` SET `choice` = 'Emirates Golf Club (Majlis Course)' WHERE `options`.`option_id` =21;
UPDATE `mega`.`options` SET `choice` = 'Emirates Golf Club - Majlis Practice Facility' WHERE `options`.`option_id` =42;
*/
INSERT INTO `mega`.`options` (`qid` ,`choice` ,`file_name`) VALUES ('9', 'Trojan Batteries', 'trojan.jpg');
INSERT INTO `mega`.`options` (`qid` ,`choice` ,`file_name`) VALUES ('9', 'Club Car', 'clubcar.jpg');
INSERT INTO `mega`.`options` (`qid` ,`choice` ,`file_name`) VALUES ('9', 'Flowtronex', 'flowtronex.jpg');
INSERT INTO `mega`.`options` (`qid` ,`choice` ,`file_name`) VALUES ('9', 'Toro', 'toro.jpg');