求助查询语句

caoqinghua caoqinghua 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
现在有两张表xr_1038和xr_1040两张表.两张表结构一样
我想查询出如下数据,可以查询到吗?
ot xr_1038 xr_1040
2016-05-01 10:01:30 18 57
2016-05-01 10:01:52 25 11

库表结构



-- --------------------------------------------------------
-- 主机: 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 */;


...全文
评论 6
收藏 已收藏
分享
返回顶部
caoqinghua
MySQL 57,062 成员 56,759 内容