Adsense
Popular Posts
- Install APXS in Redhat Linux
- MySQL workbench -"Could not decrypt password cache"
- Transfer modules between sites
- JavaScript, remove trailing insignificant zeros after toFixed function
- Set Windows path command line
- datatable order by nunmeric
- MySQL date created and date modified
- super(props) in React
- PHP, dump varailbes in a format way
- React: connect(mapStateToProps, mapDispatchToProps)
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