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

Question

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

Answer 1

select * from information_schema.columns
where table_schema = 'your_db'
order by table_name,ordinal_position