How to get all columns' names for all the tables in MySQL?

mysql database-schema database-metadata
dieter picture dieter · Apr 13, 2011 · Viewed 185.5k times · Source

Is there a fast way of getting all column names from all tables in MySQL, without having to list all the tables?

Answer

Nicola Cossu picture Nicola Cossu · Apr 13, 2011 
select * from information_schema.columns
where table_schema = 'your_db'
order by table_name,ordinal_position

Related questions

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

Read More
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
How to store arrays in MySQL?

I have two tables in MySQL. Table Person has the following columns: id | name | fruits The fruits column may hold null or an array of strings like ('apple', 'orange', 'banana'), or ('strawberry'), etc. The second table is Table Fruit and …

Read More