Monday, July 29, 2013

How to get table columns list from MySQL database?


SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tableName'

No comments:

Post a Comment