MySQL中批量创建日志表信息脚本

MySQL中批量创建日志表信息脚本如下：drop PROCEDURE if EXISTS reqSp;
DELIMITER //
create procedure reqSp（sTime varchar（32）, eTime varchar（32）,tchema varchar（32））begindeclare sName varchar（128）;
declare uid varchar（128）;
declare orderId varchar（128）;
declare sqlVar varchar（1024）;
declare rest int;set rest = 1;while rest > 0 do

set sTime = （select DATE_FORMAT（（select ADDDATE（sTime,1））,"%Y%m%d"））;
set sName = CONCAT（"tbl_resp_",sTime）;
set uid = CONCAT（"idx_id_resp_",sTime）;
set orderId = CONCAT（"idx_order_resp_",sTime）; select count（1） from information_schema.tables where table_name = sName and TABLE_SCHEMA=tchema into @cnt;
if @cnt = 0 then set sqlVar=CONCAT（" create table ",sName,
" （ id varchar（60） NOT NULL, ",
" order varchar（100） NOT NULL, ",
" ads int（10） NOT NULL, ",
" type varchar（60） NOT NULL, ",
" group int（10） NOT NULL, ",
" template int（10） NOT NULL, ",
" banner varchar（100） DEFAULT NULL, ",
" app varchar（100） DEFAULT NULL, ",
" create_time datetime NOT NULL, ",
" key ",uid ," （uid）,",
" key ",orderId ," （order_id）",
" ） ENGINE=MyISAM DEFAULT CHARSET=utf8 "）; set @v_s=sqlVar;
prepare stmt from @v_s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end if; set rest = DATEDIFF（eTime,sTime）;END while;end;//
DELIMITER;call reqSp（"20141001","20151001","dbname"）第一个参数开始时间 20141001第二个参数结束时间 20151001第三个参数是数据库名称--------------------------------------分割线 --------------------------------------Ubuntu 14.04下安装MySQL http://www.linuxidc.com/Linux/2014-05/102366.htm《MySQL权威指南（原书第2版）》清晰中文扫描版 PDF http://www.linuxidc.com/Linux/2014-03/98821.htmUbuntu 14.04 LTS 安装 LNMP NginxPHP5 （PHP-FPM）MySQL http://www.linuxidc.com/Linux/2014-05/102351.htmUbuntu 14.04下搭建MySQL主从服务器 http://www.linuxidc.com/Linux/2014-05/101599.htmUbuntu 12.04 LTS 构建高可用分布式 MySQL 集群 http://www.linuxidc.com/Linux/2013-11/93019.htmUbuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb http://www.linuxidc.com/Linux/2013-08/89270.htmMySQL-5.5.38通用二进制安装 http://www.linuxidc.com/Linux/2014-07/104509.htm--------------------------------------分割线 --------------------------------------本文永久更新链接地址