![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
weiweicao0429
这个作者很懒,什么都没留下…
展开
-
多表关联实现左连接
表A,表B,表C,表D,ABC实现关联,并C与D实现左连接 select * from A,B,C left join D on C.id=D.id 例子:select * from (select distinct pcc.PAY_CHANNEL_ID, z.IDENTITY_ID, x.API_TYPE, z.CREATE_TIME,Z.LAST_UPDATE_TIME,原创 2013-12-26 16:36:09 · 2139 阅读 · 1 评论 -
sql对应mongodb的写法
参考自官网http://docs.mongodb.org/manual/reference/sql-comparison/ Insert The following table presents the various SQL statements related toinserting records into tables and the corresponding MongoDB s原创 2014-02-09 18:05:00 · 2692 阅读 · 0 评论