Member Avatar for softDeveloper

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
  • 173 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by softDeveloper
Member Avatar for softDeveloper

I solved it using BLOB fields!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.