Actually I don't know if my question belongs in this topic or in the mysql topic.
But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application.

I have a table with reservations and a table with consumptions. So when a reservation is paid, all the consumption from that reservations have to be deleted automaticly.

Can someone help me with this or do I have to ask it in the mysql topic?


The triggers are declared at database engine, so you need to administer MySQL database to create a trigger to do that.

You can find here the reference on how to create a trigger in MySQL version 5.6. On this page you can find manuals for other versions.

Hope this helps.

This question has already been answered. Start a new discussion instead.