Trying to perform MINUS operation in MySQL

MySql does not recognise MINUS and INTERSECT, these are Oracle based operations. In MySql a user can use NOT IN as MINUS (other solutions are also there, but I liked it lot). Example:

select a.id 
from table1 as a 
where <condition> 
AND a.id NOT IN (select b.id 
                 from table2 as b 
                 where <condition>);

Related Posts:

  1. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  2. String concatenation in MySQL
  3. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  4. MySQL server startup error ‘The server quit without updating PID file’
  5. How do I restore a dump file from mysqldump?
  6. Not unique table/alias
  7. Install mysql-python (Windows)
  8. SQL – Update multiple records in one query
  9. Create a new database with MySQL Workbench
  10. Column ‘user_id’ in field list is ambiguous
  11. Database sharding vs partitioning
  12. 1052: Column ‘id’ in field list is ambiguous
  13. Escape string Python for MySQL
  14. 1052: Column ‘id’ in field list is ambiguous
  15. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  16. SQL ZOO List each continent and the name of the country that comes first alphabetically
  17. How can I prevent SQL injection in PHP?
  18. Best way to store an array in MySQL database?
  19. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  20. MySQL date formats – difficulty Inserting a date
  21. mysqld: Can’t change dir to data. Server doesn’t start
  22. How to grant remote access permissions to mysql server for user?
  23. How to check if mysql database exists
  24. #1062 – Duplicate entry for key ‘PRIMARY’
  25. How can I convert a string to a float in mysql?
  26. Is there a Profiler equivalent for MySql?
  27. Can you do a For Each Row loop using MySQL?
  28. How to use greater than operator with date?
  29. How to properly create composite primary keys – MYSQL
  30. How to replace the domain name in a WordPress database?
  31. Optimize WordPress Query that take 5 seconds to execute
  32. MySQL Replication Latency Issues in wp-admin pages
  33. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  34. Increment value (value = value+1) of $wpdb->update
  35. How can I debug my database connection for unit testing?
  36. Extending the database
  37. SQL query not working in alphabetical post title/content search
  38. WordPress Deadlock Error
  39. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  40. How to do a MySQL dump from production site without using a search and replace script for local development?
  41. Importing MariaDB into Mysql in WordPress
  42. Concurrent / simultaneous MySQL connections
  43. How to check for empty and not a failure
  44. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  45. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  46. Converting mysql to $wpdb
  47. Update a WordPress post or page takes 60+ seconds
  48. add_post_meta does not respect the content
  49. Modify MySQL Query Based on Dropdown Menu
  50. Select multiple wp_postmeta keys with single select
  51. Backing up and restoring multiple sites efficiently
  52. $wpdb select all meta for each post
  53. Alter wp_post table vs. post_meta performance/speed
  54. Replacing link URL ending strings via MySQL
  55. Problem with admin login after deployment
  56. Are these WordPress tables safe to add indexes to?
  57. SQL syntax error when getting data for a url
  58. How to stop $wpdb from prepending database name
  59. Import CSV to MySQL, with custom registration field information
  60. Locally restoring a ManageWP full site backup
  61. WordPress doesn’t save changes some times
  62. Update Custom Post Type Taxonomies with SQL
  63. Best approach for a custom database filling in WP custom post types
  64. Custom SELECT Query not returning the_title and the_permalink
  65. Will reducing mysql permissions hinder WP function? [duplicate]
  66. Php Mysql Terms
  67. Export SQL query based on custom field?
  68. Lock wait timeout exceeded; try restarting transaction
  69. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  70. 504 Gateway Time-out after custom plugin inserts data into mysql database
  71. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  72. What is this? MySQL array?
  73. update multiple rows in mysqli table base on two values
  74. What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
  75. How can I verify WordPress nonce from the following code?
  76. Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
  77. Add row to SQL array
  78. SELECT statement wrong?
  79. mysql query on wp_user and user_meta problem
  80. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  81. Use custom query if main search query returns zero results in wordpress
  82. get_results() query not working only when entering strings
  83. Geographical proximity query using post_meta
  84. What is the cron doing?
  85. Can I use mysql queries to replace query_posts()?
  86. Add value to array in database
  87. SQL error on restoring database
  88. MySQL database gives blank page (white screen of death)
  89. How to Import Multiple Values in custom field
  90. Making CURDATE() recognize current_time()
  91. why is $wpdb->update() causing a DB error from within wp_set_password()
  92. How should I troubleshoot a database serialization issue with a WordPress migration
  93. How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
  94. Global MySQL replacing of text patterns/matches
  95. SQL – Pull products of particular category from a remote WordPress woocommerce db
  96. Efficiently loop over huge number of posts
  97. Using queries in and i see 7000+queries?
  98. Need SQL query to find&replace image URL
  99. Postgres equivalent to MySQL’s \G?
  100. How to check what port mysql is running on

Leave a Comment