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";
上一篇下一篇

猜你喜欢

热点阅读