PHP+mysql 创建分表

代码示例：

function getUserInfoTable($uid)
{
    $i = $uid % 10;
    $table = sprintf("user_info_%s", $i);
    $check_sql = "SELECT COUNT(1) exist from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND table_name ='{$table}' ";
    $result = $this->link->fetchOne($check_sql);
 
    $sql = <<<EOD
CREATE TABLE IF NOT EXISTS `{$table}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `comic_id` int(10) unsigned NOT NULL DEFAULT '0',
  `chapter_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '章节ID',
  `t` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
  `read_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '阅读状态 1已阅读 2未阅读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
EOD;
 
    if ($result['exist'] == 0) {
        $this->link->execute($sql);
    }
    return $table;
}