thinkphp分表
2020-05-31 本文已影响0人
日落_3d9f
thinkphp分表代码:
$rule = [
'type' => 'myMod', // 自定义分表方式,应该是一个函数
'num' => 2 // 分表数量
];
// 用于查询
$data = \Db::name('end_reviews_bj')
->partition(['id' => 2], "user_id", $rule)
->where(['id' => 2])
->select();
var_dump($data);
$sql = $data = \Db::name('end_reviews_bj')
->partition(['id' => 2], "user_id", $rule)
->where(['id' => 2]);
//拼接成的sql语句
//SELECT * FROM ( SELECT * FROM end_reviews_bj_1 UNION SELECT * FROM end_reviews_bj_2 ) `end_reviews_bj` WHERE `id` =
var_dump($sql);
return "hello world";