Re: load non-fixed formatted text files

Christian: Change your readme and hostname columns to BLOB and use the LOAD_FILE() function to add your record. INSERT INTO test NULL, LOAD_FILE( '/path/to/readme/file' ), LOAD_FILE( '/path/to/hostname/file'); More on the LOAD_FILE() function: http://dev.mysql.com/doc/mysql/en/String_functions.ht

load non-fixed formatted text files

Hi gurus, can you pls. help a mysql newbee? I need to load data into the following table mysql> describe test; +--++--+-+-++ | Field| Type | Null | Key | Default | Extra | +--++--+-+-+-