[Techtalk] MySQL

Tricia Bowen tricia.bowen at gmail.com
Mon Jul 22 17:11:00 UTC 2013


It looks like I could have corrupted my database. I'm rebuilding to see if
the issue disappears :(
--Tricia


On Mon, Jul 22, 2013 at 12:59 PM, Michelle Murrain <michelle at murrain.net>wrote:

> 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>
>


More information about the Techtalk mailing list