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

Fw: Updating blob from command line

2002-09-25 Thread kayamboo
list mysql" <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 9:15 AM Subject: Re: Updating blob from command line > CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = > INNODB ; > INSERT INTO temponly(name , pic) values( 'velan', >

Re: Updating blob from command line

2002-09-25 Thread kayamboo
ED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line > Greetings, > > Is there anyway to import an image into a blob column from the > command line? By like making an sql script? > > What I have is a database that has

Updating blob from command line

2002-09-25 Thread Chris
Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to b