qq_32283145
子渊丶
2021-02-28 19:57

一直提示ON后面有语法错误,怎么改都不好使

CREATE DATABASE StudentDB 
on PRIMARY
(
name='StudentDB',
filename='D\data1\StudentDB.mdf',
size=3mb,
maxsize=unlimited,
filegrowth=1mb
)
(
name='StuDB1',
filename='D\data1\StuDB1.ndf',
size=3mb,
maxsize=unlimited,
filegrowth=1mb
)
(
name='StuDB2',
filename='D\data1\StuDB2.ndf',
size=3mb,
maxsize=unlimited,
filegrowth=1mb
)
log on
(
name='StudentDB_log',
filename='D\data1\StudentDB_log.ldf',
size=1mb,
maxsize=1gb,
filegrowth=10%
) 

报错如下 

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 'on PRIMARY
(
name='StudentDB',
filename='D\data1\StudentDB.mdf',
size=3mb,
' at line 1
> 时间: 0s
  运行环境是 Navicat for mysql 15

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

为你推荐