Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view for base table and temporary table

mysql> mysql> mysql> CREATE   OR REPLACE VIEW TABLES     ->         (TABLE_CREATOR, TABLE_NAME,     ->          CREATE_TIMESTAMP, COMMENT) AS     -> SELECT   UPPER(TABLE_SCHEMA), UPPER(TABLE_NAME),     ->          CREATE_TIME, TABLE_COMMENT     -> FROM     INFORMATION_SCHEMA.TABLES     -> WHERE    TABLE_TYPE IN ('BASE TABLE','TEMPORARY'); Query OK, 0 rows affected (0.00 sec) mysql>