How to update row in SQL if exist in the table

Question

0.00/5 (No votes)

See more:

CSS

Id  CategoryId  Category    Type    Description Mapped
61068   463 Cat1    Maximum Benefit Benefit : 100rs   1,2,3
61068   464 Cat2    Deductible      Deductible : 50rs   4,5
61068   464 Cat2    Maximum Benefit Benefit : 100rs  1,2,3
61068   465 Cat3    Maximum Benefit Benefit : 100rs  6,7
61068   464 Cat2    Maximum Benefit Benefit : 100rs 1,2,3

I have the above table and i have to update the same table with new modification
i need to write the query to get the below reult.

CSS

Id  CategoryId  Category    Type    Description Mapped
61068   463 Cat1    Maximum Benefit Benefit : 100rs 1,2,3
61068   464 Cat2    Deductible  Deductible : 50rs   4,5
61068   464 Cat2    Same as Cat1    Benefit : 100rs 1,2,3
61068   465 Cat3    Maximum Benefit Benefit : 100rs 6,7
61068   464 Cat2    Same as Cat1    Benefit : 100rs 1,2,3

need your help to update the same table to get the record updated.

Posted 25-Apr-13 0:02am

sawant parag

Add a Solution

Comments

StianSandberg 25-Apr-13 6:04am

the two tables are identical?

sawant parag 25-Apr-13 6:14am

first table the original table , i have . i want to read each row of the first table and update the table and make that table as the second table

StianSandberg 25-Apr-13 6:16am

why would you do that if the data is the same?

sawant parag 25-Apr-13 6:19am

ok ! i will create new table of the same column and insert into them, please let me know the solution whatever you feel fesible.

2 solutions

Solution 1

This is the absolute basics of sql. Please check out the link below and have a try. This isn't really a question because it seems you haven't tried anything yet.

http://www.w3schools.com/sql/sql_update.asp[^]

Good luck!

Posted 25-Apr-13 0:04am

E.F. Nijboer

Comments

sawant parag 25-Apr-13 6:29am

both are same table Nijboer , first table is the Existing table, i have to make it as in the second table.
Simple to explain:
i have one table with some records , it that records i have some cell value same , i have updat that cell with the other value.

E.F. Nijboer 25-Apr-13 7:11am

Then select into that new table.
http://www.w3schools.com/sql/sql_select_into.asp

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sawant parag · Accepted Answer · 2013-04-25T20:57:00

E.F. Nijboer you didint understand the question sir :) . yhnaks for your support and help.

As their is no primary key in this table it was difficult to solve by simple update statment.
I took the Distict from the first table and used while loop to irrearte the temp table of distinct .

In while loop i took the each and every ID and solved it to update it

thanks friends :) for your valuable inputs :)