mysql update one table with data from another

Question

I am getting an issue with this update statement:

update customers
set customers.email = initialsynctemptable.thinkEmail,
    customers.packages = initialsynctemptable.thinkPackages 
FROM customers INNER JOIN initialsynctemptable
ON  customers.id = initialsynctemptable.customerID

and are using mySQL. There is a squigly line under the FROM word. Essentially I am trying to do an update one table (customers) with data from another table (initialsynctemptable).....Help! Thanking you

from is not used for this. RTLM: dev.mysql.com/doc/refman/5.0/en/join.html — Marc B
– Marc B, Commented May 2, 2013 at 21:51

peterm · Accepted Answer · 2013-05-02 21:52:09Z

2

Try

UPDATE customers c INNER JOIN 
       initialsynctemptable i ON  c.id = i.customerID
   SET c.email = i.thinkEmail,
       c.packages = i.thinkPackages

answered May 2, 2013 at 21:52

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mat41 Over a year ago

another quick question if I can. If thinkemail and thinkpackages are varchars which could have null values do you think i need a WHERE clause? Thanking you

peterm Over a year ago

@Mat41 You're welcome. Glad it helped. Now if you want to prevent it from happening (assigning NULL values) then go ahead and filter those records out with WHERE clause.

Collectives™ on Stack Overflow

mysql update one table with data from another

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related