"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/09/2005 01:52:58 PM:
> > All, > Could you tell me how to import data (file.txt)with BLOB column to mysql? > > Thank you > > Nguyen > > The "short answer" is: you escape the content of the file and make one big INSERT statement out of it. The escaped content becomes the data value you are inserting to your BLOB field. The "long answer" depends completely on *HOW* you are reading the file and connecting with MySQL. Describe for us the technique you would like to use and we can help you to refine it to make it work. Don't forget to include your which operating system you are on and what version MySQL server you are using. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
