Timeline for How to limit inserts to one row per user per month?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 5, 2018 at 12:34 | history | edited | Andriy M | CC BY-SA 4.0 |
corrected grammar, punctuation and formatting
|
| Sep 5, 2018 at 12:29 | comment | added | Andriy M |
You could use EXTRACT(YEAR_MONTH FROM date) as the generated column's expression. It returns a number in the form of YYYYMM, which would be perfectly sufficient for the required constraint.
|
|
| Sep 5, 2018 at 12:24 | history | edited | Kondybas | CC BY-SA 4.0 |
added 582 characters in body
|
| Sep 5, 2018 at 12:22 | vote | accept | M1L0 | ||
| Sep 5, 2018 at 12:13 | history | answered | Kondybas | CC BY-SA 4.0 |