Inserting a text file to MySQL

Oops! I should have told just one field, rather than one column.

i.e.
Project table
--------------------------------------

 | Project_No  | Project_Docs              |

---------------------------------------

 | 00000001   | 000000001.zip             |

---------------------------------------

 | 00000002  | 000000002.zip             |

[....]

The problem is getting 000000001.zip to Project_Docs field

Sundar

David A. Sinck wrote:

>\_ SMTP quoth Sundar on 2/11/2003 08:28 as having spake thusly:
>\_ [...]
>\_ Mike - I don't want to load a text file to a table, rather to just one
>\_ column. Something like CLOB in oracle.
>
>I believe that if you feed the parameters properly to mysql for 'LOAD
>DATA ...' it will slurp it all into a row for you. Still, an exercise
>for the reader. Possibly even a faq.
>
>David
>---------------------------------------------------
>PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>To subscribe, unsubscribe, or to change you mail settings:
>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>