Create insert syntax for these tables please Ive having trou
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 3Solution
You have missed one bracket after specifying the column names. So,it should be like
insert into table_name(column names) values();
