JDBC Tutorial #9 : Delete Records from Database

This video exaplains how to remove records from database. DELETE command is used to delete rows from MySQL tables. The Syntax of DELETE command is as follows. DELETE FROM table_name [WHERE Clause] » If WHERE clause is not specified, then all the records will be deleted from the given MySQL table. »You can specify any condition using WHERE clause. »You can delete records in a single table at a time. A new button is added. When clicked, the selected row from the table will be taken. Name of the selected user will be used for delete operation. This tutorial series covers following topics ■ Connecting Java Program to MySQL Database ■ Inserting data into database ■ Fetching data from database ■ Updating an entry in database ■ Deleting an entry from database ■ Creating a table programmatically ■ Using PreparedStatements ■ Display database contents in JTable ■ Calling stored procedures