为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:0x7000c
【操作系统】:centos7
【CPU】:x86
【问题描述】
03134284132-20240115-215128-20081
DB Version: 0x7000c
DM Database Server 64 V8
CREATE TABLE "ex_departments" (
"id" INT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
"name" VARCHAR(32) NOT NULL,
"parent_id" INT,
"default" BIT DEFAULT FALSE,
"description" VARCHAR(255),
"created_at" DATETIME DEFAULT CURRENT_TIMESTAMP,
"updated_at" DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY ("parent_id") REFERENCES "ex_departments"("id") ON DELETE SET NULL
);
SQL 错误 [22000]: 第10 行附近出现错误:
对象[default]DEFAULT约束表达式无效
支持 ON UPDATE CURRENT_TIMESTAMP 自动更新时间么
ON UPDATE CURRENT_TIMESTAMP
问题新版本改写成 ON UPDATE NOW()
建表语句可以这样改下,看下是否满足您要求:
CREATE TABLE "ex_departments" (
"id" INT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
"name" VARCHAR(32) NOT NULL,
"parent_id" INT,
"default" BIT DEFAULT 0,
"description" VARCHAR(255),
"created_at" DATETIME DEFAULT CURRENT_TIMESTAMP,
"updated_at" DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE NOW(),
FOREIGN KEY ("parent_id") REFERENCES "ex_departments"("id") ON DELETE SET NULL
);
是从其他数据库迁移过来的吗?这语法好像确实不支持哦