#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    LOAD DATA INFILE works fine normally, but will not work fot this table:

    CREATE TABLE search_cat(
    title VARCHAR (70) not null,
    place VARCHAR (200) not null);

    An example of the file being loaded:
    "Acting","Arts/Performing_Arts/"
    "Genres","Arts/"
    "Horror","Arts/Genres/"

    And resulting data is entered as:
    --------------------------------------------------------------
    Regional | Arts/Performing_Arts/" "Acting*|
    Genres | Arts/" "Horror |
    Science_Fiction_and_Fantasy | Arts/Genres/" "Art* |
    --------------------------------------------------------------

    Any idea to why this is not loading properly?


    Thank you.
    yoshi
    datera@datera.com http://www.datera.com

    [This message has been edited by yoshi (edited September 25, 2000).]
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    I could be totally wrong, but I don't think you need to put text values in quotes for LOAD DATA INFILE. Also, I thought that command worked for tab-delmited files, I've never tried to feed it a file that used commas as delimters?
  4. #3
  5. No Profile Picture
    Carpe Diem
    Guest
    Devshed Newbie (0 - 499 posts)
    Yes you can use all different methods for load data infile

    Make sure you are using :-
    FIELDS ENCLOSED BY '"' FIELDS TERMINATED BY ','

    Regards
    Darren http://www.php4hosting.com/ $ http://www.php4hosting.co.uk/
    PHP/MySQL Hosting from under $5
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    word.

Similar Threads

  1. load data infile PHP parse error
    By georgeatef in forum PHP Development
    Replies: 3
    Last Post: June 9th, 2004, 12:07 AM
  2. Replies: 0
    Last Post: February 11th, 2004, 03:56 PM
  3. Codepupil
    By Adachic in forum C Programming
    Replies: 3
    Last Post: February 6th, 2004, 07:50 PM
  4. Newbie trying to load data file
    By wab25 in forum Flash Help
    Replies: 2
    Last Post: February 6th, 2004, 05:21 PM
  5. load data alpha in quote, number not
    By st_moose in forum MySQL Help
    Replies: 1
    Last Post: January 28th, 2004, 12:58 AM

IMN logo majestic logo threadwatch logo seochat tools logo