php分表mysql

直接上代码

<?php  
ini_set('memory_limit', '-1');  
$con=mysql_connect("127.0.0.1","root","root");
mysql_query("set names 'utf8' ");
mysql_query("set character_set_client=utf8");
mysql_query("set character_set_results=utf8");
if($con){    
        $sql="create database e_prize_rules_trigger_log default character set utf8;";  
        $do=mysql_query($sql,$con)or die(mysql_error());  
        if($do){  
            mysql_select_db("e_prize_rules_trigger_log",$con);
            mysql_query("set names utf8");  
            for($j=0;$j<100;$j++){    //10个表
				if($j<10){
					$j = "0".$j;
				}
                $sql="drop table if exists e_prize_rules_trigger_log_{$j};";
                mysql_query($sql);
                $sql="CREATE TABLE `e_prize_rules_trigger_log_{$j}` (
				  `id` int(11) NOT NULL,
				  `member_id` int(11) NOT NULL,
				  `member_name` varchar(60) NOT NULL,
				  `column_type` varchar(255) NOT NULL COMMENT '关联栏目类型  0无关联，1答疑解惑，2学习资料，3同城活动，4培训报名，5广联达产品，6广币商城',
				  `column_id` int(11) NOT NULL COMMENT '栏目id',
				  `rules_id` varchar(255) NOT NULL COMMENT '触发规则id ',
				  `status` tinyint(4) NOT NULL COMMENT '0未抽奖 1已抽奖',
				  `winning_time` datetime NOT NULL COMMENT '抽奖时间',
				  `_create_time` datetime NOT NULL,
				  PRIMARY KEY (`id`),
				  KEY `member_id` (`member_id`) USING BTREE
				) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='规则触发记录表'";
                $do=mysql_query($sql,$con) or die(mysql_error());
            }
        }
}else{  
    echo "connect error!!!!";  
} 

多多交流：qq:274501366