+ 1

Is there any mistake in it? I can't get output

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;

3rd Sep 2022, 6:03 AM
Venkatesh
Venkatesh - avatar
2 Answers
+ 2
Arun Venkatesh.N Add semicolon after insert query ORDER BY Animals.country_id DESC;
3rd Sep 2022, 6:28 AM
AÍąJ
AÍąJ - avatar