dotnetcore / dotnetcore/osharp
mysql 数据迁移 datetime(6) 出错
- Dominant language
- C#
- Stars
- 2.8k
- Forks
- 763
- PR merge metrics
- No merged PRs in 30d
Description
执行 update -database 出错 :
Failed executing DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
```
CREATE TABLE `AuditOperation` (
`Id` char(36) NOT NULL,
`FunctionName` longtext NULL,
`UserId` longtext NULL,
`UserName` longtext NULL,
`NickName` longtext NULL,
`Ip` longtext NULL,
`OperationSystem` longtext NULL,
`Browser` longtext NULL,
`UserAgent` longtext NULL,
`ResultType` int NOT NULL,
`Message` longtext NULL,
`Elapsed` int NOT NULL,
`CreatedTime` datetime(6) NOT NULL,
CONSTRAINT `PK_AuditOperation` PRIMARY KEY (`Id`)
);
```
> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
CONSTRAINT `PK_AuditOperation` PRIMARY KEY (`Id`)
)' at line 14
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.