Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
siva nathan
1.4k
788
172.4k
how to use trigger when specified table column update in mysql
Aug 21 2020 10:11 AM
Hi all,
I have a 3 table explained in below
table1 contains below columns
id
Currency Symbol
Currency Name
1
$
dollor
Table 2 contains below columns
id
Project
CurrencyId
1
Project#1
1
Table 3 contains below columns
id
Item details
projectId
Currencyid
1
CPU
1
1
table 1 refers currency master
Table 2 refers project details
table 3 refers Item related for projects
i need to write a trigger when project table currency id changes(update) that reflects Item related for project table
Example:
If project table currency ID updates to 2 at that time trigger need to be generated and update the Itemrelated projects table currency id column
Reply
Answers (
1
)
I want to replace THREE sp charaters in Name, Age column upon select.
how we insert data in database using PHP?