What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL - Compare 2 tables

MySQL - Compare 2 tables
Author: Message:
matty
Scripting Guru
*****


Posts: 8336
Reputation: 109
39 / Male / Flag
Joined: Dec 2002
Status: Away
RE: MySQL - Compare 2 tables
Really crappy way of doing it... not sure if it works but give it a shot.
SQL code:
SELECT * FROM upgrades A
    INNER JOIN upgrades_backup B ON B.steamid = A.steamid
WHERE (
    A.playerupgrade1 > CAST ( B.playerupgrade1 + 10 AS INT )
    OR A.playerupgrade2 > CAST ( B.playerupgrade2 + 10 AS INT )
    OR A.playerupgrade3 > CAST ( B.playerupgrade3 + 10 AS INT )
    OR A.playerupgrade4 > CAST ( B.playerupgrade4 + 10 AS INT )
    )


This post was edited on 10-08-2009 at 02:18 PM by matty.
10-08-2009 02:18 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
MySQL - Compare 2 tables - by Jimbo on 10-08-2009 at 01:55 PM
RE: MySQL - by matty on 10-08-2009 at 01:58 PM
RE: MySQL - by Jimbo on 10-08-2009 at 01:59 PM
RE: MySQL - Compare 2 tables - by matty on 10-08-2009 at 02:18 PM
RE: MySQL - Compare 2 tables - by Jimbo on 10-08-2009 at 02:19 PM
RE: MySQL - Compare 2 tables - by matty on 10-08-2009 at 03:02 PM
RE: RE: MySQL - Compare 2 tables - by CookieRevised on 10-08-2009 at 07:21 PM
RE: MySQL - Compare 2 tables - by Jimbo on 10-08-2009 at 03:19 PM
RE: MySQL - Compare 2 tables - by Jimbo on 10-08-2009 at 07:57 PM
RE: MySQL - Compare 2 tables - by matty on 10-08-2009 at 08:09 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On