深入mysql存储过程中表名使用参数传入的详解

来源：互联网发布：java二叉树遍历编辑：程序博客网时间：2024/05/16 10:48

本篇文章是对mysql存储过程中表名使用参数传入进行了详细的分析介绍，需要的朋友参考下
mysql存储过程实例：
BEGIN
declare date_str varchar(8);
declare table_prefix varchar(20);
set table_prefix='mail_rare_visit_';
set date_str = DATE_FORMAT(CURRENT_DATE(),'%Y%m%d');
set @table_name = concat(table_prefix, date_str);
set @s = concat('CREATE TABLE ', @table_name, '(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`city_id` int(11) NOT NULL,
`email` varchar(300) NOT NULL,
`channel_id` int(11) DEFAULT NULL,
`w_revenue` decimal(7,6) NOT NULL DEFAULT 0.000000,
`w_buy` decimal(7,6) NOT NULL DEFAULT 0.000000,
`w_browse` decimal(7,6) NOT NULL DEFAULT 0.000000,
`rec_goods` varchar(800) DEFAULT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_city_id` (`user_id`),
KEY `idx_email` (`email`),
KEY `idx_channel_id` (`channel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;');
prepare stmt from @s;
execute stmt;
DEALLOCATE prepare stmt;

end

转自：http://blog.chinaunix.net/uid-11840697-id-3998777.html

0 0