Deleting row and column from a tablePosted on: May 31, 2010 at 12:00 AM

Advertisement

In this program ,we delete row and column of a table.

Deleting row and column from a
table

In this program ,we delete row and column of a table. First we create
connection to a database using connection interface and java driver. After it we
can delete row using "delete " keyword and also can delete column using "Alter"
table commands SQL.

For this example, we are using a database named as "cellular" of mysql--

cellular(Before deletion)--

In this table we will delete,id having minimum value and we will also delete
column "name".