Click here to Skip to main content
15,074,394 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have to table one cantaine my key words and the other my data, i want to validate my data with table key_word by trigger in myqsl

table key_word
| word  |  field  |
|  w1   |  field3 |
|  w2   |  field1 |
|  w3   |  field1 |
|  w4   |  field2 |
|  w5   |  field4 |
|  w6   |  field3 |
|  w7   |  field1 |
|  w8   |  field1 |

so i want to validate any data that come into my data table by table key_word, on column word there is acceptable word and column field show this word should be just in this column in data table.
how can i do it with trigger??
Updated 26-Aug-15 7:03am
PIEBALDconsult 26-Aug-15 13:03pm
I suspect you actually want Referential Integrity -- look it up.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900