Re: Column count doesn't match value count at row 1???????

[Leo Aulenta]

I'm on my apprenticeship and i'm working with sql at the moment!
But i'm having some problems with this query:

INSERT INTO amaca.Transcript_Exon
SELECT concat(ADB.TranscriptID, '-', ADB.RunID) as idTranscript,ADB.* FROM AspicDB.Transcript_Exon as ADB

that gives me the error of this post!
anyway the strange thing is that i did the exactly same query a couple of minutes before but with 2 different tables...
the query looks like this:

INSERT INTO amaca.Transcript
SELECT concat(ADB.RunID, '-', ADB.TranscriptID) as idTranscript,ADB.* FROM AspicDB.Transcript as ADB

last one works perfectly!
Name of the columns and rows are ok, i checked them more than one time, but still got the problem...

Any idea?