CREATE TABLE employee
(
id
int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
emp_name
varchar(70) NOT NULL,
gender
varchar(10) NOT NULL,
date_of_join
date NOT NULL,
email
varchar(80) NOT NULL,
timestamp
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
