Re: Updating blob from command line

2002-09-26 Thread kayamboo
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

Re: Updating blob from command line

2002-09-26 Thread Ivan Paul
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

Re: Updating blob from command line

2002-09-26 Thread kayamboo
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:

Re: Updating blob from command line

2002-09-25 Thread kayamboo
. 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

Re: Updating blob from command line

2002-09-25 Thread kayamboo
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