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

Displaying image pathname instead of image
Hello

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

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

upload photo limits
ive got a upload photo script and im just trying to make more secure currently it limits size and as

Print 'a' to 'z' via for loop
A very simple problem..
How Can I print a to z NOT a to y ?
It is a part of a code where
<

Multiple upload and Resize
I would like some help on my script I have the for my index.php

////

<html&

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

Uploading/Downloading files stored in MySQL database
Hey all,

This problem just came up in my website and I'm having a hard time figuring out what

How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php


Thanks in advance

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h