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

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

Scrolling news bar and MySQL
I am not sure if this is the correct forum to post this on. If not, I apologize. I am still pretty

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

Lack of simpleXML Documentation
What is up with this.

Look at: http://www.php.net/manual/en/function.simplexml-load-file.php<