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

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

Changes to hosting company's server has affected web contact form
I started a thread a couple of months ago about the contact forms on my client's website. Basically

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

how to read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.




Thank u inadva

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca