sql - mysql update one table with data from another -


i getting issue update statement:

update customers set customers.email = initialsynctemptable.thinkemail,     customers.packages = initialsynctemptable.thinkpackages  customers inner join initialsynctemptable on  customers.id = initialsynctemptable.customerid 

and using mysql. there squigly line under word. trying update 1 table (customers) data table (initialsynctemptable).....help! thanking you

try

update customers c inner join         initialsynctemptable on  c.id = i.customerid    set c.email = i.thinkemail,        c.packages = i.thinkpackages  

Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -