Atrixnet Code Share and Geek Resources | Can you grok it?

RSS

TAG | sql

Dec/09

2

Select the actual column names from a table in MySQL

No comments · Posted by admin in code

1
2
3

SELECT column_name
FROM information_schema.`COLUMNS` COLUMNS
WHERE table_name = 'TABLE_NAME';