I am using MySQL 5.0.22 and am trying to make multiple timestamps. One for when the record is inserted and one for when the record is updated.
Here is my structure:
create table requests (
id int not null primary key auto_increment,
employee varchar(50) not null,
category varchar(50) not null,
priority varchar(10) not null,
description text not null,
status varchar(10) not null default 'Open',
submitted timestamp not null default current_timestamp,
completed timestamp not null default current_timestamp,
technician varchar(50) not null
Here is the error:
ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP
column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Is there any way to accomplish this? I tried reading the reference manual on this and I thought I was doing it right but I guess not. Thanks!