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

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

RE: NULL Values in mysqldump

2002-02-27 Thread Baines, Dominic
:[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 be used with MySQL but if you want to port it to another RDBMS the /N for a NULL