php创建mysql分库分表

<?php
$hostname = "";
$username = "";
$password = "";
$dbname = "";
​​​​​​​$port = '';
$tbName = 't_trans_query';
// 创建连接
$conn = mysqli_connect($hostname, $username, $password, $dbname, $port);
// 检测连接
if (!$conn) {
    die("连接错误: " . mysqli_connect_error());
}
for($i=0; $i<=99; $i++) {
    if (strlen($i) == 1) {
        $dbNo = sprintf("%02d", $i);
    } else {
        $dbNo = $i;
    }
    $dbStr = 'bfb_db_'.$dbNo;
    $sql = "CREATE DATABASE IF NOT EXISTS bfb_db_".$dbNo;
    mysqli_query($conn,"CREATE DATABASE IF NOT EXISTS $dbStr") or die ("创建数据库失败".mysqli_errno());
    mysqli_select_db($conn,"$dbStr");
    for($j=0; $j<=9; $j++){
        $tbStr = $tbName.'_'.$dbNo.'_'.$j;
        echo $tbStr."\t";
        $sql = "CREATE TABLE IF NOT EXISTS `$tbStr` (
            `F_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'auto inr pri key',
            `F_trans_id` varchar(32) COLLATE latin1_bin NOT NULL,
            `F_enabled` tinyint(3) unsigned DEFAULT '1',
            `F_trans_type` smallint(5) unsigned NOT NULL,
            `F_payment_mode` tinyint(3) unsigned NOT NULL DEFAULT '1',
            `F_state` tinyint(3) unsigned DEFAULT '1',
            `F_create_time` datetime NOT NULL,
            `F_create_time_ext` datetime NOT NULL,
            `F_end_time` datetime DEFAULT '0000-00-00 00:00:00',
            `F_end_time_ext` datetime DEFAULT '0000-00-00 00:00:00',
            `F_modify_time` datetime NOT NULL,
            `F_seller_user_id` bigint(20) unsigned NOT NULL,
            `F_seller_login_name` varchar(32) COLLATE latin1_bin DEFAULT NULL,
            `F_seller_true_name` varchar(160) COLLATE latin1_bin DEFAULT NULL,
            `F_buyer_user_id` bigint(20) unsigned NOT NULL,
            `F_buyer_login_name` varchar(32) COLLATE latin1_bin DEFAULT NULL,
            `F_buyer_true_name` varchar(160) COLLATE latin1_bin DEFAULT NULL,
            `F_trans_id_ext` varchar(64) COLLATE latin1_bin NOT NULL,
            `F_channel_id` smallint(5) unsigned NOT NULL DEFAULT '1',
            `F_cash_amount` bigint(20) DEFAULT '0',
            `F_currency` tinyint(3) unsigned DEFAULT '1',
            `F_goods_url` varchar(255) COLLATE latin1_bin DEFAULT NULL,
            `F_goods_name` varchar(128) COLLATE latin1_bin DEFAULT NULL,
            `F_goods_type` tinyint(3) unsigned DEFAULT '1',
            `F_trans_tag` smallint(5) unsigned DEFAULT '0',
            `F_reserve_int_2` int(11) DEFAULT NULL,
            `F_goods_channel` varchar(64) COLLATE latin1_bin DEFAULT '0',
            `F_reserve_char_2` varchar(64) COLLATE latin1_bin DEFAULT NULL,
            `F_seller_sub_account_type` smallint(5) unsigned NOT NULL DEFAULT '1',
            `F_buyer_sub_account_type` smallint(5) unsigned NOT NULL DEFAULT '1',
            `F_fee_amount` bigint(20) DEFAULT '0',
            `F_trans_mode` smallint(5) unsigned DEFAULT '1',
            `F_pay_type` smallint(5) unsigned DEFAULT NULL,
            `F_pay_recvable_id` varchar(32) COLLATE latin1_bin DEFAULT NULL,
            `F_pay_time` datetime DEFAULT NULL,
            `F_pay_time_ext` datetime DEFAULT NULL,
            `F_confirm_time` datetime DEFAULT NULL,
            `F_confirm_time_ext` datetime DEFAULT NULL,
            `F_sp_id` varchar(16) COLLATE latin1_bin DEFAULT NULL,
            `F_settlement_type` smallint(5) unsigned DEFAULT '1',
            `F_parallel_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
            `F_share_profit_flag` tinyint(3) unsigned NOT NULL DEFAULT '1',
            `F_share_profit_time` datetime DEFAULT NULL,
            `F_share_profit_time_ext` datetime DEFAULT NULL,
            `F_pay_solution_amount` bigint(20) NOT NULL DEFAULT '0',
            `F_coupon_strategy` varchar(1000) COLLATE latin1_bin DEFAULT NULL,
            `F_coupon_amount_new` bigint(20) DEFAULT '0',
            `F_coupon_strategy_id` smallint(5) DEFAULT '0',
            `F_goods_channel_sp_id` varchar(16) COLLATE latin1_bin DEFAULT '0',
            `F_mkt_solution_amount` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
            `F_client_source_flag_create` varchar(32) COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT '',
            `F_buyer_fee_amount` bigint(20) DEFAULT '0' COMMENT '',
            `F_pay_credit_recv_id` varchar(32) COLLATE latin1_bin NOT NULL DEFAULT '',
            `F_mkt_no_settlement_amount` bigint(20) NOT NULL DEFAULT '0',
            `F_seller_fee_settlement_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',
            `F_seller_fee_charge_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',
            `F_seller_fee_charged_user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
            `F_seller_fee_refund_flag` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',
            `F_product_type` smallint(5) NOT NULL DEFAULT '0' COMMENT '',
            PRIMARY KEY (`F_id`),
            KEY (`F_trans_id`),
            KEY `I_create_time_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_modify_time`),
            KEY `I_create_time_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_modify_time`),
            KEY `I_create_ctime_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_create_time`),
            KEY `I_create_ctime_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_create_time`),
            KEY `I_create_ptime_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_pay_time`),
            KEY `I_create_ptime_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_pay_time`)) 
            ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8";
        //var_dump($sql);die;
        if (mysqli_query($conn, $sql)) {
            echo "数据表 $tbStr 创建成功"."\n";
        } else {
            echo "数据表 $tbStr 创建失败" . mysqli_error($conn)."\n";
        }
    }
}
mysqli_close($conn);
echo '--- SUCCESS ---'."\n";