Question

mysql 如何用sql语句查询表的所有列名

Answer 1

select COLUMN_NAME from information_schema.columns where table_name='b'
select count(*) from information_schema.COLUMNS WHERE TABLE_SCHEMA='a' and table_name=‘b’
a是库名，b是表明

Answer 2

SELECT * FROM 表名;