Inserting a text file to MySQL

[David A. Sinck]

\_ SMTP quoth Sundar on 2/10/2003 10:26 as having spake thusly:
\_
\_ Hi,
\_ 
\_ I am retrieving some text files from our Oracles server and been asked 
\_ to populate some feasible local server. So, obviously I selected MySQL, 
\_ though I haven't personally used it much. Now, I have a problem. How do 
\_ I store a text file in MySQL?

create table foo (
  thefile text
);

insert into foo ( [contents of file]);

YMMV.  There's also 'longtext' and 'verylongtext' IIRC.

David