Create insert syntax for these tables please. I\'ve having trouble doing them co

Question

Create insert syntax for these tables please. I've having trouble doing them correctly in SQL.

mysol> INSERT INTO PRODUCT > PRODUCT ID, PRODUCT NAME, PRODUCT PRICE PRODUCT TYPE ID VALUES 5), (1, (1, [1, [1, (1 'Soda' ,2.09, 'Bottled Water, 1.99, 'Sparkling Water", -> > 5), , 2.49, 5), -> [1, 1 Lemon Seltzer, 2.49, 5), -> (2, 'Peppermint Hocha', 4.89, 1), -> (1, 'Carrot Pineapple Power Smoothie', 3.89, 3), > 1 Paradise Juice, 2.49, 5) > 1 Lemonade, 2.09, 4) > > "Iced Tea, 2.09, 4), 'Hot Coffee', 2.09, 2), [1, -> (l, 'Hot Tea', 1.69, 2) ERROR 1064 (42000): You have an error in your SQL syntax: check the manual that corresponds to your HySQL server version for the right syntax to use near 'VALUES (l, 'Soda',2.09, 5, (l, 'Bottled Water' 1.99, 5), (1, 'Sparkling Water'' at line 3

Explanation / Answer

You have missed one bracket after specifying the column names. So,it should be like

insert into table_name(column names) values();

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.