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

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

PHP page loading in Firefox but not in IE
hello,

i am currently doing a project in PHP and i have a problem. If I view the project in M

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my

matching numbers inside ( )
I know I can match numbers by just [0-9]+, so I thought matching numbers inside ( ) would be somethi

Sequencing or queuing parallel process
Scenario is as follows
There is one parent process say P1 and 4 child processes say A B C D

Reg Ex
Im trying to search for the string: srv_9 (Dead ???)

I thought to use preg_match, however I d