+ 1

this is my Code In the Zoo project can anyone Tell me what's wrong?

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 ;

1st Apr 2022, 10:21 PM
Asmaa Abd elazeem Hamoda
7 odpowiedzi
+ 4
Didn't you forget ; at the end of the first SQL request?
1st Apr 2022, 10:32 PM
Orisa
Orisa - avatar
+ 3
Slim must be capitalized. That should fix it.
1st Apr 2022, 10:28 PM
Brian
Brian - avatar
+ 2
Brian I fixed it thanks for the help♥️ after I made it capital there Was an error too to fix it I had to put Semicolon👉 ; after the Insert Part too not just at the end.. and that fixed it
1st Apr 2022, 10:32 PM
Asmaa Abd elazeem Hamoda
0
The string values, slim and Giraffe, need to be enclosed within single quotes.
1st Apr 2022, 10:24 PM
Brian
Brian - avatar
0
Brian I just fixed it but still not working
1st Apr 2022, 10:25 PM
Asmaa Abd elazeem Hamoda
0
Orisa I've just noticed that, thank you ♥️♥️♥️
1st Apr 2022, 10:33 PM
Asmaa Abd elazeem Hamoda