Re: MySQL for Excel - feature to allow table row deletion from Excel ?

[Marion Gordon]

Hay

Insert new rows - users can insert a new row through a light-yellow colored row at the end of the existing data; when the users type or paste any data in it, that row is flagged for insertion.
Delete existing rows - users can delete existing rows the same way they would delete a row in MS Excel, the row is deleted from the worksheet and flagged for deletion.

you have like to delete the row from the excel in MySQL database means use the following way to achieve it

// Delete row
rs.absolute(2);
rs.deleteRow();
rs.beforeFirst();
System.out
.println("---------Student Information(After deletion a row)----------");
while (rs.next()) {
int roll = rs.getInt("s_Roll");
String Name = rs.getString("s_Name");
String Address = rs.getString("s_Address");
System.out.println(roll + " " + Name + " " + Address);
}