[WTH] mysql Guru

Discussion in 'Programming' started by nitrogen77, Feb 21, 2009.

0
  1. #1
    Ok...
    I have a mysql file, that needs to be loaded , the file goes like this...

    INSERT INTO `words` (`id`, `section`, `word`, `url`) VALUES(18, 'A1', 'adobe', 'none');
    INSERT INTO `words` (`id`, `section`, `word`, `url`) VALUES(19, 'A1', 'adrenaline', 'none');
    INSERT INTO `words` (`id`, `section`, `word`, `url`) VALUES(20, 'A1', 'ads', 'none');
    INSERT INTO `words` (`id`, `section`, `word`, `url`) VALUES(21, 'A1', 'adventure', 'none');

    This is all well, and go for over 10.000 "words" ... now I need a system to be able to replace the "words" for other "words" found in a different TXT file.
    The reason? I'm trying to use the same system, but loading a spanish list of words.

    I hope this make sense, please quote in public your rate to be able to "load" the new TXT file in the same format as the code below.

    Thanks
     
    nitrogen77, Feb 21, 2009 IP
  2. Objects

    Objects Well-Known Member

    Messages:
    388
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    140
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    you mean that this TXT file has a structure like:
    adobe = something
    adrenaline = somethingelse
    and so on?
     
    Objects, Feb 21, 2009 IP
  3. nitrogen77

    nitrogen77 Active Member

    Messages:
    1,276
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    80
    As Seller:
    100% - 0
    As Buyer:
    62.5% - 10
    #3
    No the TXT file is just a list of words

    amigo
    aleman
    alemania

    I need a script of mysql command to insert them as
    "INSERT INTO `words` (`id`, `section`, `word`, `url`) VALUES(21, 'A1', 'amigo', 'none');

    Keep in Mind that A1 stands for Page 1 of Words starting with A.
     
    nitrogen77, Feb 21, 2009 IP
  4. Objects

    Objects Well-Known Member

    Messages:
    388
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    140
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    pm me the details I can do that
     
    Objects, Feb 21, 2009 IP
  5. atlantaazfinest

    atlantaazfinest Peon

    Messages:
    389
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    Nitrogen ill code you up and make sure it works for $15

    question you need the A1 to change on word change?
     
    atlantaazfinest, Feb 21, 2009 IP
  6. nitrogen77

    nitrogen77 Active Member

    Messages:
    1,276
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    80
    As Seller:
    100% - 0
    As Buyer:
    62.5% - 10
    #6
    Atlanta, A1 refers to Page 1 for letters starting with the letter A.
    Each page has 50 words.

    I already have 2 DP members working on it.
    So I can only pay for the first one that arrived with a solution.
     
    nitrogen77, Feb 21, 2009 IP
  7. nitrogen77

    nitrogen77 Active Member

    Messages:
    1,276
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    80
    As Seller:
    100% - 0
    As Buyer:
    62.5% - 10
    #7
    Guys, thanks for your interested. Done and assigned to austin-G
    Closed.
     
    nitrogen77, Feb 21, 2009 IP
  8. austin-G

    austin-G Peon

    Messages:
    435
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #8
    Job complete, fast payment, thanks a lot!
     
    austin-G, Feb 21, 2009 IP