1 row in set (0.00 sec)
regards
- Original Message -
From: "Ivan Paul" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 1:14 PM
Subject: Re: Updating blob from command line
dear kayamboo,
i've tried it, but seems there still something strange with this matter, so
i decided to create one table with myisam table type (default table type),
and i try to input data in this table. but when i check this up (do query) i
have null value in mediumblob field (pic).
this is th
FILE 'C:/TEMP/pic2.gif'
;
now you can go to c:/temp/pic2.gif and open in a browser to check whether it
is corrupted or transferring etc.,
regards
- Original Message -
From: "Ivan Paul" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Sent:
.
regards
- Original Message -
From: "Ivan Paul" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 3:11 PM
Subject: Re: Updating blob from command line
> dear kayamboo,
>
> can i use myisam table type to input
CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE =
INNODB ;
INSERT INTO temponly(name , pic) values( 'velan',
load_file('e:/mysql/images/Click.gif')) ;
Hope this helps.
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesda