· 7 years ago · Oct 20, 2018, 10:34 AM
1{ Error: ER_DUP_ENTRY: Duplicate entry '12345678-2018-10-20 00:00:00' for key 'PRIMARY'
2
3sql insert into lookupHistory (index, date) values ('12345678', CURDATE())
4
5create table if not exists lookupHistory(
6index VARCHAR(40) not null,
7date datetime,
8primary key (index, date)
9);