1、查询数据库中存在的表名 SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'yourDataBeas' 2、查询数据库中某表存在的字段名称 SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE table_name = 'yourTable' AND TABLE_SCHEMA = 'yourDataBeas'