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

select column_name from information_schema.columns
where table_schema="your_db"
order by table_name,ordinal_position