+ 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;
2 Answers
+ 2
Arun Venkatesh.N
Add semicolon after insert query
ORDER BY Animals.country_id DESC;