MySQL テーブルカラム情報の参照

SELECT * FROM information_schema.columns
WHERE table_schema = 'foodb'
AND table_name = 'employee'
ORDER BY table_name ASC, ordinal_position ASC