aspose 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 Java 8 in Action this week in the Java 8 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29275
    
140

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
 
Similar Threads
SQL statment to Delete a row
delete sql not working
Delete succeed but return 0
SQLException error: "Invalid Cursor position"
stmt.executeUpdate() and stmt.executeUpdate() != 1