seuqEZkM

1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
6/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
7/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
8
9
10# Дамп таблицы test
11# ------------------------------------------------------------
12
13DROP TABLE IF EXISTS `test`;
14
15CREATE TABLE `test` (
16  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
17  `datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
18  `dateint` int(11) DEFAULT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21
22LOCK TABLES `test` WRITE;
23/*!40000 ALTER TABLE `test` DISABLE KEYS */;
24
25INSERT INTO `test` (`id`, `datetime`, `dateint`)
26VALUES
27	(1,'2016-09-28 19:49:14',1475074414),
28	(2,'2016-09-28 19:49:15',1475074415),
29	(3,'2016-09-28 19:49:16',1475074416),
30	(4,'2016-09-28 19:49:16',1475074416),
31	(5,'2016-09-28 19:49:17',1475074417);
32
33/*!40000 ALTER TABLE `test` ENABLE KEYS */;
34UNLOCK TABLES;
35
36
37
38/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
39/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
40/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
41/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
42/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
43/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
44
45
46# Запросы для проверки. Раскоментируйте по одному для проверки каждого из полей.
47# для timestamp
48#SELECT * FROM `test` ORDER BY `datetime` LIMIT 3;
49#SELECT * FROM `test` ORDER BY `datetime` LIMIT 3 OFFSET 3;
50# для int
51#SELECT * FROM `test` ORDER BY `dateint` LIMIT 3;
52#SELECT * FROM `test` ORDER BY `dateint` LIMIT 3 OFFSET 3;