我正在尝试创建条形码和日期的唯一索引。有可能有吗make barcode unique unless date is different than inserted row's (date) being inserted
?我在条形码上创建了一个唯一的索引,但有时标签会因意外而重新打印,或者一段时间后序列会重置,并且出现 999 的三位数限制。
[barcode] [date] what i want to happen
=========================================================
1234567999 2022-12-01 be entered into database
1234567001 2022-12-02 be entered into database
1234567999 2023-12-01 be entered into database
1234567001 2023-12-02 be entered into database
1234567999 2023-12-01 fail as duplicate
我该如何在 Maria DB 中实现这一点?