INSERT INTO Animals(name,type,country_id) VALUES('Slim', 'Giraffe', 1) SELECT Animals.name, Animals.type, Animals.country_id, | 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) SELECT Animals.name, Animals.type, Animals.country_id,

Someone can help me

19th Nov 2021, 12:00 AM
Fodé Lamine Maréga
Fodé Lamine Maréga - avatar
2 Answers
+ 2
What you want? If you have the 'Animals' table with columns of the 'name,type,country_id', This code insert these values to it: ('Slim', 'Giraffe', 1) And then shows the new row by the bellows code: SELECT Animals.name, Animals.type, Animals.country_id,
19th Nov 2021, 12:08 AM
Seyed Mahmoud Khademiyan
0
It's a challenge for me in order to get SQL certification
20th Nov 2021, 2:48 AM
Fodé Lamine Maréga
Fodé Lamine Maréga - avatar