D]>
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 ne
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
So
L PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 4:15 PM
Subject: Re: SELECT from blob column
Well, I found that I can use LOAD_FILE in INSERT statement, and I foud that
my text file should be finished with a newline char :( . Well... never mind.
Just another questio
Well, I found that I can use LOAD_FILE in INSERT statement, and I foud that
my text file should be finished with a newline char :( . Well... never mind.
Just another question : If i use PHP fread and got all the content of a file
in a single var, can I just INSERT the variable ?
sql
--
João
Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 12:40 PM
Subject: Re: SELECT from blob column
> João,
> Thursday, April 18, 2002, 5:16:26 PM, you wrote:
>
> JPV> I know it has been covered before. I
João,
Thursday, April 18, 2002, 5:16:26 PM, you wrote:
JPV> I know it has been covered before. I read the manual, I folow the examples,
JPV> and I am still having problems. What I want is store a blob in a blob field,
JPV> so:
JPV> CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB );
J
Hello everybody,
I know it has been covered before. I read the manual, I folow the examples,
and I am still having problems. What I want is store a blob in a blob field,
so:
CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB );
Query Ok.
INSERT INTO blobtest VALUES ( '1', LOAD_FILE('/r
