List of databases,tables,columns in MySQL :
SELECT t.table_schema AS 'Database' ,t.table_name AS 'Table' ,t.table_type AS 'Table Type' ,c.column_name AS 'Column' ,c.data_type AS 'Data Type' FROM information_schema.tables t JOIN information_schema.columns c ON t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_schema NOT IN( 'mysql','information_schema') ORDER BY t.table_schema,t.table_type,t.table_name,c.ordinal_position;Output :
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: