mysql函数与事件_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()