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

Question

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

Answer 1

提供应该是搞错语法了，mysql的数据库创建语法应该如下

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_option] ...
 
create_option: [DEFAULT] {
    CHARACTER SET [=] charset_name
  | COLLATE [=] collation_name
  | ENCRYPTION [=] {'Y' | 'N'}
}