Resolved: rules/ checks for data

Question

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

Answer 1

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

Answer 2

Hi Tsvetelin,

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

Lucia

Resolved: rules/ checks for data

Submit an answer

related questions