On 9 Jun 2003 at 12:13, Campbell D. McCausland wrote: > <http://forums.devshed.com/t49723/s.html>General error: "Column count > doesn't match value count" > > I know what it means, but I need MySQL to turn off this > checking. I'm loading legacy data into a new database > that has some extra columns and I just want to fill the > old columns with the legacy data.
It's hard to know since you don't show us any of your code, but it looks like you should add the list of column names to your INSERT or LOAD statement rather than letting the list default to all the columns. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]