MySQL insert trigger date check

Asked May 25 '18 at 08:50

Active May 25 '18 at 08:50

Viewed 188 times

I have a table like this:

CREATE TABLE `shopping` (
    `userid` int(9) DEFAULT NULL,
    `carid` int(9) DEFAULT NULL,
    `buydate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

And I would like to create an insert trigger, which check the "buydate", and if it's greater than the current date, stop the insert, and only accept the equals or the less dates.

I'm very beginner with triggers, I readed some tutorials, but I don't get how it's work.

Thanks in advance!

asked May 25 '18 at 08:50

Gregori

It might be worth reading https://stackoverflow.com/questions/50525184/mysql-insert-trigger-date-check – P.Salmon May 25 '18 at 10:21
Uhm, this is my topic's link? – Gregori May 25 '18 at 10:34
1

OOps https://stackoverflow.com/questions/9734920/can-a-mysql-trigger-simulate-a-check-constraint – P.Salmon May 25 '18 at 11:19
1

Or https://dba.stackexchange.com/a/30151/11651 – Michael - sqlbot May 29 '18 at 23:08

MySQL insert trigger date check

0 Answers0