Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM (
- SELECT TABLE_NAME
- FROM information_schema.tables
- WHERE TABLE_NAME = 'MyTable1'
- ) AS Blah
- PREPARE stmt1 from 'SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_NAME = 'MyTable1' INTO @table';
- EXECUTE stmt1;
- SET @query = CONCAT('SELECT * FROM ', @table);
- PREPARE stmt2 FROM @query;
- EXECUTE stmt2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement