creating table inside stored procedure.

• • Reply

  14 years ago

  by nitin.manipal

  nitin aggarwal

  bangalore, India

  Joined 15 years ago

  hi,
  
  i am trying to create table inside the stored procedure with table name as parameter passed. but in my code table is getting created but with NAME same as parameter name  not as parameter value.. my code look like this:
  
  create procedure sp2(IN name varchar(5))
  begin
  create table $name (x int);
  end;
  //
  
  ----------
  Here i want table to be created with same name as parameter value. Can anybody suggest something on this. Its Urgent.
  
  thanks,
  nitin
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Report abuse