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!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
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 Réponses
+ 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