准备工作:
创建一张表,联合主键:
create table test_insert_on_duplicate_key_update(
id tinyint unsigned not null,
birth_day date not null,
score int unsigned not null,
primary key(id, birth_day)
) engine = InnoDB;
准备测试数据:
准备工作:
创建一张表,联合主键:
create table test_insert_on_duplicate_key_update(
id tinyint unsigned not null,
birth_day date not null,
score int unsigned not null,
primary key(id, birth_day)
) engine = InnoDB;
准备测试数据: