Dear All,

I have a database with two columns, to keep several files of text with lots of text lines in each text:
-----------------------
|---name -|- Text---|
-----------------------


I want the column |-name-| to be a primary key, and to upload the text file I'm using the command:

LOAD DATA LOCAL INFILE 'TEXT.htm' INTO TABLE TB(Text) SET name = 'file1';

If set the column 'name' as primary key it won't let me upload more than one line of text by column name.

Can you give me a help on this? A way so that I can upload a text file directly into the text column?

Kind Regards,