一、删除的数据库名字中有空格如:空格test
用反单引号将数据库名字包起来即可(反单引号在键盘的左上方,ESC的下方)
mysql> create database ` heh`;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| heh |
| arch4_platform |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> drop database heh;
ERROR 1008 (HY000): Can't drop database 'heh'; database doesn't exist
mysql> drop database ` heh`;
Query OK, 0 rows affected (0.01 sec)
二、
给表中填加字段
alter table 表名 add 列名 DECIMAL(19,0) after 已存在的列名
DECIMAL(19,0)第一个参数表示数字的长度为19,第二个表示小数点在这个长度中的位数,eg:decimal(6,1) -99999.9-999999.9之间
decimal(6,3) 却是 -999.999到9999.999
指定位置时,first是放在第一列,after column是放在指定列的后边
mysql> DESC TEST
-> ;
+-------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| heh | decimal(11,0) | YES | | NULL | |
| c2 | char(2) | YES | | NULL | |
| dddd | char(22) | YES | | NULL | |
| ddd | char(22) | YES | | NULL | |
+-------+---------------+------+-----+---------+-------+
mysql> alter table test
add co3 char(4)
,add co4 char(5) first
,add co6 char(5) after co4;
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test;
+-------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| co4 | char(5) | YES | | NULL | |
| co6 | char(5) | YES | | NULL | |
| heh | decimal(11,0) | YES | | NULL | |
| c2 | char(2) | YES | | NULL | |
| dddd | char(22) | YES | | NULL | |
| ddd | char(22) | YES | | NULL | |
| co3 | char(4) | YES | | NULL | |
+-------+---------------+------+-----+---------+-------+
用反单引号将数据库名字包起来即可(反单引号在键盘的左上方,ESC的下方)
mysql> create database ` heh`;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| heh |
| arch4_platform |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> drop database heh;
ERROR 1008 (HY000): Can't drop database 'heh'; database doesn't exist
mysql> drop database ` heh`;
Query OK, 0 rows affected (0.01 sec)
二、
给表中填加字段
alter table 表名 add 列名 DECIMAL(19,0) after 已存在的列名
DECIMAL(19,0)第一个参数表示数字的长度为19,第二个表示小数点在这个长度中的位数,eg:decimal(6,1) -99999.9-999999.9之间
decimal(6,3) 却是 -999.999到9999.999
指定位置时,first是放在第一列,after column是放在指定列的后边
mysql> DESC TEST
-> ;
+-------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| heh | decimal(11,0) | YES | | NULL | |
| c2 | char(2) | YES | | NULL | |
| dddd | char(22) | YES | | NULL | |
| ddd | char(22) | YES | | NULL | |
+-------+---------------+------+-----+---------+-------+
mysql> alter table test
add co3 char(4)
,add co4 char(5) first
,add co6 char(5) after co4;
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test;
+-------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| co4 | char(5) | YES | | NULL | |
| co6 | char(5) | YES | | NULL | |
| heh | decimal(11,0) | YES | | NULL | |
| c2 | char(2) | YES | | NULL | |
| dddd | char(22) | YES | | NULL | |
| ddd | char(22) | YES | | NULL | |
| co3 | char(4) | YES | | NULL | |
+-------+---------------+------+-----+---------+-------+