wx0FMNxk

1SCHEMA:
2CREATE TABLE IF NOT EXISTS `flat` (
3  `number` int(6) unsigned NOT NULL,
4  `count_room` int(5) NOT NULL,
5  `floor` int(3) unsigned NOT NULL,
6  `square` int(10) NOT NULL,
7  PRIMARY KEY (`number`)
8) DEFAULT CHARSET=utf8;
9 
10CREATE TABLE IF NOT EXISTS `persons` (
11  `id` int(6) unsigned NOT NULL,
12  `fio` varchar(40) NOT NULL,
13  `flat` int(6) NOT NULL,
14  PRIMARY KEY (`id`)
15) DEFAULT CHARSET=utf8;
16 
17 
18  INSERT INTO flat (number, count_room, floor, square) VALUES (1, 2, 1, 60);
19  INSERT INTO flat (number, count_room, floor, square) VALUES (2, 3, 2, 80);
20 
21  INSERT INTO persons (id, fio, flat) VALUES (1, "PVA", 1);
22  INSERT INTO persons (id, fio, flat) VALUES (2, "MAI", 2);
23
24
25
26
27
28SQL QUERY:
29SELECT * FROM flat WHERE number = 0 UNION SELECT version(),md5(1),3, 4;