mysql如何查询某个库，某个表都有哪些字段

如下语句便可查看

SELECT column_name FROM Information_schema.columns  WHERE table_Name = 'columns' AND TABLE_SCHEMA = 'information_schema';