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

a very simple php header question (sorry!)
Firstly...I do apologise if this annoys anyone....a header error

I'm do not know php &

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

default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?

Problem with umlauts and UTF-8
Hello every1,

I'm creating my own little CMS at the moment and got some problems with the cha

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

Php Mysql Page Loading Notice
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo