INSERT IGNORE INTO / REPLACE INTO 简单

INSERT IGNORE INTO test(id, starttime, endtime) VALUES(8, '22','22')

IGNORE有则忽略，无则添加

REPLACE INTO test(id, starttime, endtime) VALUES(7,'222','222')

替换指定ID的值