Showing posts with label My Sql. Show all posts
Showing posts with label My Sql. Show all posts

MySql Query to find information about a DB

0

Posted by Jagadeesh VP | Posted in

To get the general information about a DataBase/Schema in My Sql.

SELECT * FROM information_schema.`TABLES` T where TABLE_SCHEMA like '[DATABASE_NAME]';

Note : You should have access to the database.