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

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

Not Loading Function Into Div
I'm not sure whether to put this under the php forum or ajax forum but because I tink it's more of a

division gives infinity anser
int main()
{
int z=0;
int i=1/z;
cout<
}

It doesn't throw a

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

please help
HTML Code:

Code: <span id="ctl00"><span>

Strange HTML Tag?
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a

sendmail code suddenly not working
Hi Guys, I maintain 3 sites (including my own) I use the following code from a french webmaster that