Sunday, 1 September 2013

How to Find All Column Names in Mysql Database



SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘<DatabaseName>’ AND TABLE_NAME = '<TableName’>;

No comments:

Post a Comment