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,