CODEWITHSUNDEEP
mysql
ElChupacabra
ElChupacabra

Reputation: 1091

Strange MySQL error #1242 - Subquery returns more than 1 row

I received that error on query which definately has neither subqueries nor affecting more than one row:

UPDATE sl_requests SET price='55.00' WHERE request_id=5830;

error: #1242 - Subquery returns more than 1 row

request_id is primary key, there is only one row with request_id=5830

I have no idea what's causing the error. Any ideas?

Upvotes: 0

Views: 101

Answers (1)

ElChupacabra
ElChupacabra

Reputation: 1091

As @Strawberry pointed out the problem was with trigger. There was a subquery in trigger which caused issue.

Upvotes: 1

Related Questions