铁路校友-我拆过的坑cycx

主页:www.j6f.cn知识星球,快手号、抖音号、视频号、微信公众号、百家号、个人博客网站,同名。

记忆一次,半天的sql拼凑,太复杂了

SELECT

*,'XXXXXXXX' as 'trainNo'

FROM

percartinfo 

WHERE

dateAndTime LIKE CONCAT(

"%",(

SELECT

SUBSTRING(( SELECT dateAndTime FROM perTrainInfo WHERE trainNo = "CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1 ), 7, 1 )),

"/%",(SELECT SUBSTRING((SELECT dateAndTime FROM perTrainInfo WHERE trainNo="CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1),10,1)),

"%/",(SELECT left((SELECT dateAndTime FROM perTrainInfo WHERE trainNo="CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1),4)),"%") 


发表评论:

Powered By Z-BlogPHP 1.7.3

Copyright Your WebSite.Some Rights Reserved.