CODEWITHSUNDEEP
mysqlsqltriggers
alditis
alditis

Reputation: 4817

Result consisted of more than one row

I run two simple queries but MySQL displays an error message and do not understand why.

SELECT:

SELECT proy_obs FROM proy WHERE proy_cod = 'C-12-001';
+-------------+
| proy_obs    |
+-------------+
|             |
+-------------+
1 row in set (0.00 sec)

UPDATE:

UPDATE proy SET proy_obs = 'Test' WHERE proy_cod = 'C-12-001';
ERROR 1172 (42000): Result consisted of more than one row

MySQL version: 

mysql  Ver 14.14 Distrib 5.1.71, for redhat-linux-gnu (x86_64) using readline 5.1

Upvotes: 2

Views: 457

Answers (1)

peterm
peterm

Reputation: 92805

It looks like you have a trigger(s) defined on your table that is causing the problem.

To check it out run

select trigger_name 
  from information_schema.triggers 
 where trigger_schema = schema()
   and event_object_table = 'proy';

Upvotes: 2

Related Questions