checking

roustabout

hi all,

i have a table called depart_assign:

id dept_id percent
1 1 30
1 2 70
2 1 50

id and dept_id are the pks.

Is it possible to create a trigger in mysql( i know that newest version support trigger) to block the data entry when the percent is greater than 100 assuming that one person can work with more than one department ( dept_id = 1 and 2)?

Should I do this checking in php?

please advise...

bastien

why trigger it? a unique composite index on the id & dept cols would work just as well and not incur the overhead of the trigger

roustabout

what i mean ....is to restrict the entry if the percent value is greater than 100.

scenario:

a person (id) can work more than one department. for example, person id=1 can work in dept_id=1 with the percent= 30. person id=1 also work in dept_id+2 and the percent = 70. The percent should add up to a 100 and that's the maximun.