用插入键点击哪个唯一键?

正如bobby所建议的,show indexes返回一个带有相关键索引的结果集,检查这个 page 更多示例:

SHOW INDEXES FROM products_to_categories
WHERE Key_name = "PRIMARY"
AND Seq_in_index = '2';

+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table                  | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| products_to_categories |          0 | PRIMARY  |            2 | category_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+

但是,如果不超过以下解决方法,则可能需要同样多的代码。

检查插入的值是否与表中的现有行冲突:

SELECT code FROM myTable WHERE code = 'the_value_you_tried_to_insert';

或

SELECT name FROM myTable WHERE name = 'the_value_you_tried_to_insert';

虽然不是很优雅的解决方案。

也许这有助于:

SHOW INDEX FROM arbeit

鲍比