[Techtalk] MySQL

[Michelle Murrain]

OK, that seems odd, since from what I know MySQL should actually happily
update all of the rows where idu=9.

Is there an index on this table, or some odd structure?

What happens when you just do a select with 'idu'='9'?

Peace,
Michelle


On Mon, Jul 22, 2013 at 8:22 AM, Tricia Bowen <tricia.bowen at gmail.com>wrote:

> Help! What am I missing here? I'm trying to update my 'usr' table and keep
> getting this error message:
>
>   MySQL Insert Statement:
>
>   UPDATE `indirect`.`usr` SET `username`='smysql', `loginame`='smysql'
> WHERE `idu`='9';
>
>   ERROR 1172: Result consisted of more than one row
>
> There are no other rows in my table with idu = 9.
> --Tricia
> _______________________________________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/techtalk
>



-- 
email: michelle at murrain.net
web: http://murrain.net
twitter: @pearlbear <http://twitter.com/#!/@pearlbear>