查询

数据表字段

构造的SQL SELECT * FROM ( SELECT * FROM tp5_system_history_1 UNION SELECT * FROM tp5_system_history_2 UNION SELECT * FROM tp5_system_history_3 UNION SELECT * FROM tp5_system_history_4 UNION SELECT * FROM tp5_system_history_5) AS SystemHistory WHERE `( SELECT * FROM tp5_system_history_1 UNION SELECT * FROM tp5_system_history_2 UNION SELECT * FROM tp5_system_history_3 UNION SELECT * FROM tp5_system_history_4 UNION SELECT * FROM tp5_system_history_5) AS SystemHistory`.`delete_time` IS NULL ORDER BY `sh_id` LIMIT 20这个问题不知道是BUG还是我什么地方做得不对,我感觉是软删除开启后,模型分表构造SQL的时候,直接把联合查询的语句拿过来了
正确的SQL应该是SELECT
*
FROM
(
SELECT
*
FROM
tp5_system_history_1
UNION
SELECT
*
FROM
tp5_system_history_2
UNION
SELECT
*
FROM
tp5_system_history_3
UNION
SELECT
*
FROM
tp5_system_history_4
UNION
SELECT
*
FROM
tp5_system_history_5
) AS SystemHistory
WHERE
`SystemHistory`.`delete_time` IS NULL
ORDER BY
`sh_id`
LIMIT 20

最佳答案

评论() 相关

收藏

赞

519468341

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。