Re: Inserting a text or Word file into mysql

2002-08-27 Thread walt
Thomas Spahni wrote: > On Mon, 26 Aug 2002, Donald J Miller wrote: > > > Hello everyone, > > > > I am trying to create a mysql table to hold either the entire contents > > of text or WordPerfect files. I've read about BLOB or TEXT type columns > > so I've tried creating a table such as: > > > >

Re: Inserting a text or Word file into mysql

2002-08-27 Thread Thomas Spahni
On Mon, 26 Aug 2002, Donald J Miller wrote: > Hello everyone, > > I am trying to create a mysql table to hold either the entire contents > of text or WordPerfect files. I've read about BLOB or TEXT type columns > so I've tried creating a table such as: > > CREATE TABLE filetest(fileid int(5) n

Re: Inserting a text or Word file into mysql

2002-08-26 Thread Keith C. Ivey
On 26 Aug 2002, at 15:32, Donald J Miller wrote: > CREATE TABLE filetest(fileid int(5) not null, file BLOB null); > > I 've created the table and have used LOAD DATA in order to populate the > database however I get numerous errors. Can someone shed some light as > to how to do this correctly?

Inserting a text or Word file into mysql

2002-08-26 Thread Donald J Miller
Hello everyone, I am trying to create a mysql table to hold either the entire contents of text or WordPerfect files. I've read about BLOB or TEXT type columns so I've tried creating a table such as: CREATE TABLE filetest(fileid int(5) not null, file BLOB null); I 've created the table and have