I have two tables (table_a and table_b). Each table has the same columns/data types.
I'm trying to update the entire row in table_b from table_a joining on table_a.ID=tableb.ID.
Is there another way to do this besides UPDATE or do I need to just suck it up and list all of the columns (SET table_b.col1=table_a.col1 etc.)?