SQL to SequoiaDB shell to PHP

SequoiaDB 的查询用json（bson）对象表示，下表以例子的形式显示了SQL语句，SequoiaDB shell语句和SequoiaDB PHP驱动程序语法之间的对照关系。

SQLSequoiaDB shellPHP Driver
insert into employee(a,b) values(1,-1)db.sample.employee.insert({a:1,b:-1})$employee->insert(“{a:1,b:-1}”)
select a,b from employeedb.sample.employee.find(null,{a:””,b:””})$employee->find(NULL, ‘{a:””,b:””}’)
select from employeedb.sample.employee.find()$employee->find()
select from employee where age=20db.sample.employee.find({age:20})$employee->find(“{age:20}”)
select from employee where age=20 order by namedb.sample.employee.find({age:20}).sort({name:1})$employee->find(“{‘age’:20}”, NULL, “{‘name’:1}”)
select from employee where age > 20 and age < 30db.sample.employee.find({age:{$gt:20,$lt:30}})$employee->find(‘{age:{$gt:20,$lt:30}}’)
create index testIndex on employee(name)db.sample.employee.createIndex(“testIndex”,{name:1},false)$employee->createIndex(“{name:1}”, “testIndex”, false)
select from employee limit 20 offset 10db.sample.employee.find().limit(20).skip(10)$employee->find(NULL, NULL, NULL, NULL, 10, 20)
select count() from employee where age > 20db.sample.employee.find({age:{$gt:20}}).count()$employee->count(‘{age:{$gt:20}}’)
update employee set a=a+2 where b=-1db.sample.employee.update({$inc:{a:2}},{b:-1})$employee->update(‘{$inc:{a:2}}’, “{b:-1}”)
delete from employee where a=1db.sample.employee.remove({a:1})$employee->remove(“{a:1}”)