MySQL Syntax error message “Operand should contain 1 column(s)”

by

Try removing the parenthesis from the SELECT clause. From Microsoft TechNet, the correct syntax for an INSERT statement using a SELECT clause is the following.

INSERT INTO MyTable  (PriKey, Description)
       SELECT ForeignKey, Description
       FROM SomeView

The error you’re getting, “The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay.”, is actually correct, assuming you have many rows in both BOOK and temp_cheques. You are trying to query all rows from both tables and make a cross-reference, resulting in an m*n size query. SQL Server is trying to warn you of this, before performing a potentially long operation.

Set SQL_BIG_SELECTS = 1 before running this statement, and try again. It should work, but note that this operation may take a long time.

More Related Contents:

  1. Operand Should Contain 1 Column – MySQL NOT IN
  2. MySQL – Operand should contain 1 column(s)
  3. MySQL error 1241: Operand should contain 1 column(s)
  4. SQL split values to multiple rows
  5. Find duplicate records in MySQL
  6. How do I escape reserved words used as column names? MySQL/Create Table
  7. How to store multiple options in a single table?
  8. How to populate a table with a range of dates?
  9. MySQL order by before group by
  10. What is the opposite of GROUP_CONCAT in MySQL?
  11. How to Perform an UPSERT so that I can use both new and old values in update part
  12. brew install mysql on macOS
  13. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  14. MySQL ON DUPLICATE KEY – last insert id?
  15. MySQL pagination without double-querying?
  16. How do I select an entire row which has the largest ID in the table?
  17. MySQL error 1064 syntax but everything seems fine
  18. MySQL/MariaDB – order by inside subquery
  19. How to run SQL script in MySQL?
  20. My MySQL trigger doesn’t work, simple syntax, not complicated
  21. Sort by order of values in a select statement “in” clause in mysql
  22. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  23. Removing MySQL 5.7 Completely [closed]
  24. How to optimize COUNT(*) performance on InnoDB by using index
  25. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  26. MySQL INT meaning
  27. MySQL Stored Procedures not working with SELECT (basic question)
  28. ERROR 1148: The used command is not allowed with this MySQL version
  29. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  30. Too many auto increments with ON DUPLICATE KEY UPDATE

Leave a Comment