· 8 years ago · Jan 29, 2018, 09:40 PM
1CREATE TABLE IF NOT EXISTS `bajos` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `bajo` char(50) COLLATE utf8_spanish_ci DEFAULT NULL,
4 KEY `id` (`id`),
5) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
6
7CREATE TABLE IF NOT EXISTS `galerias` (
8 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9 `id_bajo` int(11) DEFAULT NULL,
10 `imagen_horizontal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
13
14SELECT b.*, g.*
15FROM bajos b, galerias g
16WHERE b.id = g.id_bajo
17
18SELECT b.*, g.*
19FROM bajos b, galerias g