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

mysql database-schema database-metadata

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

mysql database-schema database-metadata

To list all the fields from a table in MySQL:

select *   from information_schema.columns  where table_schema = 'your_DB_name'    and table_name = 'Your_tablename'

mysql database-schema database-metadata

it is better that you use the following query to get all column names easily

Show columns from tablename

CodeHunter