mysql函数及事件

mysql函数

CREATE DEFINER=`zhangjinhulian`@`%` PROCEDURE `everMonthUserLog`()
BEGIN
SET @table_name = CONCAT('wz_users_active_',date_format(now(),'%y_%m'));
set @sql_create_table =concat('create table if not exists ',@table_name,'(
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `head` varchar(255) NOT NULL,
  `role_name` varchar(50) NOT NULL,
  `user_name` varchar(40) NOT NULL,
  `user_id` int(11) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` varchar(255) NOT NULL,
  `department` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL, PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `departy` (`department`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8');
prepare sql_create_table from @sql_create_table;
execute sql_create_table;
END

　　mysql事件

CREATE EVENT `event_create_logtable_every_month` ON SCHEDULE EVERY 1 MONTH STARTS '2017-06-09 10:19:42' ON COMPLETION PRESERVE ENABLE DO call everMonthUserLog()