MySQL 5.5.22 - triggers

Question

MySQL 5.5.22 - triggers

jeffrey.barber

SSC Journeyman

Points: 94
More actions
April 11, 2012 at 11:00 pm

#259045

Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is entered.
INVOICE
INV_NUM
INV_AMOUNT
CUSTOMER
CUS_ID
CUS_AMOUNT

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You'll probabaly get faster answers to MySQL problems on one of the MySQL forums - http://forums.mySQL.com OR http://www.dbforums.com/mysql

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jeffrey.barber SSC Journeyman Points: 94 More actions · Answer 2

Thanks - finally figured it out after spending nearly 8-hours on it.