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;

Top comments (0)