Thursday 7 September 2017

Retrives the data from INFORMATION_SCHEMA in MYSQL Database




Example of a statement that retrieves information from INFORMATION_SCHEMA


MYSQL> SELECT TABLE_NAME, TABLE_TYPE, ENGINE
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'DBACENTRE'
ORDER BY TABLE_NAME DESC;

Output:-

Popular Posts