Mysql动态建表和临时表

1.Mysql采用存储，实现动态建表：

BEGIN

DECLARE tb_name VARCHAR(64);
DECLARE v_name VARCHAR(32) DEFAULT 'tbl_test_';
set tb_name = CONCAT(v_name,date_format(CURDATE(),'%Y%m%d'));

set @sql_delete = CONCAT('DROP TABLE IF EXISTS ',tb_name);
PREPARE sql_delete FROM @sql_delete;   
EXECUTE sql_delete; 
DEALLOCATE PREPARE sql_delete;

set @sql_create_table = concat(
	'CREATE TABLE IF NOT EXISTS ', tb_name,
	"(
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`name` varchar(255) DEFAULT NULL,
		`address` varchar(255) DEFAULT NULL,
		`time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
		PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8");
	
PREPARE sql_create_table FROM @sql_create_table;   
EXECUTE sql_create_table; 
DEALLOCATE PREPARE sql_create_table;

END

拼接为一个变量，采用PREPARE、EXECUTE、DEALLOCATE P