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