mysql中创建带小数点的数据库名、表名、列名

来源：互联网发布：stm8单片机gpio引脚编辑：程序博客网时间：2024/05/17 05:59

mysql> create database gw.1;
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 '.1' at line 1

mysql> create database `gw.1`;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| gw |
| gw.1 |
| mysql |
| performance_schema |
| test |
+--------------------+
6 rows in set (0.00 sec)

mysql> create table gg.1(id int);
ERROR 1049 (42000): Unknown database 'gg'
mysql> create table `gg.1`(id int);
Query OK, 0 rows affected (0.06 sec)

mysql> show tables;
+----------------+
| Tables_in_gw.1 |
+----------------+
| gg.1 |
+----------------+
1 row in set (0.00 sec)

mysql> create table `gg.2`(id.1 int);
ERROR 1103 (42000): Incorrect table name 'id'
mysql> create table `gg.2`(`id.1` int);
Query OK, 0 rows affected (0.07 sec)

mysql> desc `gg.2`;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id.1 | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)

1 0