[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