0

Hi!

I dont know if this possible

I have a payments table in a database

what I want to accomplish is,

once a certain customer id has paid say $100 USD

my discounts table will generate a code for me automatically

say I'll insert a new record

is there such thing as automated insertion without me clicking anything?

thanks!

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by anthonyjpv
1

Perhaps a database trigger. You can write an update trigger, that gets activated when a record changes. Then you decide to insert a record if the amount is high enough. If this is what you want, I suggest you have this question moved to the MySQL forum.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.