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?


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!