SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Oct 2002
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    phpMyAdmin question

    I'm new to PHP and phpMyAdmin.

    I'd like to import a tab delimited text file into a MySQL DB. It seems that phpMyAdmin only allows comma or semicolon delimeted fields.
    Is there a way to have it accept tab delimited?

    TIA
    Last edited by artcarter; Oct 25, 2002 at 10:05.

  2. #2
    pg for mild peril cow's Avatar
    Join Date
    Mar 2000
    Location
    nevada, usa
    Posts
    636
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i don't see a away to make it accept tab delims. why don't you just replace your tabs with semicolons?
    "There's no justice like angry mob justice!" --Seymour Skinner

  3. #3
    SitePoint Member
    Join Date
    Oct 2002
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help loading text files into table

    I'd like to load a tab delimited text file into a table. According to the MySQL documentation the command is:


    mysql> LOAD DATA LOCAL INFILE "textfile.txt" INTO TABLE TableName;

    What this does not say is how you tell MySQl to LOAD a text file in a particular subdirectory. ie /user/username/documents/textfile.txt

    TIA

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved and Merged Similar threads.
    Last edited by Sketch; Oct 25, 2002 at 12:21.
    Aaron Brazell
    Technosailor




Bookmarks

Posting Permissions

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