[Techtalk] MySQL

[Tricia Bowen]

Yeh... I'm pretty sure it's user error. I recreated the database and ran my
insert and update statements and I'm not seeing the error any more.
--Tricia


On Mon, Jul 22, 2013 at 1:14 PM, Chantal Rosmuller <chantal at antenna.nl>wrote:

> 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<http://mailman.linuxchix.org/mailman/listinfo/techtalk>
>>
> Are you sure? What is the output of
>
> select * from `indirect`.`usr` WHERE `idu`='9';
>
>
> ______________________________**_________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://mailman.linuxchix.org/**mailman/listinfo/techtalk<http://mailman.linuxchix.org/mailman/listinfo/techtalk>
>