On 5/16/2012 6:42 AM, Ananda Kumar wrote:
> why are not using any where condition in the update statment
WHERE clauses are not required. Performing a command without one will
affect ever row on the table.
> On Wed, May 16, 2012 at 1:24 PM, GF<ganfab@stripped> wrote:
>> Good morning,
>> I have an application where the user ids were stored lowercase.
>> Some batch import, in the user table some users stored a uppercase
>> id, and for some applicative logic, in other tables that have a
>> foreign key to the user table, their user ids are stored lowercase.
>> Have you any idea how to solve this situation without
>> stopping/recreating the DB? (it's a production environment)
Have you tried ?
If that does not work, you would need to first un-create your Foreign
Key relationships, update your key values (the USER_ID fields), then
re-create your Foreign Key relationships.
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN