Loading values from a column of one table to the column of another

Databases
1

Hi there,
I have three tables products(id,abc,xyz,etc…)
product_descriptions(product_id,id,description,summary,etc)
prices(id,ref,price,warranty,product_id)

I have 2 already create and populated tables and one new table prices

i need to load the values of prices.ref from the product_descriptions.description
such that the value of prices.ref is a substring that can be obtained using the result of query
SELECT SUBSTRING( description, INSTR( description, ‘Ref’ ) +4 ) , description
FROM product_descriptions
WHERE description LIKE ‘%Ref%’
LIMIT 0 , 30

and I also need to load the corresponding product_id for the description from which the prices.ref is derived as the product_id of price…

Can anyone help me with this issue…

currently prices table has no values , i need to populate both ref and their corresponding product_ids

prices.ref is an integer and product_descriptions.description is mediumtext

PS: I know the tables are not normalized , but I am still required to do it this way…
Thanks.

2

Have a read about the IEINSERT SELECT syntax

3

Hi , do we have a update select statement as well? …i can’t find it though :S

and Thanks for the help !!!

4

not exactly :slight_smile:

you can update one table from anouther, though

look in da manual under UPDATE syntax for joined update

5

Thank you very much!!! you people are very helpful!