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 > >