Hi. I am fairly new to PHP/MySQL. I am trying to build an HTML/PHP
phone database that receives a daily text flat file from a remote
system with the fields employID, first, last, jobtitle, deptname, and
phonenum. I currently know how to populate a table with "load data infile"
but what I would like to do is be able to find the differences
between data from the current day and the previous day. In other
words, sowmehow to compare two tables to find what employee records
are new from the current day, and what records are missing from the
previous day data. An Oracle DBA I know mentioned something
about joining two tables and using a WHERE EXISTS clause (although
I did not see that in the MySQL Delete/Select/Insert Usage). Help!
Thanks
phone database that receives a daily text flat file from a remote
system with the fields employID, first, last, jobtitle, deptname, and
phonenum. I currently know how to populate a table with "load data infile"
but what I would like to do is be able to find the differences
between data from the current day and the previous day. In other
words, sowmehow to compare two tables to find what employee records
are new from the current day, and what records are missing from the
previous day data. An Oracle DBA I know mentioned something
about joining two tables and using a WHERE EXISTS clause (although
I did not see that in the MySQL Delete/Select/Insert Usage). Help!
Thanks