mysql update query from another table -


i want update fields in products table temporary table called updated table.

so far have this, have sql error, cant find yet though.

update destination   set destination.title = source.title,  destination.title_tag = source.title_tag, destination.keywords = source.keywords  updated_table source  join products destination on source.id = destination.id 

update products destination join updated_table source on source.id = destination.id set destination.title = source.title,  destination.title_tag = source.title_tag, destination.keywords = source.keywords 

Comments