get all fields of a table mysql code example Example: mysql all columns -- MySQL SELECT * FROM INFORMATION_SCHEMA.COLUMNS;