Re: load non-fixed formatted text files

2004-09-08 Thread Wesley Furgiuele
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

2004-09-08 Thread Christian Gielstrup
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 | +--++--+-+-+-

Re: formatted text

2004-02-11 Thread Chris Nolan
Hi! For formatted text, you may be able to get away with using FULLTEXT searches on MyISAM tables, depending on the definition of "formatted". Regards, Chris On Wed, 2004-02-11 at 18:55, Veysel Harun Sahin wrote: > Hello list, > > What is the best way to store and se

formatted text

2004-02-10 Thread Veysel Harun Sahin
Hello list, What is the best way to store and search formatted text? Thanks in advance. __ New! Unlimited Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Act now to get a