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