mysql 创建表_习惯累积沉淀_新浪博客

CREATE TABLE SCSJ_SGE_AU9999 (

    ID INT(20) NOT NULL AUTO_INCREMENT,

    CODE VARCHAR(100) NOT NULL,

    FIELD_GROUP VARCHAR(50) NOT NULL,

    FIELD_VALUES VARCHAR(2000) NOT NULL,

    TIME_IN_LOCAL TIMESTAMP(6) NOT NULL,

    TIME_IN_GMT TIMESTAMP(6) NOT NULL,

    SOURCE_FROM VARCHAR(50) NOT NULL,

    CREATED_BY VARCHAR(50) NOT NULL,

    CREATED_TIME TIMESTAMP(6) not null  default CURRENT_TIMESTAMP(6),

    UPDATED_BY VARCHAR(50),

    UPDATED_TIME TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) ,

    PRIMARY KEY (ID)

);

自动放进去时间.

和,update时候自动放进去时间