Hi All,

please see the following

UPDATE Employee
SET
salary = round(salary ,0),
incentive = round(incentive,0),
bonus = round(bonus,0),
expense = round(expense ,0)
where
empid = 23

When i am executing the above query it shows like following?

0 row(s) affected

0 row(s) affected


If i am giving more than two columns in the update statement then I am getting like above
why it is so? Is there anything wrong with my query?
Please help me out.

Thanks in advance.

Can you check this and let me know if you see any records existing for empid = 23

Cheers!

_________________________
- Vijay G
Strive for Perfection

select * from Employee where empid = 23
returns 0 rows, (Is this the reason why I am getting that message?)
but I may have to update when the empid exists.

Yes, you don't have any records with empid=23, so you are trying to update values of a non-exisiting records, that is why you see 0 rows affected.

You can check other records for empid's value and try updating that.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks for the information Vijay.
Is it the same reason why i am seeing 0 row(s) affected TWICE like following when I execute the above update query with no records exisits in DB?

0 row(s) affected

0 row(s) affected

Thanks bunch

But I am not sure, why you are seeing it TWICE. You should be seeing that only once., though record does not exist that satisfying your WHERE clause, unless you are executing any other statements along with UPDATE as a batch

Cheers!

_________________________
- Vijay G
Strive for Perfection

Dear Paul_T , Vijay is right you can only update those record which are already exists in the data base


:)

cheers




Love 4 all

Hi Paul_T,

Actually you should be seeing The command(s) completed successfully. when you try to update rows that really don't satisfy the criteria in WHERE clause.

Cheers!

_________________________
- Vijay G
Strive for Perfection