Not to beat an apparently dead horse...
My problem was that interactively I could not get the following statement to
execute (on Win NT, myISAM table, mySQL 3.23.49-nt):
insert mytable values (1, 2 ,3, LOAD_FILE('c:\myfile.ext'));
However, I found this would work:
insert mytable (col1, col2, col3) values (1,2,3);
update mytable set col4 = LOAD_FILE('c:\myfile.ext')) where col1 = 1;
Is this unusual? Is there something I am missing here?
-Grady
----- Original Message -----
From: "Jo�o Paulo Vasconcellos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 5:29 PM
Subject: Re: SELECT from blob column
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
---------------------------------------------------------------------
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
