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

Page doesn't expand for content
Hi. I've been testing a query I made. It's here http://lapr1.6te.net/inquerito.php
The page doesn

Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story sh

images aren't rendering
I'm trying to call a JPG file from within PHP (in an effort to hide the actual JPG folder). The imag

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and