mysql存储过程和任务调度器 -- 创建月表和日表的存储过程delimiter $$use `devicitydb1`$$drop procedure if exists `createtable`$$create definer=`devicityusr01`@`%` procedure `createtable`()begin declare sql_str varchar(20000); declare tname varc
mysql存储过程和任务调度器
-- 创建月表和日表的存储过程delimiter $$use `devicitydb1`$$drop procedure if exists `createtable`$$create definer=`devicityusr01`@`%` procedure `createtable`()begin declare sql_str varchar(20000); declare tname varchar(200); declare datastr varchar(2000); declare i int; set i=0; while i?