There is no way to turn it off (well, no practical way, with open source nothing is impossible).
Can you add dummy columns to the mysql table to the insert statements match up? Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Campbell D. McCausland [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:17 PM To: [EMAIL PROTECTED] Subject: Re: Turning off column and value reconciliation Mike, Keith, Thank you for your responses. Unfortunately, the sql I'm loading is output from another tool, so I don't get to vote on the format of the insert statements. If it's not possible to just turn the check off, then I guess I'll have to consider writing a perl script or something to add the column specifiers. Please confirm that there is no way to turn this check off. That way, I'll be able to stop looking for one. 8o) best regards, Campbell At 03:14 PM 6/9/2003 -0400, Keith C. Ivey wrote: >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 --------------------------- BridgePoint UML ----------------------- Campbell D. McCausland Tel: (520) 544 2881 x21 Dir. Research and Development Fax: (520) 544 2912 Project Technology Inc 7400 N. Oracle Road, Suite 365 Tucson Arizona [EMAIL PROTECTED] 85704-6342 www.projtech.com USA -------------------- DesignPoint Model Compilers ------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
