make VIEW of SHOW TABLE query
- by cneeds
Is there a way to make a VIEW of this SHOW TABLE query?
SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"
When I save this as a view (using phpMyAdmin) I get
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"' at line 4
when phpMyAdmin tries to execute this
CREATE ALGORITHM = UNDEFINED VIEW `Tables` AS SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"