0

hi.I have created a table named stu_info.Here present 3 column named id,name,dept.here id is primary key and every column is varchar.Now i typed the following query

Update stu_info set id='0904009' and name='mr. x' and dept='CSE' where id='0904199' and name='mr. y' and      dept='CSE';

But it made the id=0 instead of 0904009.What is wrong in my query?

2
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by shihab2555
1
Update stu_info 
  set id='0904009', name='mr. x', dept='CSE' 
  where id='0904199' and name='mr. y' and dept='CSE';
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.