mysql[Err] 1064 问题
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[activity]') AND type IN ('U'))
DROP TABLE [dbo].[activity]
GO
CREATE TABLE [dbo].[activity] (
[id] bigint primary key IDENTITY(1,1) NOT NULL,
[name] varchar(25) NOT NULL,
[dept] varchar(25) NOT NULL,
[post] varchar(25) NOT NULL,
[mobile] varchar(25) NOT NULL DEFAULT '',
[mail] varchar(128) NOT NULL DEFAULT '',
[articleId] bigint NOT NULL,
[userId] bigint NOT NULL,
[userName] varchar(64) NOT NULL DEFAULT '',
[createdTime] datetime NULL DEFAULT NULL
)
ON [PRIMARY]
GO
异常:
[Err] 1064 - 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 'IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[act' at line 1
最新回答
寂月灭影
2025-06-27 00:18:48
private static final int BIZTHREADSIZE = 100;
private static final EventLoopGroup bossGroup = new NioEventLoopGroup(BIZGROUPSIZE);
private static final EventLoopGroup workerGroup = new NioEventLoopGroup(BIZTHREADSIZE);
热门标签
