Cant insert into SQL table (column count doesn’t match value error 1136)

I have two tables species and specimen. ‘speciesName’ from species is a foreign key in specimen Command: INSERT INTO Specimen VALUES ( (SELECT SpeciesName From Species WHERE SpeciesName=’Vulpes lagopus’),105, ‘2017-03-02′, 90,110,’Brazil’); Code: CREATE TABLE Species ( SpeciesName varchar(25) NOT NULL, Color varchar(25), AvgHeight int, Avgweight int, PRIMARY KEY(SpeciesName) ); CREATE TABLE Specimen ( FOREIGN KEY(SpeciesName)…

Details