Resolved: rules/ checks for data
How can I build in rules inside the tables, so that for example, the hire_date cannot be earlier than the date_of_birth date?
Is this part of this course?
Thanks
Lucia
2 answers ( 1 marked as helpful)
Hi Lucia!
Thanks for reaching out.
You can set these rules using MySQL triggers. There are different types of triggers (before insert, after insert and others). They are thought during the lectures.
Hope this helps.
Best,
Tsvetelin
Hi Tsvetelin,
thank you, I will keep an eye out for them :)
Lucia