Tukukkk

I'm using Mysql Workbench 8.0.12, I have a table (tblproduction) with three columns:

idProduction INT PK AI

dateProduction DATETIME

statusProduction VARCHAR(15)

When I try to change the value of the column statusProduction for example, from 'queue' to 'done' as the query below (SELECT, INSERT AND DELETE querys are OK):

UPDATE tblproduction 

SET statusProduction = 'done'

WHERE idProduction=1;

The system returns "Error Code: 1241. Operand should contain 1 column(s)."
I've done some research and found out that this error code is related to syntax errors, but I didn't find any problem on my query.

If I try to do something like this:

UPDATE tblproduction 

SET statusProduction = 'done'

WHERE idProduction='a';

The system actually run the query although 0 rows were affected, but it gave me the same error message if I try this instead:

UPDATE tblproduction 

SET statusProduction = 'done'

WHERE idProduction='1';

I really don't know what is wrong, and I know it's a silly question but if anyone could help me.

 please try using this method :      

 I have created a table and inserted the record like this :

                select * from tblproduction;

                +--------------+---------------------+------------------+

                | idProduction | dateProduction      | statusProduction |

                +--------------+---------------------+------------------+

                |            1 | 2018-11-19 08:22:11 | queue            |

                +--------------+---------------------+------------------+



            use update query :

            UPDATE `test`.`tblproduction` SET `statusProduction` = 'done' WHERE `tblproduction`.`idProduction` =1;



            got result :

            --------------+---------------------+------------------+

            | idProduction | dateProduction      | statusProduction |

            +--------------+---------------------+------------------+

            |            1 | 2018-11-19 08:22:11 | done             |

            +--------------+---------------------+------------------+

I am unable to reproduce your problem, see https://rextester.com/OQI5184

#MySQL 5.7.12

#'\' is a delimiter



DROP TABLE IF EXISTS tblProduction;



CREATE TABLE IF NOT EXISTS tblProduction (

    idProduction INT NOT NULL AUTO_INCREMENT

    , dateProduction DATETIME NOT NULL

    , statusProduction VARCHAR(15) NOT NULL

    , PRIMARY KEY (idProduction)

    ) 

;    





INSERT INTO tblProduction(dateProduction,statusProduction) VALUES ('2018-11-20','start');



SELECT * FROM tblProduction;



UPDATE tblproduction 

SET statusProduction = 'done'

WHERE idProduction=1;



SELECT * FROM tblProduction;

RESULTS:

+---+--------------+---------------------+------------------+

|   | idProduction |   dateProduction    | statusProduction |

+---+--------------+---------------------+------------------+

| 1 |            1 | 20.11.2018 00:00:00 | start            |

+---+--------------+---------------------+------------------+



+---+--------------+---------------------+------------------+

|   | idProduction |   dateProduction    | statusProduction |

+---+--------------+---------------------+------------------+

| 1 |            1 | 20.11.2018 00:00:00 | done             |

+---+--------------+---------------------+------------------+

So the problem wasn't neither the query nor the table, there was an update trigger on this table (witch I dropped for testing and didn't work), to sum up I had to drop the database and created it all once again without creating the trigger. This time the update query worked, I'm working on the trigger now to see if I can find what's wrong