New Topic/Question
Reply
Here is how I am doing it now:
Resultset rs = statement.executeQuery("select max(id) from TableMain");
rs.next();
int myMaxId = rs.getInt(1);
//my insert sql is here to insert into another table the value of the max id (myMaxId) ....
1 Replies - 6546 Views - Last Post: 11 October 2007 - 08:32 PM
Rate Topic:
#1
kensington
- New D.I.C Head
Reputation: 0
- Posts: 39
- Joined: 08-October 07
Max id from Database table
Posted 11 October 2007 - 06:18 PM
What is the best way to get the max id from a database table?
Here is how I am doing it now:
Here is how I am doing it now:
Is This A Good Question/Topic?
0
MultiQuoteReplies To: Max id from Database table
#2
Liontrue1
- D.I.C Addict
-
Reputation: 48
- Posts: 811
- Joined: 20-May 06
Re: Max id from Database table
Posted 11 October 2007 - 08:32 PM
kensington, on 11 Oct, 2007 - 09:18 PM, said:
What is the best way to get the max id from a database table?
Here is how I am doing it now:
Here is how I am doing it now:
Resultset rs = statement.executeQuery("select max(id) from TableMain");
rs.next();
int myMaxId = rs.getInt(1);
//my insert sql is here to insert into another table the value of the max id (myMaxId) ....
Hi there, it seems that the above code is correct Your myMaxId variable now contains the max id. Are you getting problems with that code?
Was This Post Helpful?
0
Page 1 of 1
| 