[MySQL 4.1] tab text to mySQL and mySQL values update

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • [MySQL 4.1] tab text to mySQL and mySQL values update

    hello
    i have a text file with TAB separation.
    in this file, i have some products with lets say: RefNr. / Name / Option / Amount
    when i open it i see:

    SOURCE:

    RefNr. Name Option Amount
    001 Product 1 Black 2
    001 Product 1 Black 1
    001 Product 1 Black 0
    001 Product 1 Green 1
    001 Product 1 Green 4
    001 Product 1 Green 1
    002 Product 2 Black 3
    002 Product 2 Black 1
    002 Product 2 Black 1
    002 Product 2 Green 2
    002 Product 2 Green 2
    002 Product 2 Green 0

    etc etc

    do you nkow a way to get this instead, after running a script for instance (my question is “how does the script should look like”!):

    RESULT:

    RefNr. Name Option Amount
    001 Product 1 Black 3
    001 Product 1 Green 6
    002 Product 2 Black 5
    002 Product 2 Green 4

    (i could save this text file first to EXCEL if it helps.)

    once i’ve done it, i’ll have in a second step to “compare” this file to a mySQL Database.
    but in the selected DB table, i won’t have exactly the same structure.
    i mean in my text file i’ll have for instance not only RefNr. / Name / Option / Amount but
    RefNr. / Name / Option / Amount / Description / DeliverDate / ImgName
    and in my table in the DB i’ll have:
    RefNr. / Name / Option / Amount / DeliverDate / Info

    i will need to compare the amounts between ‘RESULT’ and my mySQL table, to get the amount which changed updated in my DB table.
    any idea welcome... even if the process is not automated and if i need to do everything manually in phpMyAdmin for instance (i do not even know how to do it in phpMyAdmin!).

    many thanx in advance for any help!

    batchas

  • #2
    hi, welcome on board. You can use the commandline import tool mysqlimport or SQL query LOAD DATA INFILE

    Kommentar

    Lädt...
    X