Last answered:

16 Mar 2023

Posted on:

15 Mar 2023

0

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)
Instructor
Posted on:

15 Mar 2023

0

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

Posted on:

16 Mar 2023

0

Hi Tsvetelin,


thank you, I will keep an eye out for them :)


Lucia

Submit an answer