+ 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; В синтаксисе ошибка?
2 odpowiedzi
+ 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;