* get mysql column name / mysql 컬럼 이름 불러오기

큰세상2000 2022. 4. 15. 10:42

참조사이트

Get table column names in MySQL?

Is there a way to grab the columns name of a table in MySQL using PHP?

stackoverflow.com

SELECT
  COLUMN_NAME
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = 'data_base_name'
  AND TABLE_NAME = 'table_name';