mysql - 当另一个项目相同时，在mysql数据库中查找不同的项目？

Question

我有一个 SQL 数据库，其中保存产品信息，包括产品的名称和描述。

目前的设置方式是这样的:

+-------------+-------------+------------------+--------------------------------+
| products_id | language_id | products_name    | products_description           |
+-------------+-------------+------------------+--------------------------------+
|           1 |           1 | A19845002        | CONE DRIVE ASSEMBLY            |
|           1 |           2 | A19845002        | CONE DRIVE ASSEMBLY            |
|        4619 |           1 | A51959001        | CONE DRIVE SPACER              |
|        4619 |           2 | A51959001        | CONE DRIVE SPACER              |
|       13600 |           1 | A18535004        | CONE DRIVE UNIT                |
|       13600 |           2 | A18535004        | CONE DRIVE UNIT                |
|       13701 |           1 | A17236001GEARSET | CONE DRIVE GEARSET             |
|       13701 |           2 | A17236001GEARSET | CONE DRIVE GEARSET             |
|       14388 |           1 | A18535003        | CONE DRIVE UNIT                |
|       14388 |           2 | A18535003        | CONE DRIVE UNIT                |
|       14389 |           1 | A18535002        | CONE DRIVE UNIT                |
|       14389 |           2 | A18535002        | CONE DRIVE UNIT                |
|       14390 |           1 | A18535001        | CONE DRIVE UNIT                |
|       14390 |           2 | A18535001        | CONE DRIVE UNIT                |
|       14727 |           1 | A19346006        | CONE DRIVE SPEED REDUCER       |
|       14727 |           2 | A19346006        | CONE DRIVE SPEED REDUCER       |
|       14859 |           1 | A18957002        | CONE DRIVE GEARMOTOR UNIT      |
|       14859 |           2 | A18957002        | CONE DRIVE GEARMOTOR UNIT      |
|       14867 |           1 | 604037           | CONE DRIVE GEARMOTOR           |
|       14867 |           2 | 604037           | CONE DRIVE GEARMOTOR           |
|       15182 |           1 | A17236001        | CONE DRIVE UNIT SM-502000-AJ   |
|       15182 |           2 | A17236001        | CONE DRIVE UNIT SM-502000-AJ   |
|       15410 |           1 | A19346004        | CONE DRIVE WORM REDUCER        |
|       15410 |           2 | A19346004        | CONE DRIVE WORM REDUCER        |
|       15751 |           1 | 604036           | CONE DRIVE GEARMOTOR 2.75 BORE |
|       15751 |           2 | 604036           | CONE DRIVE GEARMOTOR 2.75 BORE |
|       15752 |           1 | 604035           | MSR 50 CONE DRIVE GEARMOTOR    |
|       15752 |           2 | 604035           | MSR 50 CONE DRIVE GEARMOTOR    |
|       15842 |           1 | A19346005        | CONE DRIVE WORM REDUCER        |
|       15842 |           2 | A19346005        | KEGELRÄDER WORM REDUCER        |
+-------------+-------------+------------------+--------------------------------+

当 products_id 相同但 language_id 不同时，它希望仔细检查并找出 products_description 的不同之处。 (1 应该是英语，2 应该是德语)。如果我对此运行查询，我希望有一种简单的方法来查找 CONE DRIVE WORM REDUCER/KEGELRäDER WORM REDUCER(即 product_id 或 product_name)。

我该如何使用 mysql 来做到这一点？我不太习惯做很多数据库工作，但我需要找出这些产品是否得到了正确的处理。

Answer 1

试试这个:

SELECT DISTINCT products_id
FROM products_table -- assumed
GROUP BY products_description
  HAVING COUNT(products_id) > 1

应该为您提供一个结果，其中包含已翻译其描述的产品的产品 ID。如果您决定需要尚未翻译其描述的产品的 ID，请将 HAVING 子句中的 > 测试替换为 =。