mysql - 插入重复键并替换为不起作用

Question

CREATE TABLE `pv_network_coverage` (
  `network_group_id` int(8) NOT NULL,
  `carrier_group_id` int(8) NOT NULL,
  `physician_count` int(8) NOT NULL DEFAULT '0',
  `facility_count` int(8) NOT NULL DEFAULT '0',
  `pcp_count` int(8) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`network_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;

REPLACE INTO pv_network_coverage(carrier_group_id,
                                 network_group_id,
                                 physician_count,
                                 facility_count,
                                 pcp_count,
                                 update_time) SELECT *FROM temp_pv_network_coverage;

我使用带有重复键的replace into 和insert into。

doctor_count 应该是 1000 但仍然是 0..

这真的让我很惊讶。

Answer 1

记住选择列而不是选择*from