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

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

题主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

https://blog.csdn.net/weixin_42115513/article/details/115851527

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632