56,940
社区成员




-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 10.1.13-MariaDB - mariadb.org binary distribution
-- 服务器操作系统: Win64
-- HeidiSQL 版本: 9.3.0.4984
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 导出 data_2014 的数据库结构
CREATE DATABASE IF NOT EXISTS `data_2014` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `data_2014`;
-- 导出 表 data_2014.xr_1038 结构
CREATE TABLE IF NOT EXISTS `xr_1038` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`ot` datetime NOT NULL,
`value` double DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `ot` (`ot`)
) ENGINE=MyISAM AUTO_INCREMENT=13379 DEFAULT CHARSET=utf8;
-- 正在导出表 data_2014.xr_1038 的数据:21 rows
DELETE FROM `xr_1038`;
/*!40000 ALTER TABLE `xr_1038` DISABLE KEYS */;
INSERT INTO `xr_1038` (`uid`, `ot`, `value`) VALUES
(7, '2016-05-01 10:01:29', 18),
(8, '2016-05-01 10:01:32', 19),
(9, '2016-05-01 10:01:35', 20),
(10, '2016-05-01 10:01:38', 21),
(11, '2016-05-01 10:01:44', 23),
(12, '2016-05-01 10:01:47', 24),
(13, '2016-05-01 10:01:50', 25),
(14, '2016-05-01 10:01:53', 26),
(15, '2016-05-01 10:01:56', 27),
(16, '2016-05-01 10:01:59', 28),
(17, '2016-05-01 10:02:02', 29),
(18, '2016-05-01 10:02:05', 30),
(19, '2016-05-01 10:02:08', 31),
(20, '2016-05-01 10:02:11', 32),
(21, '2016-05-01 10:02:14', 33),
(22, '2016-05-01 10:02:17', 34),
(23, '2016-05-01 10:02:20', 35),
(24, '2016-05-01 10:02:23', 36),
(25, '2016-05-01 10:02:26', 37),
(26, '2016-05-01 10:02:29', 38),
(27, '2016-05-01 10:02:32', 39);
/*!40000 ALTER TABLE `xr_1038` ENABLE KEYS */;
-- 导出 表 data_2014.xr_1040 结构
CREATE TABLE IF NOT EXISTS `xr_1040` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`ot` datetime NOT NULL,
`value` double DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `ot` (`ot`)
) ENGINE=MyISAM AUTO_INCREMENT=13420 DEFAULT CHARSET=utf8;
-- 正在导出表 data_2014.xr_1040 的数据:25 rows
DELETE FROM `xr_1040`;
/*!40000 ALTER TABLE `xr_1040` DISABLE KEYS */;
INSERT INTO `xr_1040` (`uid`, `ot`, `value`) VALUES
(7, '2016-05-01 10:01:20', 57),
(8, '2016-05-01 10:01:30', 27),
(9, '2016-05-01 10:01:35', 183),
(10, '2016-05-01 10:01:38', 124),
(11, '2016-05-01 10:01:41', 42),
(12, '2016-05-01 10:01:44', 124),
(13, '2016-05-01 10:01:47', 110),
(14, '2016-05-01 10:01:50', 183),
(15, '2016-05-01 10:01:53', 11),
(16, '2016-05-01 10:01:56', 76),
(17, '2016-05-01 10:01:59', 132),
(18, '2016-05-01 10:02:02', 62),
(19, '2016-05-01 10:02:05', 128),
(20, '2016-05-01 10:02:08', 197),
(21, '2016-05-01 10:02:11', 169),
(22, '2016-05-01 10:02:14', 99),
(23, '2016-05-01 10:02:17', 66),
(24, '2016-05-01 10:02:20', 194),
(25, '2016-05-01 10:02:23', 171),
(26, '2016-05-01 10:02:26', 62),
(27, '2016-05-01 10:02:29', 160),
(28, '2016-05-01 10:02:32', 134),
(29, '2016-05-01 10:02:35', 28),
(30, '2016-05-01 10:02:38', 127),
(31, '2016-05-01 10:02:41', 61);
/*!40000 ALTER TABLE `xr_1040` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
mysql> select * from xr_1038;
+-----+---------------------+-------+
| uid | ot | value |
+-----+---------------------+-------+
| 7 | 2016-05-01 10:01:29 | 18 |
| 8 | 2016-05-01 10:01:32 | 19 |
| 9 | 2016-05-01 10:01:35 | 20 |
| 10 | 2016-05-01 10:01:38 | 21 |
| 11 | 2016-05-01 10:01:44 | 23 |
| 12 | 2016-05-01 10:01:47 | 24 |
| 13 | 2016-05-01 10:01:50 | 25 |
| 14 | 2016-05-01 10:01:53 | 26 |
| 15 | 2016-05-01 10:01:56 | 27 |
| 16 | 2016-05-01 10:01:59 | 28 |
| 17 | 2016-05-01 10:02:02 | 29 |
| 18 | 2016-05-01 10:02:05 | 30 |
| 19 | 2016-05-01 10:02:08 | 31 |
| 20 | 2016-05-01 10:02:11 | 32 |
| 21 | 2016-05-01 10:02:14 | 33 |
| 22 | 2016-05-01 10:02:17 | 34 |
| 23 | 2016-05-01 10:02:20 | 35 |
| 24 | 2016-05-01 10:02:23 | 36 |
| 25 | 2016-05-01 10:02:26 | 37 |
| 26 | 2016-05-01 10:02:29 | 38 |
| 27 | 2016-05-01 10:02:32 | 39 |
+-----+---------------------+-------+
21 rows in set (0.00 sec)
mysql> select * from xr_1040;
+-----+---------------------+-------+
| uid | ot | value |
+-----+---------------------+-------+
| 7 | 2016-05-01 10:01:20 | 57 |
| 8 | 2016-05-01 10:01:30 | 27 |
| 9 | 2016-05-01 10:01:35 | 183 |
| 10 | 2016-05-01 10:01:38 | 124 |
| 11 | 2016-05-01 10:01:41 | 42 |
| 12 | 2016-05-01 10:01:44 | 124 |
| 13 | 2016-05-01 10:01:47 | 110 |
| 14 | 2016-05-01 10:01:50 | 183 |
| 15 | 2016-05-01 10:01:53 | 11 |
| 16 | 2016-05-01 10:01:56 | 76 |
| 17 | 2016-05-01 10:01:59 | 132 |
| 18 | 2016-05-01 10:02:02 | 62 |
| 19 | 2016-05-01 10:02:05 | 128 |
| 20 | 2016-05-01 10:02:08 | 197 |
| 21 | 2016-05-01 10:02:11 | 169 |
| 22 | 2016-05-01 10:02:14 | 99 |
| 23 | 2016-05-01 10:02:17 | 66 |
| 24 | 2016-05-01 10:02:20 | 194 |
| 25 | 2016-05-01 10:02:23 | 171 |
| 26 | 2016-05-01 10:02:26 | 62 |
| 27 | 2016-05-01 10:02:29 | 160 |
| 28 | 2016-05-01 10:02:32 | 134 |
| 29 | 2016-05-01 10:02:35 | 28 |
| 30 | 2016-05-01 10:02:38 | 127 |
| 31 | 2016-05-01 10:02:41 | 61 |
+-----+---------------------+-------+
25 rows in set (0.00 sec)
mysql>