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 · 2152 阅读 · 1 评论 -
sql对应mongodb的写法
参考自官网http://docs.mongodb.org/manual/reference/sql-comparison/InsertThe following table presents the various SQL statements related toinserting records into tables and the corresponding MongoDB s原创 2014-02-09 18:05:00 · 2694 阅读 · 0 评论