ex7Hi9dh

1delimiter |
2
3CREATE EVENT IF NOT EXISTS schedule_updation
4ON SCHEDULE EVERY 1 DAY
5STARTS CURRENT_DATE()
6DO
7  ALTER TABLE `bookings` DROP COLUMN `Date1`;
8  ALTER TABLE `bookings` CHANGE `Date2` `Date1` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
9  ALTER TABLE `bookings` CHANGE `Date3` `Date2` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
10  ALTER TABLE `bookings` CHANGE `Date4` `Date3` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
11  ALTER TABLE `bookings` CHANGE `Date5` `Date4` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
12  ALTER TABLE `bookings` CHANGE `Date6` `Date5` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
13  ALTER TABLE `bookings` ADD `Date6` TEXT after `Date5`;
14
15  delimiter ;
16	
17#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `bookings` CHANGE `Date2` `Date1` TEXT CHARACTER SET latin1 COLLATE ' at line 6
18	
19CREATE...
20DO single_statement;
21	
22CREATE ...
23DO BEGIN
24    statement1;
25    statement2;
26    ...
27END
28	
29ALTER TABLE `bookings` CHANGE `Date2` `Date1` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;
30	
31ALTER TABLE `bookings` CHANGE `Date2` `Date1` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci null default null;