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!

6th Jan 2022, 8:16 PM
liu Carrie
liu Carrie - avatar
5 Réponses
+ 2
Nm ive fixed this! I forgot to add the query ‘ select * from garage’ to ask Sql return the adjusted table
6th Jan 2022, 8:39 PM
liu Carrie
liu Carrie - avatar
0
Sql doesn't use lower case in it's keywords
6th Jan 2022, 8:29 PM
🥇👩‍💻 Kintu Michael Evans 🔥🔥( Active)
🥇👩‍💻 Kintu Michael Evans 🔥🔥( Active) - avatar
0
i remember that Sql is case insensitive, and i’ve changed key words to uppercase but the code still cant get any output🥲
6th Jan 2022, 8:34 PM
liu Carrie
liu Carrie - avatar
0
That is good
8th Jan 2022, 6:31 PM
🥇👩‍💻 Kintu Michael Evans 🔥🔥( Active)
🥇👩‍💻 Kintu Michael Evans 🔥🔥( Active) - avatar
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;
13th Feb 2022, 5:23 PM
Ahmed Abd El-Awal