Basically I want to get the table names, and the field names for each table from the current database that is connected, nothing else.
Is this possible?
I know that SHOW TABLES FROM my_database
gets you the table names, and SHOW COLUMNS FROM my_table
will get you the fields, but that's at least [1 x # of tables] queries and I get more information that I want :)
The INFORMATION_SCHEMA.COLUMNS table has what you're asking for.
SELECT table_name, column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'YourDBName'
ORDER BY table_name, ordinal_position
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With