I've tried searching on this, and really didn't find anything that helped. I've also read the mySQL manual on JOINs...
I have a database called 'hands'. In that database I currently have 2 tables, 'roster' and 'rostertmp'. The information in these tables is aquire via an xml document which populates the fields. The information in table 'roster' is the main data, and 'rostertmp' is the up-to-date (new) data (taken from the same xml document).
Firstly, the only really unique identifier in the two tables is the 'name' field. The information in the xml document is sorted via 'level', 'rank', and then 'name'. So the 'rostertmp' and 'roster' ID fields will not always line up if new data is added. This is for a guild roster database.
I wish to do a comparision with the data in 'rostertmp' 'level' field, to the data in 'roster' 'level' to see if there is a change, using the 'name' field as a unique identifier. If there is a change, I want the fields 'name' and 'level' dumped to a different table which I will call 'levelup' for now, and I want the 'level' to be updated in 'roster'.
I also would like any new entries which do not exist in 'roster' to be put into a new table called 'newmembers' and also appended to the 'roster' table. 🙂
Basically, I will be running a job nightly to do this, and have it displayed on our guild website. I want to be able to display anyone who has leveled in the last day, and also display new members to the guild in the last day.
I've been playing around, searching all over the web to try and aquire an answer to this, and so far I haven't come up with much.
Any help would be greatly appreciated.
Thanks
