Update data to upper case in parent/child tables

Posted on 16th Feb 2014 07:03 pm by admin

Hi Gurus!

In production we have a product table and which is being reference by many tables making it parent child relationship. By mistake, we realized that last month some product were added in lower case and now we got a request to update all these product codes to upper case so that the existing code that use these tables have no impact. Appreciate if you can give some idea on how can I update the existing data in the parent table to upper case along with the child records?

Regards

Your Answer:

Login to answer

Other forums

Login script (probably a simple error)
dbConfig.php
Code: <?
// Replace the variable values below
// with your specific dat

Code Review - SQL and Insertion Attacks (Warning: Not for Newbs)
Hey guys,

Its been a while, I know. Use to love coming here to answer peoples questions, but

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

Email Processor
I have a few questions so this post will be a larger one! Sorry, but I'm a bit of a PHP newbie so be

Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

parsing error
can anyone explain this syntax error:

Parse error: syntax error, unexpected T_IF

The e

Forms Authentication and Refresh at Login page
Hello, When I try to press the Login button in my webapplication at my login.aspx page nothing h