MySql为什么总是说on primary附近语法错误

Question

mysql> create database 旅游管理

-> on primary
-> (
-> name='旅游管理_primary',
-> filename='e:\旅游管理_pri.mdf',
-> size=10MB,
-> filegrowth=10MB
-> )
-> log on
-> (
-> name='旅游管理_log',
-> filename='e:\旅游管理.ldf',
-> size=5MB,
-> filegrowth=5MB
-> )
-> ;

ERROR 1064 (42000): 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='旅游管理_primary',
filename='e:\旅游管理_pri.mdf',
si' at line 2

Answer 1

题主mysql和mssqlserver创建数据库的语法搞混了。这个语法是mssqlserver的。。mysql语法如下

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_option] ...

create_option: [DEFAULT] {
    CHARACTER SET [=] charset_name
  | COLLATE [=] collation_name
  | ENCRYPTION [=] {'Y' | 'N'}
}

具体题主可以参考官网的文档

MySQL :: MySQL 8.0 Reference Manual :: 13.1.12 CREATE DATABASE Statement https://dev.mysql.com/doc/refman/8.0/en/create-database.html