Answer for Trigger before insert

https://365datascience.com/dwqa-answer/answer-for-trigger-before-insert-3/ -

Hi Yunfeng!

Thank you very much for your reply.

Yes, whether you use capital or small letter matters. You need to use small letters in this example.

%y-%m-%d

Regarding the error message – have you executed the queries you’ve provided in the given order? The error message is actually suggesting that you had probably used the INSERT statement to insert a different record:

INSERT INTO employees
VALUES (‘999996’, ‘1990-03-01’, ‘JOHN’, ‘SMITH’, ‘M’, ‘2020-May-8th’);

Instead, we must use numbers to express the dates – 2020-05-08.

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy