Inserting a text file to MySQL

[Sundar]

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