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 --------------------------------------------
