MySQL - Operand should contain 1 column s

Question

While working on a system I m creating  I attempted to use the following query in my project   SELECT topics id  topics name  topics post count  topics view count  COUNT  posts solved post   AS solved post   SELECT users username AS posted by      users id AS posted by id     FROM users     WHERE users id   posts posted by  FROM topics LEFT OUTER JOIN posts ON posts topic id   topics id WHERE topics cat id    cat GROUP BY topics id     cat  is bound by my PHP code as I m using PDO  2 is a valid value for   cat    That query though gives me an error    1241 - Operand should contain 1 column s    What stumps me is that I would think that this query would work no problem  Selecting columns  then selecting two more from another table  and continuing on from there  I just can t figure out what the problem is   Is there a simple fix to this  or another way to write my query

User · Answer

I got this error while executing a MySQL script in an Intellij console, because of adding brackets in the wrong place:

WRONG:

SELECT user.id
FROM user
WHERE id IN (:ids); # Do not put brackets around list argument

RIGHT:

SELECT user.id
FROM user
WHERE id IN :ids; # No brackets is correct

User · Answer

In my case  the problem was that I sorrounded my columns selection with parenthesis by mistake  SELECT  p column1  p colum2  p column3  FROM table1 p where p column1   1   And has to be  SELECT p column1  p colum2  p column3 FROM table1 p where p column1   1   Sounds silly  but it was causing this error and it took some time to figure it out

User · Answer

This error can also occur if you accidentally use   instead of IN in the WHERE clause   FOR EXAMPLE   WHERE product id    1 2 3

User · Answer

This error can also occur if you accidentally miss if function name   for example   set v filter value   100   select     f id      f sale value from     t seller where     f id   5     and  v filter value  lt  gt  0  f sale value   v filter value  true     Got this problem when I missed putting if in the if function

User · Answer

This error can also occur if you accidentally use commas instead of AND in the ON clause of a JOIN   JOIN joined table ON  joined table column   table column  joined table column2   table column2                                                                                                         should be AND  not a comma

User · Answer

SELECT users username AS posted by  users id AS posted by id FROM users WHERE users id   posts posted by    Here you using sub-query but this sub-query must return only one column  Separate it otherwise it will shows error

User · Answer

Your subquery is selecting two columns  while you are using it to project one column  as part of the outer SELECT clause    You can only select one column from such a query in this context   Consider joining to the users table instead  this will give you more flexibility when selecting what columns you want from users   SELECT topics id  topics name  topics post count  topics view count  COUNT  posts solved post   AS solved post  users username AS posted by  users id AS posted by id  FROM topics  LEFT OUTER JOIN posts ON posts topic id   topics id LEFT OUTER JOIN users ON users id   posts posted by  WHERE topics cat id    cat GROUP BY topics id

User · Answer

COUNT  posts solved post   AS solved post   SELECT users username AS posted by      users id AS posted by id     FROM users     WHERE users id   posts posted by    Well  you can   t get multiple columns from one subquery like that  Luckily  the second column is already posts posted by  So   SELECT topics id  topics name  topics post count  topics view count  posts posted by COUNT  posts solved post   AS solved post   SELECT users username AS posted by username     FROM users     WHERE users id   posts posted by

User · Answer

Another place this error can happen in is assigning a value that has a comma outside of a string   For example   SET totalvalue    IFNULL i subtotal 0    IFNULL i tax 0  0

[mysql] MySQL - Operand should contain 1 column(s)

Examples related to mysql

Examples related to sql

Examples related to mysql-error-1241