• Post Reply Bookmark Topic Watch Topic
  • New Topic

My Update Query Could not Run

 
sarathd kumar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi...

When I am trying to Update my Database Table It could not be updated..

Update Query is:

UPDATE stock_sales SET balance='0.0',payment='90.0',due='2014-09-08' where transactionid=' SD263'

When i run this query Previous Values Does not Change.

But,MySQL Says Like,

(0 row(s)affected)
(0 ms taken)

Any One Help me Please...

Thanks to All..
 
Dave Tolls
Ranch Hand
Posts: 2373
25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's a leading space in your transactionid, does that id exist in your stock_sales table?
 
sarathd kumar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks For Your Valuable Reply Mr.Dave

I Find What is the Problem on it is

Is it Single space near by the transactionid so that it does not updated.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!