File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "SQL statement to Delete a row" Watch "SQL statement to Delete a row" New topic
Author

SQL statement to Delete a row

Ransika deSilva
Ranch Hand

Joined: Feb 18, 2003
Posts: 524
Hello,
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.
Thanks


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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30752
    
156

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
F A H A D
Greenhorn

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


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
Sheriff

Joined: Dec 10, 2001
Posts: 7023
I like to refer to http://www.sqlcourse.com for such basic SQL syntax questions.


[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL statement to Delete a row