Re: Turning off column and value reconciliation

2003-06-09 Thread Campbell D. McCausland
Thanks for the suggestion, but its a tossup between that and the perl 8o( I'll need to give it some thought about how much I want to port. MySQL is sure easier to install and also faster (I'm told anyway, without getting my data in I can't be sure). best, Campbell At 04:22 PM 6/9/2003 -0400, Keit

RE: Turning off column and value reconciliation

2003-06-09 Thread Campbell D. McCausland
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

Re: Turning off column and value reconciliation

2003-06-09 Thread Keith C. Ivey
On 9 Jun 2003 at 13:16, Campbell D. McCausland wrote: > 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

RE: Turning off column and value reconciliation

2003-06-09 Thread Mike Hillyer
] 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

Re: Turning off column and value reconciliation

2003-06-09 Thread Campbell D. McCausland
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 th

Re: Turning off column and value reconciliation

2003-06-09 Thread Keith C. Ivey
On 9 Jun 2003 at 12:13, Campbell D. McCausland wrote: > 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 colu

RE: Turning off column and value reconciliation

2003-06-09 Thread Mike Hillyer
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 PROTECT