mysql数据库建表失败

问题描述：创建数据表提示失败

---

table DDL

CREATE TABLE `user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL,
    `username` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
    `password` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
    `email` varchar(64) COLLATE utf8mb4_general_ci,
    `gender` tinyint(4) NOT NULL DEFAULT '0',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_username` (`username`) USING BTREE,
    UNIQUE KEY `idx_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

mysql 环境

MySQL Server version

5.5.27

报错信息

[2022-04-16 16:41:00] Connected
dev_db> use dev_db
[2022-04-16 16:41:00] completed in 6 ms
dev_db> CREATE TABLE `user` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `user_id` bigint(20) NOT NULL,
                                `username` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
                                `password` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
                                `email` varchar(64) COLLATE utf8mb4_general_ci,
                                `gender` tinyint(4) NOT NULL DEFAULT '0',
                                `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `idx_username` (`username`) USING BTREE,
                                UNIQUE KEY `idx_user_id` (`user_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
[2022-04-16 16:41:00] [HY000][1293] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
[2022-04-16 16:41:00] [HY000][1293] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

原因分析：

mysql 5.5 只能有一个Timestamp，而我上面的sql语句中出现了两个，所以报错，而只要mysql5.6以上版本就可以了。

---

解决方案：

1、修改其中 一个 列的Timestamp 类型。比如修改为 datatime类型。

2、换一个高版本的mysql，推荐使用docker , 可以拉取不同版本的mysql镜像。