mysql获取所有表名，字段名
//dbName你的数据库名 select table_name from information_schema.tables where table_schema='dbName'
//table你的表名 //获取所字段所有信息 "SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME='table'" 或 "SHOW FULL COLUMNS FROM table" //获取所字段名 "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME='table'"