¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita0
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 Respuestas
+ 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;