mysql查询两表中除了某一字段外的字段

你可以使用字段排除的功能来查询两个表中除了某一字段外的字段。在MySQL中，你可以使用以下方法来实现： 1. 使用字段排除功能： ``` SELECT column1, column2, ... FROM table_name WHERE column_name <> '你不想要的字段名'; ``` 例如，如果你想要查询除了content字段之外的所有字段，可以使用以下语句： ``` SELECT column1, column2, ... FROM table_name WHERE column_name <> 'content'; ``` 2. 使用information_schema表查询： ``` SELECT GROUP_CONCAT(column_name SEPARATOR ',') FROM information_schema.COLUMNS WHERE column_name <> '你不想要的字段名' AND table_name = '表名' GROUP BY table_name; ``` 例如，如果你想要查询除了content字段之外的所有字段，可以使用以下语句： ``` SELECT GROUP_CONCAT(column_name SEPARATOR ',') FROM information_schema.COLUMNS WHERE column_name <> 'content' AND table_name = 'table_name' GROUP BY table_name; ``` 3. 使用information_schema表查询多个字段： ``` SELECT DISTINCT TABLE_NAME AS '表名', COLUMN_NAME AS '列名', DATA_TYPE AS '数据类型', COLUMN_COMMENT AS '注释' FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = '数据库名' AND (COLUMN_NAME LIKE "%字段1%" OR COLUMN_NAME LIKE "%字段2%" OR COLUMN_NAME = "字段3") ORDER BY TABLE_NAME, ORDINAL_POSITION; ``` 例如，如果你想要查询带有phone、mobile字段和id_card字段的表中的所有字段，可以使用以下语句： ``` SELECT DISTINCT TABLE_NAME AS '表名', COLUMN_NAME AS '列名', DATA_TYPE AS '数据类型', COLUMN_COMMENT AS '注释' FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = '数据库名' AND (COLUMN_NAME LIKE "%phone%" OR COLUMN_NAME LIKE "%mobile%" OR COLUMN_NAME = "id_card") ORDER BY TABLE_NAME, ORDINAL_POSITION; ``` 请注意，以上方法中的"表名"、"数据库名"、"字段名"等需要根据你的实际情况进行替换。 #### 引用[.reference_title] - *1* *2* [243 mysql获取某个表中除了某个字段名外的所有字段名](https://blog.csdn.net/phpstory/article/details/111605015)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *3* [如何在mysql中查询所有表中的指定字段](https://blog.csdn.net/im_roy/article/details/123104355)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]