Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: Multiple Tables into 1 Table??

    I started learning MySQL about 2 weeks ago and have made HUGE strides in automating tasks at work that should have been outdated as a corporate process eons ago.

    What I want to do now is take price files from my suppliers that are not the same format and put them into 1 table allowing me to consolidate multiple vendors into 1 file as I only care about certain fields and of these fields they will contain the same information for every supplier.

    1 supplier may have the following
    Part Number
    Buy minimums
    Buy Multiples
    Package size

    Another Supplier may have
    Part Number
    Base Qty
    resale 1
    resale 2
    resale 3

    My thoughts on making this happen are
    1) define the fields that will be common and create my table in sql accordingly
    2) run a query on each suppliers price file that will place data in the created table

    If that is so, what would I be doing to the table in my query, updating or appending the results? I ask as the information and quantity of part numbers may vary due to new products or deletions when updated price files are supplied

    Last edited by youngsql; 12-13-12 at 19:49.

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    I usually find having separate staging tables for loading better. Once the data is in the stage tables you can run whatever SQL against them to upload them into your live tables.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

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