Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. delimiter //
  2. drop procedure if exists testit//
  3. create procedure testit(IN tbl varchar(25))
  4. begin
  5. set @sql := concat('select * from ',tbl);
  6. prepare mySt from @sql;
  7. execute mySt;
  8. end//
  9. delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement