Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    7

    Thumbs up Unanswered: appending data to same column

    hi,
    i have splitted the big file to 56 small files(text file) and want to send to mysql database. i want all those content to be put in the same column.how to do that? (appending the data).
    i'm using Perl script.

    thanks..

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which column?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2006
    Posts
    7
    for example :
    mysql
    table (data)

    id | File
    -------------
    0 | THIS COLUMN

    i want to put all the text files(1-56) contents into only one column.

    do you think this is the best way to deal with it ? see the flow

    pwr.gz (local dir) ---> splitted(56 files) --->upload to Mysql ---> fetch (output to output.txt) at server side(where this script reside) ---> download from web.
    Last edited by farhan26; 09-08-06 at 06:01.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by farhan26
    do you think this is the best way to deal with it ?
    me? no

    i would simply store the 56 files on the web server and skip mysql altogether

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •