• 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: 2112
16
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic