0

May someone tell me what is wrong with this code

INSERT INTO Animals VALUES ('Slim','Giraff',1); SELECT Animals.Name,Animals.Type,Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.ID ORDER BY Countries DESC;

7th Mar 2021, 2:38 AM
Shamson Yacoub
Shamson Yacoub - avatar
2 RĂ©ponses
+ 3
Giraff(e) 🩒
7th Mar 2021, 2:43 AM
Simba
Simba - avatar
+ 1
Shamson Yacoub See here my code You will got your mistake: /* name - "Slim", type - "Giraffe", country_id - 1 */ INSERT INTO Animals(name, type,country_id) VALUES('Slim','Giraffe',1); SELECT Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY Countries.country;
8th Mar 2021, 7:54 PM
â€ïžđŸ˜PreranađŸ˜â€ïž
â€ïžđŸ˜PreranađŸ˜â€ïž - avatar