MySQL Forums
Forum List  »  MySQL for Excel

Re: MySQL for Excel - feature to allow table row deletion from Excel ?
Posted by: Marion Gordon
Date: August 23, 2014 12:24AM

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);
}

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.