MySQL subquery returns more than one row

by

If you get error:error no 1242 Subquery returns more than one row, try to put ANY before your subquery. Eg:

This query return error:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

This is good query:

SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2);

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL dump by query
  8. MySQL’s now() +1 day
  9. Delete sql rows where IDs do not have a match from another table
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Can you access the auto increment value in MySQL within one statement?
  13. Which SQL query is better, MATCH AGAINST or LIKE?
  14. What does DELIMITER // do in a Trigger?
  15. MySQL equivalent of DECODE function in Oracle
  16. How do you version your database schema? [closed]
  17. MySQL, Get users rank
  18. Mysql: how to select groups having certain values?
  19. How to create a multi-tenant database with shared table structures?
  20. MySQL #1140 – Mixing of GROUP columns
  21. How to fill date gaps in MySQL?
  22. MySQL: GROUP_CONCAT with LEFT JOIN
  23. Boolean vs tinyint(1) for boolean values in MySQL
  24. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  25. Function for week of the month in mysql
  26. Find rows that have the same value on a column in MySQL
  27. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  28. I want to copy table contained from one database and insert onto another database table
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment