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

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

BobbyLou博博

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

阅读量3.8k

点赞数 2

分类专栏： Nodejs sql 文章标签：小黑小波比 nodejs sql

本文链接：https://blog.csdn.net/u010489586/article/details/40378993

版权

Nodejs 同时被 2 个专栏收录

51 篇文章 0 订阅

订阅专栏

sql

7 篇文章 0 订阅

订阅专栏

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"
	},