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

str_replace help
I am thinking str_replace is my only option to filter outputs from my database to convert them to sa

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

read integers that returns a negative or prints the average
Im trying to finish this homework assignment by tommarow afternoon and I keep getting stuck.
Wr

Big O & time complexity ???
can you help me how to calculate the Big O & time complexity for any algorithm and c++ program pleas

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

PHP and Javascript
Hello Everyone,

I have a page that needs a javascript code to be written between PHP code but

Newb advice
Hi all,

I'm a flash front end designer and I've taken on a project that needs some back end p

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from