view all columns in database mysql code example

Example: mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;