What's wrong for my sql 'insert'? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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);

17th Aug 2021, 6:41 AM
Naufal Prashadito
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
17th Aug 2021, 7:20 AM
Ipang
+ 2
Can you paste the task Description here?
17th Aug 2021, 7:17 AM
Ipang
+ 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
17th Aug 2021, 8:25 AM
Ipang
+ 1
Which DBMS is involved?. Was there any errror message? what did it say?
17th Aug 2021, 7:05 AM
Ipang
+ 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.
17th Aug 2021, 7:19 AM
Naufal Prashadito
+ 1
Thank you, Mr. Ipang
17th Aug 2021, 7:37 AM
Naufal Prashadito
+ 1
INSERT INTO garage VALUES (6, 'Mercedes-Benz', 'G 63', 2020),(7, 'Porsche', 'Panamera', 2020); SELECT * FROM garage
7th Feb 2022, 4:33 PM
Vitaliy Solomatin
Vitaliy  Solomatin - avatar
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
17th Aug 2021, 7:10 AM
Naufal Prashadito
0
You're very welcome 👌
17th Aug 2021, 7:39 AM
Ipang