Hi Shekhar, I have answered this question here: http://groups.google.com/group/jooq-user/browse_thread/thread/4b43fd7f23e3b7f2
Cheers Lukas 2011/3/25 Shekhar <[email protected]> > I have a mysql table "GAME" with structure as > > CREATE TABLE GAME( > "GAME_ID" VARCHAR(20) PRIMARY KEY, > "GAME_START" TIMESTAMP, > "GAME_END" TIMESTAMP, > "PLAY_TIME" DECIMAL(20,0) > ) > > I am not able to perform 2 tasks > > Now at the time of new record, i want GAME_ID to auto populate to > the max+1 i.e MAX(GAME_ID)+1 or COUNT(GAME_ID)+1 . > > > Also, i am creating the new record at first and then updating the > record at a later stage when the GAME is completed. At that time, i am > updating GAME_END TIMESTAMP. Is there anyway, i can also update the > PLAY_TIME = GAME_START-GAME_END (in seconds)-- > > Ravi.Shekhar > -------------------------------------------- >
