mysql查詢部分行,mysql如何用sql語(yǔ)句查詢表的所有列名?
selectCOLUMN_NAMEfrominformation_schema.columnswheretable_name='b'selectcount(*)frominformation_schema.COLUMNSWHERETABLE_SCHEMA='a'andtable_name=‘b’a是庫(kù)名,b是表明
selectCOLUMN_NAMEfrominformation_schema.columnswheretable_name='b'selectcount(*)frominformation_schema.COLUMNSWHERETABLE_SCHEMA='a'andtable_name=‘b’a是庫(kù)名,b是表明