· 8 years ago · Mar 22, 2018, 02:08 AM
1CREATE TABLE IF NOT EXISTS `table_name` ( 2 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, 3 `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 4 PRIMARY KEY (`id`) 5) ENGINE=InnoDB CHARSET=utf8;