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