ON DUPLICATE KEY UPDATE使用中出现的问题
先贴出来 还没找到解决办法
[SQL] INSERT INTO pm_casecode (
casecode,
product_no,
color_no,
size_no,
size_comb,
sku_num
)
VALUES
('114', '2', '1', '1', '1', '1') ON DUPLICATE KEY UPDATE casecode = casecode
[Err] 4506 - [a56d3096d400000][10.101.3.62:3306][scm]ERR-CODE: [TDDL-4506][ERR_MODIFY_SHARD_COLUMN] Column 'casecode' is a sharding key of table 'pm_casecode', which is forbidden to be modified. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4506]
查看24道真题和解析