DEV Community

Sk
Sk

Posted on

setgrsg

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;
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4cdm1po62bw7zo3idvje.jpg

Alt Text)

Top comments (0)