SELECT COLUMN_NAME,IS_NULLABLE,COLUMN_TYPE,COLUMN_COMMENT,TABLE_NAME from information_schema.columns WHERE TABLE_SCHEMA = 'databaseName' AND TABLE_NAME='tableName'