ctime 為創建時間, mtime 是修改時間預設CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

CREATE TABLE `trades_platform` (
	`id` INT(10) UNSIGNED NULL DEFAULT NULL,
	`type` ENUM('A','B','C') NOT NULL,
	`login` VARCHAR(10) NOT NULL,
	`password` VARCHAR(10) NOT NULL,
	`ctime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`mtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
COMMENT='平台'
ENGINE=InnoDB;
		

我們還可以讓mtime預設為NULL,這樣更節省存儲空間。

	`ctime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`mtime` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,