MySQL Forums
Forum List  »  PHP

Re: Column count doesn't match value count at row 1???????
Posted by: Leo Aulenta
Date: June 24, 2008 03:50AM

Ok don't worry i've founded the mistake

i wanted to concat the columns in 2 differetn times but i had to do it all in one
so with this new query all went good

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

thx for the help anyway!

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.