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!
Jump to PostPerhaps 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.
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 is what im looking for. thanks!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
