loading files containing fixed-length fields

[Alain Motasim]

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 ( ID POSITION( 1 : 10 ),
NAME POSITION( 11 : 20 ))

I have browsed the URL http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#LOAD_DATA
but I haven't found anything similar. Is there a chance I can load this kind of file inline with MySQL?

Thanks for your help.
Best regards,

Almo



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php