Update changes values I want kept

[scf1984]

I have a table I create using:

CREATE TABLE  `biuproj`.`quiz_taken` (
  `quizid` int(10) unsigned NOT NULL,
  `studentid` int(10) unsigned NOT NULL,
  `starttime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `endtime` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`quizid`,`studentid`)
);
 

I then add the values (2,111222,NOW(),0) to it.

At the end I would like to change the `endtime` field to view the current time (after some time has elapsed, meaning starttime and endtime will be different).
However, when I run the query:
update quiz_taken SET endtime=NOW() where quizid=2 and studentid=111222

It also changet the starttime to view the new time...

What am I doing wrong?

[r035198x]

Why do you have

on update CURRENT_TIMESTAMP

on it's definition and what do you think it does?

[scf1984]

Well, I'm using MySQL Query Browser, which added that thing automatically.

I changed the CREATE statement to:

CREATE TABLE  `biuproj`.`quiz_taken` (
  `quizid` int(10) unsigned NOT NULL,
  `studentid` int(10) unsigned NOT NULL,
  `starttime` timestamp NOT NULL default '0000-00-00 00:00:00',
  `endtime` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`quizid`,`studentid`)
);

And it works fine now.
Thanks! :D

[Atli]

scf1984,

Please use [code] tags when posting your code examples.

Thanks you
MODERATOR