Re: Passing Values

[Atanas Todorov]

if you have at least 5.0.13-rc, you can do this by using prepared statement:

delimiter //

create procedure `test`(in table_name varchar(50),in val1 int,in val2 varchar(255))
begin
set @val1 := val1;
set @val2 := val2;
set @insert_query := concat('insert into ', table_name, ' values (?,?)');
prepare stmt from @insert_query;
execute stmt using @val1, @val2;
deallocate prepare stmt;
end//

delimiter ;



Edited 1 time(s). Last edit at 10/27/2005 05:31AM by Atanas Todorov.