0
Sql quiz More Cars! (Insert into code practice
The question asks me to insert two rows into the table and I wrote: insert into garage (id, make, model, prodyear) values (6, 'Mercedes-Benz', 'G 63', 2020), (7, 'Porsche', 'Panamera', 2020 ); Then the sql returns no output. Do anyone know what mistake did I make here? Thanx a lot!
5 Antworten
+ 2
Nm ive fixed this! I forgot to add the query ‘ select * from garage’ to ask Sql return the adjusted table
0
Sql doesn't use lower case in it's keywords
0
i remember that Sql is case insensitive, and i’ve changed key words to uppercase but the code still cant get any output🥲
0
That is good
0
You forgot to write select * from Garage; to show the table after inserting raws like this
INSERT INTO Garage
VALUES (6, 'Mercedes-Benz', 'G 63', 2020),
(7, 'Porsche', 'Panamera', 2020 );
select * from Garage;