只插入新数据
insert into drug(DrugID)
select '000211' from drug where not exists(select DrugID from drug where DrugID='000211') limit 1
如果数据不存在则插入,否则更新数据
INSERT INTO drug (DrugID,DrugName) VALUES ('abc','abc'),('abc1','abc1') ON DUPLICATE KEY UPDATE Remark =Remark+ '1';