I'm writing a stored procedure that gets a VARCHAR(45) as a parameter.
Inside my stored procedure, I want to create a table with a name based
on that parameter.
For example, if I do
call my_sp('XXX');
I want the stored procedure to create a table named foo_XXX.
I don't know how to do this. Here's what I've tried so far:
DELIMITER $$
DROP PROCEDURE IF EXISTS `mwilson`.`my_sp` $$
CREATE PROCEDURE `mwilson`.`my_sp` (IN param1 VARCHAR(45))
BEGIN
create table concat('foo_', param1) as
(
...
);
END $$
DELIMITER ;
All advice is welcome.
Matt
--
A better way of running series of SAS programs:
http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
