In Thursday 18 April 2002 17:56, Grady Drago wrote: > >> Well, I found that I can use LOAD_FILE in INSERT statement, and I found > > that > > >> my text file should be finished with a newline char :( . Well... never > > mind. > > Would you give an example please? >
If you do : $ cat >test.file Some text. ^D $ And then use LOAD_FILE(), the data doesn't show up. But if you do: $ cat >test.file Some text. ^D $ Then the text shows up. Better saying, if you create a file without a trailing newline, the text does not show up, but if you put a trailing newline, it appears. sql -- Joćo Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] --------------------------------------------------------------------- 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
