0
What's wrong for my sql 'insert'?
INSERT INTO GARAGE (ID, MAKE, MODEL, PRODYEAR) VALUES (6,'Mercedez-Benz','G 63', 2020), (7, 'Porche', 'Panamera', 2020);
9 Answers
+ 5
Task had 'Mercedes-Benz'
Your query had 'Mercedez-Benz'
Notice the difference between 'Mercedes' and 'Mercedez'. Even just one different letter makes a difference in challenges like this
+ 2
Can you paste the task Description here?
+ 2
Naufal,
I'm sorry I cannot reply DMs. I can only read them, but cannot reply.
Also, I am not the person to suggest you a roadmap to pursue a career as front-end developer, or database administrator. I'm a hobbyist not a professional .
Though, I have found some threads relevant to front-end development and/or database administration. Hope it helps even just a bit.
https://www.sololearn.com/Discuss/478553/?ref=app
https://www.sololearn.com/Discuss/2142943/?ref=app
https://www.sololearn.com/Discuss/2363423/?ref=app
https://www.sololearn.com/Discuss/2395746/?ref=app
https://www.sololearn.com/Discuss/2401303/?ref=app
https://www.sololearn.com/Discuss/2708465/?ref=app
https://www.sololearn.com/Discuss/137531/?ref=app
https://www.sololearn.com/Discuss/1326070/?ref=app
https://www.sololearn.com/Discuss/1704708/?ref=app
+ 1
Which DBMS is involved?.
Was there any errror message? what did it say?
+ 1
You plan to add two more vehicles to your garage:
6, 'Mercedes-Benz', 'G 63', 2020
7, 'Porsche', 'Panamera', 2020
Write a query to insert the new cars into your table named 'Garage'. Then show the table with the added records.
+ 1
Thank you, Mr. Ipang
+ 1
INSERT INTO garage
VALUES (6, 'Mercedes-Benz', 'G 63', 2020),(7, 'Porsche', 'Panamera', 2020);
SELECT * FROM garage
0
INSERT INTO GARAGE VALUES (6,'Mercedez-Benz','G 63', 2020), (7, 'Porche', 'Panamera', 2020);
SELECT GARAGE.ID, GARAGE.MAKE, GARAGE.MODEL, GARAGE.PRODYEAR FROM GARAGE
not error message.. it's a same output for expected but can't be approved
0
You're very welcome 👌