Error a task INSERT | Sololearn: Learn to code for FREE!

+1

Error a task INSERT

вывод выдает правильный, но не засчитывает решение задачи INSERT INTO Garage (id, make, model, prodyear) VALUES (6, 'Mercedes-Benz', G 63, 2020), (7, 'Porcshe', 'Panamera', 2020); SELECT * from Garage; В синтаксисе ошибка?

3/1/2021 8:40:50 PM

Vasily Bylin

2 Answers

New Answer

+1

Is id auto increment field (set automatic at insert) or does the value of id alread exist in the database (6 and/or 7)? The latter would be an issue if id is set to unique.

0

INSERT INTO Garage (id, make, model, prodyear) VALUES (6, 'Mercedes-Benz', 'G 63', 2020); INSERT INTO Garage (id, make, model, prodyear) VALUES (7, 'Porsche', 'Panamera', 2020); SELECT * FROM Garage;