Load Data Infile, Mysql

Discussion in 'MySQL' started by ayhanozgul, Dec 8, 2006.

  1. #1
    hello i have a question :)
    i have some txt te files which i need to put them in a database
    -------
    LOAD DATA LOCAL INFILE '/warehouse/0_27_13_50.LOG' INTO TABLE etay_template_A25_26_1 FIELDS TERMINATED BY '#';
    --------
    there is no problem with this but i have alot of log files :) i need to write a script which must send all different files to database and show elapsed time too
    can anybody help me
    ---------

    '/warehouse/0_27_13_50.LOG'
    '/warehouse/0_27_13_51.LOG'
    '/warehouse/0_27_13_52.LOG'
    '/warehouse/0_27_13_53.LOG'
    '/warehouse/0_27_13_54.LOG'
    .
    .
    .
    .
    .
     
    ayhanozgul, Dec 8, 2006 IP
  2. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #2
    paste some lines from a logfile explain what it is in as few words as possible ( else I'll forget ) and tell us what you want out the other end, and most probably :)
     
    krakjoe, Dec 8, 2006 IP