Hello!
I'm using a javaBean to connect to Mysql.
I have got a table "tider" where I have a uniqe column called "key". I want to have the column indexed like 1,2,3,4,5 so I guess that I should use:
Statement selectStatement = con.createStatement();
String query = "SELECT COUNT(*) FROM tider";
ResultSet rs = selectStatement.executeQuery(query);

while (rs.next()) {

}

rs.close();
selectStatement.close();
con.close();
So I check the current numbers of rows and then add with one to get the uniqe index.

But how do I get the index? should I use rs.get(Something)() or?

Thanks for helping me! // D_S

String query = "SELECT COUNT(*) as NumRecords FROM tider";
ResultSet rs = selectStatement.executeQuery(query);

if (rs.next()) {
int iNumRecords = rs.getInt("NumRecords");
}

rs.close();
selectStatement.close();

thats the way i do it anyway!

Thank you very much!