相关请求MySQL，MongoDB中的模拟
好日子亲爱的同事们，我决定将一些项目从MySQL迁移到MongoDB并面临一些困难：
例如，MySQL中有两个表：
用户：
CREATE TABLE `testdb`.`users` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 55 ) NOT NULL ,
`password` VARCHAR( 32 ) NOT NULL
) ENGINE = MYISAM
CREATE TABLE `testdb`.`rules` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`uid` INT NOT NULL ,
`title` VARCHAR( 155 ) NOT NULL ,
`points` INT NOT NULL
) ENGINE = MYISAM
SELECT r.`title`, r.`points` FROM `rules` r, `users` u WHERE r.`uid` = u.`id` AND u.`id` = '123'
没有找到相关结果
已邀请:
1 个回复
豹芜澈
{ "ID" : 1, "name" : "John", "password" : "eek hope this is secure", "rules": [ { "ID" : 1, "Title" : "Rule 1", "Points" : 100 }, { "ID" : 2, "Title" : "Rule 2", "Points" : 200 } ] }