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
Post a Comment