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

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

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

writing my own sobel filter convolution - something is wrong
I am trying to keep it very simple, I cant see anything wrong with my logic, could anybody help poin

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

strptime() equivalent for php4 ?!
Greetings!

this is my first post, thank you in advance for your replies.

Well, the ti

Not capturing all the information we require in the form.......
Hi Guys,

I was wondering if you would share some more of your knowledge today, I'm hoping it

array ...
hi
Code: function formatCategories($categories, $parentId)
{
// $navCat stores all child