Why not just specify what columns you are inserting into? This check has to be in place, because in the case of a mismatch MySQL would not know which value goes into which column.
Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Campbell D. McCausland [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 1:13 PM To: [EMAIL PROTECTED] Subject: Turning off column and value reconciliation I'm getting the error message:- <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. Is there a way to achieve this? thanks, Campbell --------------------------- 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]
