This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Data Update Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Data Update" Watch "Data Update" New topic

Data Update

Ekrem Altintas

Joined: Dec 20, 2005
Posts: 14
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

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

Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
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:
subject: Data Update
It's not a secret anymore!