Mysql: Select rows from a table that are not in another

by

You need to do the subselect based on a column name, not *.

For example, if you had an id field common to both tables, you could do:

SELECT * FROM Table1 WHERE id NOT IN (SELECT id FROM Table2)

Refer to the MySQL subquery syntax for more examples.

More Related Contents:

  1. How do I specify unique constraint for multiple columns in MySQL?
  2. How to find similar results and sort by similarity?
  3. Create table variable in MySQL
  4. How to import a CSV file into a MySQL table
  5. Maximum number of records in a MySQL database table
  6. MySQL > Table doesn’t exist. But it does (or it should)
  7. Sorting varchar field numerically in MySQL
  8. Mysql order by specific ID values
  9. Which is more efficient: Multiple MySQL tables or one large table?
  10. MySQL: Sort GROUP_CONCAT values
  11. Is there any reason to worry about the column order in a table?
  12. ORDER BY date and time BEFORE GROUP BY name in mysql
  13. updating columns with a sequence number mysql
  14. mysql sorting of version numbers
  15. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  16. is php sort better than mysql “order by”?
  17. mysql custom sort
  18. ORDER BY alphabet first then follow by number
  19. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  20. SQL split values to multiple rows
  21. MySQL error 1064 syntax but everything seems fine
  22. MySQL/MariaDB – order by inside subquery
  23. How to run SQL script in MySQL?
  24. Removing MySQL 5.7 Completely [closed]
  25. How to optimize COUNT(*) performance on InnoDB by using index
  26. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  27. MySQL Stored Procedures not working with SELECT (basic question)
  28. Too many auto increments with ON DUPLICATE KEY UPDATE
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment