MySQL Forums
Forum List  »  Triggers

Re: MYSQL trigger insert into another table for each user from a third table
Posted by: Peter Brawley
Date: April 01, 2020 11:18AM

> have a line for each user of a third table.

Unclear. "have" means what? Read? Wrote? Show? "Line" refers to what? A row in a table? A line in a text file?

General approach ...

1 write the logic in excruciating detail

2 translate the logic into pseudocode

3 translate the pseudocode into trigger code

4 debug till you can find no more bugs

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MYSQL trigger insert into another table for each user from a third table
69
April 01, 2020 11:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.