0

Whats wrong in this sql code pls help

insert into animals(name,type,country_id) values('slim','Giraffe','1') select animals.name,animals.type from animals inner join countries on animals.country_id=countries.id;

21st Jul 2021, 8:07 AM
Nagasai Akula
Nagasai Akula - avatar
9 Respuestas
+ 2
select name,type, country from animals missing type "Slim" capital S
21st Jul 2021, 9:17 AM
Bahhaⵣ
Bahhaⵣ - avatar
+ 3
sql is case insenstive orda?
21st Jul 2021, 9:22 AM
Nagasai Akula
Nagasai Akula - avatar
+ 1
"sorted by countries." you need ORDER BY country ; you are missing a semicolon on line 2.
21st Jul 2021, 8:29 AM
Bahhaⵣ
Bahhaⵣ - avatar
+ 1
My bad🤦🏻‍♂️ sorry and thank you🙏
21st Jul 2021, 9:58 AM
Nagasai Akula
Nagasai Akula - avatar
0
thank you , ive made the corrections but the code is not succeful my output and expected outputs are same but the code is not successful
21st Jul 2021, 9:17 AM
Nagasai Akula
Nagasai Akula - avatar
0
"Slim" capital S instead of "slim"
21st Jul 2021, 9:20 AM
Bahhaⵣ
Bahhaⵣ - avatar
0
Hey brother nagasai
22nd Jul 2021, 1:11 PM
Rotace
Rotace - avatar
0
Kindly pls contact me at suvarnapatil19085@gmail.com
22nd Jul 2021, 1:13 PM
Rotace
Rotace - avatar
0
contact for ?? the answer!!
22nd Jul 2021, 1:14 PM
Nagasai Akula
Nagasai Akula - avatar