INSERT INTO Animals (name, type, country_id) VALUES ('Slim', 'Giraffe', 1); | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

INSERT INTO Animals (name, type, country_id) VALUES ('Slim', 'Giraffe', 1);

I type this query in last sql project but answer no output and try again please let me know where am I wrong?

24th Nov 2021, 2:07 AM
Zalak Kaushal Patel
Zalak Kaushal Patel - avatar
2 Answers
+ 2
Zalak Kaushal Patel Just inserting data is not enough, you have to write select query to display data. Did you read this statement? "Write a query to output a new table with each animal's name, type and country fields, sorted by countries." This is the biggest mistake of all new learner, they don't read everything.
24th Nov 2021, 2:58 AM
A͢J
A͢J - avatar
+ 2
You inserted new data to the db but you didn't make any query from db. For that use SELECT * FROM db WHERE name = 'Slim'
24th Nov 2021, 9:55 AM
Shadoff
Shadoff - avatar