show all columns in mysql table code example Example: mysql all columns -- MySQL SELECT * FROM INFORMATION_SCHEMA.COLUMNS;