Mysql 在重复键上插入选择不起作用

Question

包含数据的表行

feature_access_id	user_id	company_id	feature_id	access_level	flag	created_dt	last_updated_dt
'20'	'0'	'0'	'66'	'ST'	'Y'	'2022-03-24 07:28:38'	'2022-03-31 08: 24:32'

下面的查询确实会影响运行后的行，该标志应该具有 从 Y 更改为 N

INSERT INTO access( user_id, company_id, feature_id, access_level, flag) 
select  0,0,feature_id,'ST', 'N' from feature where feature_code = 'UPCOMING'
ON duplicate key update flag = 'N'

添加的约束

ALTER TABLE `access` ADD CONSTRAINT `access_constraint` UNIQUE (
`user_id`,`company_id`,`feature_id`,`access_level`
);