The editor holds the supplier's new list. Product 7 exists; product 13 is new.
- Run the statement as it is and read the error. Then change it so that it loads both rows: product 7 takes the new price and stock, and product 13 is added.
The newsletter table has a row for Ava and a row for Omar, with short names. Its primary key is email.
- Add Ava Chen (
ava.chen@example.com) and Mia Johnson (mia.j@example.com) with one statement. Ava's existing row must not change. - Add Omar Haddad (
omar.h@example.com) and Yuki Tanaka (yuki.t@example.com) with one statement. This time, Omar's row takes the full name.