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?

Did you know?Explore Trending and Topic pages for more stories like this.
Regards
No comments posted yet

Your Answer:

Login to answer
170 Like 44 Dislike
Previous forums Next forums
Other forums

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

is this the proper use of mysql_real_escape_string() to prevent sql injections?
i was wondering is this the proper use of mysql_real_escape_string() to prevent sql injections? any

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

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

////

<html&

how to get values from $_Post with onchange="form.submit();"?
Hi, I have a form that submit to itself with a file upload field and two other hidden field values.<

MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash