I need to update the 'products_id' field (shown below) by copying data from
a separate table but I can't use the 'UPDATE' query as each 'product_id'
entry relates to a specific 'products_model' row.
id / assembly_no / products_id / products_model
1 / 2313 / *** / CASEACERENTRY2
2 / 2313 / *** / 9145S05001
I've tried using the 'UPDATE' query but as the 'LIMIT' function doesn't work
with 'UPDATE' every time I run the query it updates every row with the same
Please can somebody help???
P.S. I'm running MySQL 4.0.26 using phpMyAdmin