CODEWITHSUNDEEP
mysqlphpmyadmin
sree
sree

Reputation: 23

how to update the value of one table when the value is inserted in another table using mysql?

hi i have two tables namely 

sms(Message,sms_index...columns) 
c_paid_bribe(c_addi_info,....)

what i want to do is to insert the values of Message column of sms table into c_addi_info column of c_paid_bribe table automatically whenever a new value is inserted into sms table. I tried this 

$query=mysql_query("insert into bd_paid_bribe(c_addi_info) select Message from sms");

But when a new value is inserted and i run the .php file the already existed values are also inserting into the table again.....

Upvotes: 2

Views: 739

Answers (2)

barsju
barsju

Reputation: 4446

What you want to do is simply to make two queries that are comitted in one transaction. This is what transactions are for. See here for examples on how to do it: PHP + MySQL transactions examples

Upvotes: 0

paulsm4
paulsm4

Reputation: 121659

Q: what i want to do is to insert the values of Message column of sms table into c_addi_info column of c_paid_bribe table automatically whenever a new value is inserted into sms table.

A: If you want to update one table when another is changed (and, for whatever reason, you can't simply do this in your application), then use "triggers":

http://net.tutsplus.com/tutorials/databases/introduction-to-mysql-triggers/

Q: But when a new value is inserted and i run the .php file the already existed values are also inserting into the table again.....

A: You want an "upsert". For example:

How do I update if exists, insert if not (AKA "upsert" or "merge") in MySQL?

Upvotes: 0

Related Questions