This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Data Update Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Data Update" Watch "Data Update" New topic
Author

Data Update

Ekrem Altintas
Greenhorn

Joined: Dec 20, 2005
Posts: 14
posted private message
0
Quote
Hello I want to update records on DB.I wrote this statements but when I execute the program, records on the sayi column become 0.Is UPDATE satement wrong?
Akin Demir
Greenhorn

Joined: Jul 08, 2005
Posts: 9
posted private message
0
Quote
cumle.executeUpdate("Update kelimeler set sayi="+artir);

-Akin
Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
posted
0
Quote
Do you realize that an UPDATE statement without a WHERE clause will update all records in the table?

There is no emoticon for what I am feeling!
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Data Update
 
Similar Threads
Date / Time problems
Data Insert Problem
Fetching Data From Database
If Statement&Equals
Search Problem