mysql times,mysql timesstamp数据类型

i have question about mysql.

i have created the table on employee and attribute is

create table employee(

eid varchar(10),

name varchar (20),

work_start_time timestamp, -- problem1

work_end_time timestamp);--problem2

this table is creation is ok.and can data insert into local host.but if i insert into the online server there is some problem.online server os is linux cent os and apache server. it is mention no way to create 2 colum timestamp data type colum in same table.

give me the solution plz

解决方案You simply cannot have two or more TIMESTAMP columns in the same table. This is a restriction of MySQL. Instead of TIMESTAMP use DATETIME.

Good luck!