Member Avatar for klenne

Hi,

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?

Thanks

  • 3 Contributors
  • 4 Replies
  • 718 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by klenne
Member Avatar for lolafuertes

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.

Member Avatar for debasisdas

Your question has nothing to do with VB.net application. The business logic needs to be implemented entirely at database level.

Member Avatar for lolafuertes

Yes, and better in a MySql forum, but...
Always we try to help.

Cheers

Member Avatar for klenne

Ok, thanks.

I think I have figured it out!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.