mysql8 有2个表,需要提取两个表全部数据减去第一个表和第二个表共同的数据。
方法一:
(SELECT * FROM
(SELECT *
FROM alantop_test01
UNION
SELECT * FROM kst_jq
) AS combined
WHERE combined.jq NOT IN
(
SELECT a.jq
FROM alantop_test01 a
INNER JOIN kst_jq b ON a.jq = b.jq
))
UNION
(SELECT * FROM alantop_test01 WHERE jq IN (SELECT a.jq
FROM alantop_test01 a
INNER JOIN kst_jq b ON a.jq = b.jq))
方法二:
alantop_生成趋势图示例
SELECT `t1`.`id` AS `id`,`t1`.`day_day` AS `day_day`, COALESCE(`t2`.`number`,0) AS `value`
FROM (`alantop_标准七日` `t1`
LEFT JOIN `alantop_7日报修` `t2` ON((`t1`.`day_day` = `t2`.`day_counter`)))
ORDER BY `t1`.`day_day` DESC
alantop_7日报修
SELECT `kst_day`.`id` AS `id`,`kst_day`.`day_day` AS `day_day`
FROM `kst_day`
WHERE ((`kst_day`.`day_day` > (CURDATE() - INTERVAL 7 DAY)) AND (`kst_day`.`day_day` <= CURDATE()))
CREATE TABLE `kst_day` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`day_day` DATE NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=112
;