RE: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?

2002-03-05 Thread Baines, Dominic
Just use delimiters in Oracle... then use same delimiters on the import... simple any lines or blank spaces etc would be ignored. Also turn feedback off in Oracle so you don't get all the headers etc... -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002

RE: NULL Values in mysqldump

2002-02-27 Thread Baines, Dominic
n time. Regards, Dominic -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 15:12 To: [EMAIL PROTECTED] Subject: Re: NULL Values in mysqldump On 27 Feb 2002, at 8:18, Baines, Dominic wrote: > If you immediately use the dump, this is fine if it is to b

NULL Values in mysqldump

2002-02-27 Thread Baines, Dominic
This is probably an easy one for someone... Is here an easy way NOT to have a mysqldump data file that includes /N when the column is a NULL ? Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data file for al the NULL VALUES. Scripting a global cut or strip out o