Hello.


Please, could you provide the CREATE statement for you tables

and describe the relationships between their fields (it will

be good if you include sample data as well).







Matthew Batt wrote:

> Hi

> 

> 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 'products_id' information!

> 

> Please can somebody help???

> 

> P.S. I'm running MySQL 4.0.26 using phpMyAdmin

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to