mysql all columns
snippet in sql

get the mysql table columns data type mysql

user5593

SHOW COLUMNS FROM mydb.mytable;

mysql all columns

user3450

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;