sql create database on 出错

[lvyunlei123]

CREATE DATABASE lvyunlei
ON PRIMARY
(
NAME = Crosssqlone,
FILENAME = 'c:/temp/CrossGQL_dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH= 5
)

LOG ON
(
NAME = CrossSQL_log1,
FILENAME = 'c:/temp/CrossGQL_log1.ldf',
SIZE = 5,
MAXSIZE = 25,
FILEGROWTH = 5
)



错误代码： 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 'ON PRIMARY
(
NAME = Crosssqlone,
FILENAME = 'c:/temp/CrossGQL_dat.mdf',
SIZE' at line 2

[SQL77]

MYSQL 不是MSSQL的语法了 CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name

[lvyunlei123]

引用 1 楼 SQL77 的回复:

MYSQL 不是MSSQL的语法了 CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name

MySQL有文件组这个概念吗

[SQL77]

引用 2 楼 u011618637 的回复:

[quote=引用 1 楼 SQL77 的回复:] MYSQL 不是MSSQL的语法了 CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name

MySQL有文件组这个概念吗[/quote] 貌似没有，就一个日志和一个数据文件。在INNODB的话。

[Neo_whl]

目测没有语法错误，除非你不是在sql中运行的

[發糞塗牆]

你到底想用mysql还是sqlserver？

[sftjun]

CREATE DATABASE lvyunlei
ON -- PRIMARY 这儿不要这个，你把primary去掉就可以了
(
NAME = Crosssqlone,
FILENAME = 'c:/temp/CrossGQL_dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH= 5
)

LOG ON
(
NAME = CrossSQL_log1,
FILENAME = 'c:/temp/CrossGQL_log1.ldf',
SIZE = 5,
MAXSIZE = 25,
FILEGROWTH = 5
)

[卖水果的net]

版块是 MSSQL 的，语法是 MSSQL 的，错误信息是 MySQL的。