Navicat中mysql版本低,不支持with as 语句怎么办?

将with as 语句换成 创建临时表语句 create  temporary table a (SELECT * FROM sms_record WHERE mobile15810539987 AND app_idtrade A

将with as 语句换成 创建临时表语句

create  temporary table a (SELECT * FROM sms_record
WHERE mobile = '15810539987'
AND app_id = 'trade'
AND app_name = 'trade'
AND message LIKE '短信通道组测试%'
AND sent_time > '2021-09-09 14 : 30 : 00')

select * from a

with as 和 temporary 一个道理,都是将公用部分放到临时表中

发布者:admin,转转请注明出处:http://www.yc00.com/web/1740119149a4192691.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信