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 ]