Inserting a text file to MySQL

David A. Sinck plug-discuss@lists.plug.phoenix.az.us
Mon, 10 Feb 2003 17:41:28 -0700


\_ SMTP quoth Sundar on 2/10/2003 16:16 as having spake thusly:
\_
\_ Thanks David,
\_ 
\_ When you say 
\_ 
\_ insert into foo ( [contents of file]);
\_ 
\_ Does it mean
\_ 
\_ insert into foo ( filename );
\_ 
\_ I am just trying to achieve it with a SQL query.

Ah.  Not quite sure how to do that in one query without resorting to
the docs or writing a perl script.  I've done it via the later.  

Both are left as an excercise for the reader.  :-)

David