Skip to content
Advertisement

SQL error ‘ER_OPERAND_COLUMNS: Operand should contain 1 column(s)’ for DELETE function

Trying to delete rows that exist in both temp_abstract table and abstract table.

When I just run what’s inside the parentheses it returns what I want, but adding a delete from where seems to throw this error. Any help?

Advertisement

Answer

You can use EXISTS instead :

Sub-query will return only one expression while using IN OR NOT IN.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement