耀眼的橘子的gravatar头像
耀眼的橘子 2017-09-15 11:52:27

mysql sql查询转换为mongoDB NOSQL的脚本

我写了一个MYSQL,谁能帮我转化一下 NOSQL

INSERT INTO hlq_user_privateuser(fromUserID ,fromNickName ,toUserID , toNickName, isDeleted ,showFlag ,deletedOn ,dataJson)
SELECT  fromUserID ,fromNickName ,toUserID , toNickName,0, 1, createdon,()
FROM hlq_user_privatechat WHERE privateID IN (
SELECT MAX(privateID) FROM hlq_user_privatechat GROUP BY CONCAT(IF(`fromUserID` < `toUserID`, `fromUserID`, `toUserID`),
 IF(`fromUserID` > `toUserID`, `fromUserID`, `toUserID`)) )
所有回答列表(0)
顶部 客服 微信二维码 底部
>扫描二维码关注最代码为好友扫描二维码关注最代码为好友