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 Respostas
+ 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