This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I want to update all the datas of one of the column of a table in my SQL database. I am using cpanel tool to manage/keep a track of my database.I exported the data in an excel sheet/CVS and have already modified it .How do I import the sheet back into that table such that it updates just that column. I have to manage my site.Kindly let me know asap.
I want to update my column say(phone-number) for all the cusomers.How can i change all the phone numbers by running just one query.So I exported it in the form of an excel/cvs sheet & then easily modified the column & now how do i import it back so that just that column is modified.
Originally posted by sunita shaw: So now I want to update Sale column by 5% so there is a query to do that. Kindly let me know as I am getting error with this one:
UPDATE table Product SET Sale = ((Sale * 5)/100);
Remove the word "table". This is really an SQL question, that doesn't have anything to do with Java or JDBC. You'd better ask this to an SQL expert instead of on a Java forum.
Your SQL statement is going to set the value of column Sale to 5% of the original value, for all rows. Is that really what you want? Or did you want to increase the Sale values by 5% (i.e., set the value to 105% of the original value)?
UPDATE Product SET Sale = ((Sale * 105)/100); [ December 01, 2005: Message edited by: Jesper de Jong ]