[Techtalk] MySQL

[Chantal Rosmuller]

On 07/22/2013 05:22 PM, Tricia Bowen 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
Are you sure? What is the output of

select * from `indirect`.`usr` WHERE `idu`='9';