lezu 最近的时间轴更新 lezu 最近的时间轴更新 |
lezuV2EX 第 2266 号会员，加入于 2010-10-14 17:13:35 +08:00 |
| MongoDB => SQL MySQL • lezu • 2010-12-02 13:26:17 PM • 最后回复来自 lezu | 1 |
lezu 最近回复了
2011-02-17 13:10:22 +08:00 回复了 jzhone 创建的主题 › 分享发现 › 原盛大边锋总裁许朝军创业项目点点网 |
2010-12-02 13:26:22 +08:00 回复了 lezu 创建的主题 › MySQL › MongoDB => SQL |
Querying Data
$res = $col->find(); SELECT * FROM `$tbl`
$doc = $col->findone(array('_id' => $id)); SELECT * FROM `$tbl` WHERE `id` = {$id}
$res = $col->find()->limit(1); SELECT * FROM `$tbl` LIMIT 1
$res = $col->find()->skip(1)->limit(1); SELECT * FROM `$tbl` OFFSET 1 LIMIT 1;
$res = $col->find()->sort(array('login' => -1)); SELECT * FROM `$tbl` ORDERBY `login` DESC //-1=DESC,1=ASC
$res = $col->find(array('age' => array('$lt' => 30))); SELECT * FROM `$tbl` WHERE `age` < 30 //$lt:<,$gt:>,$gte:>=, $lte:<=, $ne:!=
$doc = $col->find(array(’a'=>’hello’,'b’=>1)); SELECT * FROM `$tbl` WHERE `a` = ‘hello’ AND `b`=1
$doc = $col->find(array(’a'=>’hello’,'b’=>array(’$gt’=>1))); SELECT * FROM `$tbl` WHERE `a` = ‘hello’ AND `b`>=1
$res = $col->find(array('age' => array('$gte' => 20, '$lte' => 50))); SELECT * FROM `$tbl` WHERE `age` >= 20 AND `age` <= 50
$col->remove(array('age'=>24),array('justOne'=>true,'safe'=>true)); DELETE FROM `$tbl` WHERE `login` = 'psmith'
$res = $col->find(); SELECT * FROM `$tbl`
$doc = $col->findone(array('_id' => $id)); SELECT * FROM `$tbl` WHERE `id` = {$id}
$res = $col->find()->limit(1); SELECT * FROM `$tbl` LIMIT 1
$res = $col->find()->skip(1)->limit(1); SELECT * FROM `$tbl` OFFSET 1 LIMIT 1;
$res = $col->find()->sort(array('login' => -1)); SELECT * FROM `$tbl` ORDERBY `login` DESC //-1=DESC,1=ASC
$res = $col->find(array('age' => array('$lt' => 30))); SELECT * FROM `$tbl` WHERE `age` < 30 //$lt:<,$gt:>,$gte:>=, $lte:<=, $ne:!=
$doc = $col->find(array(’a'=>’hello’,'b’=>1)); SELECT * FROM `$tbl` WHERE `a` = ‘hello’ AND `b`=1
$doc = $col->find(array(’a'=>’hello’,'b’=>array(’$gt’=>1))); SELECT * FROM `$tbl` WHERE `a` = ‘hello’ AND `b`>=1
$res = $col->find(array('age' => array('$gte' => 20, '$lte' => 50))); SELECT * FROM `$tbl` WHERE `age` >= 20 AND `age` <= 50
$col->remove(array('age'=>24),array('justOne'=>true,'safe'=>true)); DELETE FROM `$tbl` WHERE `login` = 'psmith'
2010-11-15 17:30:29 +08:00 回复了 plidezus 创建的主题 › 分享创造 › 跟朋友合作的二手书交换网站，有兴趣的各位来内测啦～ |
[email protected]，杭州，.net的共享出去……
谁能给我一个邀请？
2010-10-14 17:30:18 +08:00 回复了 itopidea 创建的主题 › PHP › XenForo 一个很不错的论坛 |
看看
还不错
还不错
Select Language