RE: loading files containing fixed-length fields

2002-11-05 Thread Black, Kelly W [PCS]
Motasim; [EMAIL PROTECTED] Subject: Re: loading files containing fixed-length fields Alain Motasim wrote: > Hello, > > I would like to load text files containing fixed-length fields into a > MySQL table by specifying position indices like when loading files > into an Oracle database

RE: loading files containing fixed-length fields....Mr. Dice showed me the way.

2002-11-05 Thread Black, Kelly W [PCS]
in my brain. sql,query foo ~Kelly W. Black -Original Message- From: Daniel Kasak [mailto:dkasak@;nusconsulting.com.au] Sent: Tuesday, November 05, 2002 2:49 PM To: Alain Motasim; [EMAIL PROTECTED] Subject: Re: loading files containing fixed-length fields Alain Motasim wrote: > Hello, &

Re: loading files containing fixed-length fields

2002-11-05 Thread Daniel Kasak
Alain Motasim wrote: Hello, I would like to load text files containing fixed-length fields into a MySQL table by specifying position indices like when loading files into an Oracle database, with a syntax close to this: LOAD DATA INFILE'c:\mydata.dat' append INTO MYTABLE