0

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,

1
Contributor
1
Reply
2
Views
5 Years
Discussion Span
Last Post by softDeveloper
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.