Adsense
Popular Posts
- MySQL workbench -"Could not decrypt password cache"
- Transfer modules between sites
- Install APXS in Redhat Linux
- super(props) in React
- Set Windows path command line
- MySQL date created and date modified
- JavaScript, remove trailing insignificant zeros after toFixed function
- React: connect(mapStateToProps, mapDispatchToProps)
- MySQLcase When Then END in comparison
- PHP function for input sanitizing
Wednesday, August 20, 2014
Compare difference in two MySQL tables
I have two same MySQL tables courses_offered and courses_offered_temp, courses_offered_id
is the primary key, Now I want to compare difference in these two MySQL tables
SELECT courses_offered_temp.courses_offered_id FROM courses_offered_temp WHERE courses_offered_temp.courses_offered_id NOT IN(SELECT courses_offered.courses_offered_id FROM courses_offered)
Labels:
MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment