Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mrbti
  • Order by date
  1. mrbti

    Compare Two Tables

    Thanks for replt but I'm using LOAD DATA LOCAL INFILE to load data into a table from a .csv file. Not sure if you can alter the data as it goes in with this. The csv file has 1,000,000 rows.
  2. mrbti

    Compare Two Tables

    Auctually that was round the wrong way. Correct SQL query is: SELECT t2.site, t2.rank FROM t2 LEFT OUTER JOIN t1 ON t1.site = t2.site WHERE t1.site IS NULL
  3. mrbti

    Compare Two Tables

    I have this sql query that compares two tables (t1 to t2) and creates a new table with anything that doesn't exist in the 'site' colum of t1: CREATE TABLE newtable SELECT t1.site, t1.rank FROM t1 LEFT OUTER JOIN t2 ON t2.site = t1.site WHERE t2.site IS NULL This works fine but I need...
    • mrbti
    • Thread
    • Replies: 4
    • Forum: MySQL
  4. mrbti

    Compare two large tables?

    Thanks - works great :-)
  5. mrbti

    Compare two large tables?

    I have two tables (table1 & table2) that contain fields ID and SITE. Both tables contain one million (1000000) rows each. I need to compare the SITE field in the tables to find out what data exisits in the second table that does not exist in the first. I have tried the following but because of...
    • mrbti
    • Thread
    • Replies: 2
    • Forum: MySQL

Part and Inventory Search

Back
Top