aRk7rEz2

1CREATE TABLE IF NOT EXISTS `events` (
2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `name` varchar(255) COLLATE utf8_bin NOT NULL,
4  `places_id` int(9) unsigned DEFAULT NULL,
5  PRIMARY KEY (`id`),
6  KEY `fk_events_places` (`places_id`),
7) ENGINE=InnoDB;
8ALTER TABLE `events`
9  ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`places_id`) REFERENCES `places` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
10
11CREATE TABLE IF NOT EXISTS `places` (
12  `id` int(9) unsigned NOT NULL AUTO_INCREMENT,
13  `name` varchar(255) COLLATE utf8_bin NOT NULL,
14  PRIMARY KEY (`id`),
15) ENGINE=InnoDB; 
16     
17SELECT events.col1, events.col2, places.name
18   FROM events LEFT OUTER JOIN places
19      ON events.places_id = places.id