mysql get all columns names from table code example Example: mysql all columns -- MySQL SELECT * FROM INFORMATION_SCHEMA.COLUMNS;