How to copy data from one table field to another table field using sql statement

[narayan_k]

Hi to all,

 

Sub: How to copy txt from one table field to another table field using sql statement.

 

 

I wanted to copy some data from one table filed to another table field. (php/mysql)

 

There are 2 tables named Inventory & Purchase

 

Inventory table fields -

Model No

Model Name

Qty

 

Purchase table fields –

Model No

Model Name

Qty

 

 

If I add 5 in Qty field  (Purchase table) then it should add 5 to qty (inventory table)

 

I need simple sql statement for this

 

i hope will understand my problem

 

 

Thanks in advance

 

Narayan

 

[obsidian]

You can insert into the second table via a select on the first (http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-select-into-table.html):

INSERT INTO purchase_table p (model_no, model_name, qty)
  SELECT i.model_no, i.model_name, i.qty
  FROM inventory_table i;