MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MYSQL trigger insert into another table for each user from a third table
1002
Richard Duncan
April 01, 2020 10:48AM
Re: MYSQL trigger insert into another table for each user from a third table
464
Peter Brawley
April 01, 2020 11:18AM


Sorry, you can't reply to this topic. It has been closed.

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.