ResultSet moveToInsertRow, insertRow, and the statement query

Vote count: 0

if I want to update a table using .moveToInsertRow() and .insertRow(); does the actual content of the ResultSet matter?

i'm assuming that as long as the statement executes a query that references the correct table the item will be inserted?

if that's true, is there any benefit performance wise to this

SELECT first_column FROM table WHERE id = 1;

or one that returns an empty ResultSet, rather than a select statement that returns everything?

thanks

asked 2 mins ago

NickW

Let's block ads! (Why?)

ResultSet moveToInsertRow, insertRow, and the statement query