小黑小波比.sql语句过长换行解决方法

最新推荐文章于 2023-06-06 10:49:31 发布

weixin_34306446

最新推荐文章于 2023-06-06 10:49:31 发布

阅读量366

点赞数

文章标签： python

原文链接：https://my.oschina.net/snowbobo/blog/414850

版权

2019独角兽企业重金招聘Python工程师标准>>>

1.在当sql语句过长时。

"infos_getsubscrib": {
		sql: "select * from events t  left join (select count(*) as sends,ecode from events_push group by ecode) b  on t.ecode= b.ecode  left join (select count(*) as count,ecode from events_push where status = 1 group by ecode) c  on t.ecode = c.ecode  where t.revent=:revent"
	},

2.通过换行方式来解决。

"infos_getsubscrib": {
		sql: "select * from events t "
		+" left join (select count(*) as sends,ecode from events_push group by ecode) b "
		+" on t.ecode= b.ecode "
		+" left join (select count(*) as count,ecode from events_push where status = 1 group by ecode) c "
		+" on t.ecode = c.ecode "
		+" where t.revent=:revent"
	},

转载于:https://my.oschina.net/snowbobo/blog/414850