Inserting a text file to MySQL

トップ ページ
添付ファイル:
Eメールのメッセージ
+ (text/plain)
このメッセージを削除
このメッセージに返信
著者: Sundar
日付:  
題目: 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 -
>To subscribe, unsubscribe, or to change you mail settings:
>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>