my dog learned polymorphism*
The moose likes Java in General and the fly likes SQL statement to Delete a row Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "SQL statement to Delete a row" Watch "SQL statement to Delete a row" New topic

SQL statement to Delete a row

Ransika deSilva
Ranch Hand

Joined: Feb 18, 2003
Posts: 524
Could you please tell me how to delete a row in a database.
I am asking for the SQl statement. for example "INSERt INTO" for inserting values.

SCJP 1.4, SCMAD 1.0<br />SCWCD, SCBCD (in progress)
Ransika deSilva
Ranch Hand

Joined: Feb 18, 2003
Posts: 524
Sorry for Posting this question in the wrong forum.
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

So you have an answer when this thread is moved:

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2

Joined: Aug 16, 2003
Posts: 13
weel the SQL statement is here....
"DELETE FROM table_name WHERE field_name = value"
DELETE FROM employee WHERE emp_id= 'E123';

no GOD except ALLAH...
Ron Newman
Ranch Hand

Joined: Jun 06, 2002
Posts: 1056
And in the future, please post SQL questions to the JDBC forum.

Ron Newman - SCJP 1.2 (100%, 7 August 2002)
Dirk Schreckmann

Joined: Dec 10, 2001
Posts: 7023
I like to refer to for such basic SQL syntax questions.

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
I agree. Here's the link:
subject: SQL statement to Delete a row
Similar Threads
SQLException error: "Invalid Cursor position"
delete sql not working
stmt.executeUpdate() and stmt.executeUpdate() != 1
SQL statment to Delete a row
Delete succeed but return 0