Posted by MattMika on 07/26/06 23:15

I recently changed the field length for products_model in our products
table from varchar(12) to varchar(15) and failed to update that field
in our orders_products table. So now I have incomplete model #'s in
our orders_products table.

I am unsure how to go about doing this in a query. Maybe something
like this?:

UPDATE orders_products SET products_model = (SELECT products_model
from products)
WHERE products.products_id = orders_products.products_id;

Any suggestions would be greatly appreciated.
TIA
Matt Mika

• Next in forum: Re: Using arrays to take records from a html table and update database
• Prev in forum: Re: Using arrays to take records from a html table and update database
• Thread view: Update one table field from another table field query?

[Reply to this message]