my sql update problem in primary key

Question

0.00/5 (No votes)

See more:

C#

MySQL

im trying to update and existing record by set value1=@value1 where value1 = value1
but its not working

Posted 7-Oct-12 23:18pm

mrDivan

Add a Solution

Comments

Mohd. Mukhtar 8-Oct-12 5:23am

Are you want to update primary key value?

mrDivan 8-Oct-12 5:38am

yes it is an column that holds the primary key values i am trying to update that value

vivektiwari97701 8-Oct-12 5:28am

set value1=@value1 where value1 = @value1

3 solutions

Add a Solution

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

Mohd. Mukhtar · Answer 1 · 2012-10-07T23:50:00

If you are updating primary key then you need to make sure that no duplicate value should be inserted.

The other problem can be with the relationship if you are refering from any table to this table then you need to update that table first then you can update this table.

Check both the senario.

For the second senario, Either you can delete all the child rows or update child row.

If this not resolve you problem, Please copy the error what you getting while update.

JayeshTharani · Answer 2 · 2012-10-08T00:18:00

Solution 3

You cannot update Identity Column Value.

Posted 8-Oct-12 0:18am

JayeshTharani

solanki.net · Answer 3 · 2012-10-07T23:23:00

Solution 1

that is not proper question can u explain it ?

Posted 7-Oct-12 23:23pm

solanki.net

Comments

CPallini 8-Oct-12 5:50am

That is not a proper answer, could you explain it, please?
:-)

my sql update problem in primary key

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

my sql update problem in primary key

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us