select column_name from information_schema.columns
where table_schema="your_db"
order by table_name,ordinal_position
More Related Contents:
- How to store arrays in MySQL?
- How can I initialize a MySQL database with schema in a Docker container?
- Difference Between Schema / Database in MySQL
- How to see indexes for a database or table in MySQL?
- Entity-Attribute-Value Table Design
- How do I show the schema of a table in a MySQL database?
- Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
- When to use MyISAM and InnoDB? [duplicate]
- Syntax error due to using a reserved word as a table or column name in MySQL
- Change MySQL default character set to UTF-8 in my.cnf?
- MySQL offset infinite rows
- Ordering by the order of values in a SQL IN() clause
- LAST_INSERT_ID() MySQL
- SQL Selecting from two Tables with inner join and limit [duplicate]
- How to export and import a .sql file from command line with options? [duplicate]
- What is the question mark’s significance in MySQL at “WHERE column = ?”?
- How do write IF ELSE statement in a MySQL query
- How do you uninstall MySQL from Mac OS X?
- Difference between VARCHAR and TEXT in MySQL [duplicate]
- How to program a MySQL trigger to insert row into another table?
- Are column and table name case sensitive in MySQL?
- MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
- Using version control (Git) on a MySQL database
- mySQL – Create a New Table Using Data and Columns from Three Tables
- How to create dummy variable columns for thousands of categories in Google BigQuery?
- Most efficient way to store IP Address in MySQL [duplicate]
- What is the best way to do incremental backups in MySQL?
- Array data type, split string,
- Trouble with GROUP_CONCAT and Longtext in MySQL
- How can I make a table in MySQL called “order”?