あれば、UPDATE なければ、Insert ?
CREATE TABLE ta
(
ItemExId integer,
ItemId integer,
AccountExId integer,
colorname varchar(10) ,
EXdate varchar(10)
)
----------------------------------------------
insert into ta
values
(1,1,1,'赤',' '),
(2,1,2,' ','2020-01-01'),
(3,2,1,'黄色',' '),
(4,2,1,' ','2020-02-02'),
(5,3,1,'青',' '),
(6,3,2,' ','2020-03-03')
----------------------------------------------
CREATE TABLE tb
(
ItemExId integer,
ItemId integer,
AccountExId integer,
colorname varchar(10) ,
EXdate varchar(10)
)
----------------------------------------------
insert into tb
values
(1,1,1,'赤',' '),
(2,1,2,' ','2020-01-01'),
(3,2,1,'黄色',' '),
(4,2,1,' ','2020-02-02'),
(5,3,1,'青',' '),
(6,3,2,' ','2020-03-03')
----------------------------------------------
