Create Table - zhamri/MyClass-MySQL GitHub Wiki

CREATE TABLE `test_student`
(
    `matrik_no`   varchar(20) NOT NULL,
    `std_name`    varchar(45) DEFAULT NULL,
    `Address`     varchar(45) DEFAULT NULL,
    `date_create` TIMESTAMP   DEFAULT CURRENT_TIMESTAMP,
    `date_update` TIMESTAMP   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`matrik_no`)
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1;