Some Mysql Query Help

fluiduk · 8 Feb 2007 at 20:11

Hi All

Does anyone have ideas why this query isnt working? It doesnt return any errors, but it doesnt effect any rows.

Code:

UPDATE in_price_comb_temp SET stock = 'in_stock_temp.stock', date_added = 'in_stock_temp.date_added' WHERE 'in_price_comb_temp.dist_pn' = 'in_stock_temp.dist_pn'

Not sure if this even should work. Just trying to find a way of not selecting all the records and updating them one by in PHP

Thanks
Aaron

fluiduk · 8 Feb 2007 at 21:41

Running it now, taken 600 seconds so far.. eek! 40000 records though so not surprised

Thanks

Aaron

fluiduk · 8 Feb 2007 at 22:04

2000 seconds now eek

fluiduk · 8 Feb 2007 at 22:42

4000 seconds now, and not done. Doesnt tell me how many it has done

fluiduk · 15 Feb 2007 at 11:05

Hi Jon

Thanks for the message. That query doesn't work

I can't give too much information on here, as its quite sensitive. I will give all the details I can, what would help?

Thanks
Aaron