Mysql创建数据库，名称中包含特殊字符 [英] Mysql Create Database with special characters in the name

问题描述

我想创建一个数据库，该数据库的名称中将包含特殊字符.例如， (.，-，_，@，#，$，％，& ;, *)

有人可以提供任何输出吗?

解决方案

我强烈建议您不要使用此类名称创建数据库.但是，如果您绝对必须这样做，则是限制:

• 没有标识符可以包含ASCII NUL(0x00)或值为255的字节.
• 数据库，表和列的名称不应以空格字符结尾.
• 数据库和表名不能包含"/"，"\"，."或文件名中不允许的字符.

要创建数据库，可以执行以下操作:

mysql> create database `really@strange*database$name`;

I want to create a database which name will have special characters in it. for example, (., - , _, @, #, $, %, &, *)

can anyone provide any output on this?

解决方案

I would strongly recommend that you do not create databases with such names. But if you absolutely must, here are the restrictions:

• No identifier can contain ASCII NUL (0x00) or a byte with a value of 255.
• Database, table, and column names should not end with space characters.
• Database and table names cannot contain "/", "\", ".", or characters that are not allowed in file names.

To create a database, you can do the following:

mysql> create database `really@strange*database$name`;

这篇关于Mysql创建数据库，名称中包含特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！