Select COLUMN_NAME From information_schema.COLUMNS WHERE table_name = '表名称’
比如获取表名称为‘table’的字段;
Select COLUMN_NAME From information_schema.COLUMNS WHERE table_name = 'table’
注意点:单引号不能丢;
Select COLUMN_NAME From information_schema.COLUMNS WHERE table_name = '表名称’
比如获取表名称为‘table’的字段;
Select COLUMN_NAME From information_schema.COLUMNS WHERE table_name = 'table’
注意点:单引号不能丢;