FqN8P8j1

1CREATE TABLE IF NOT EXISTS `categories` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(50) NOT NULL,
4  PRIMARY KEY (`id`)
5) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
6
7INSERT INTO `categories` (`id`, `name`) VALUES
8	(1, 'Продукты'),
9	(2, 'Хозяйственные товары'),
10	(3, 'Товары для дома');
11
12CREATE TABLE IF NOT EXISTS `products` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `name` varchar(50) NOT NULL,
15  `category_id` int(11) NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
18
19INSERT INTO `products` (`id`, `name`, `category_id`) VALUES
20	(1, 'Молоко', 1),
21	(2, 'Хлеб', 1),
22	(3, 'Шампунь', 2),
23	(4, 'Молоко', 3),
24	(5, 'Хлеб', 3),
25	(6, 'Газировка', 0);
26
27SELECT products.name as ProductName, categories.name as CategoryName FROM `products` LEFT JOIN `categories` ON products.category_id = categories.id;