Which of the following are true about UPDATE statements?
Each correct answer represents a complete solution. Choose all that apply.
A.
You can use co-related sub query in UPDATE statements to update data from other tables.
B.
If you don’t use the WHERE clause then the UPDATE will not update any rows in the table.
C.
You use the SET clause to update multiple columns of a table separated by commas.
D.
You can use the WHERE clause to have your update affects a specific set of rows.