ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [原创] Mysql中 Desc tables 中MUl解释

[原创] Mysql中 Desc tables 中MUl解释

原创 Linux操作系统 作者:yxyup 时间:2009-02-05 13:34:59 0 删除 编辑

---官方的说明
Key is MUL, multiple occurrences of a given value are allowed within the column. The column is the first column of a non-unique index or a unique-valued index that can contain NULL values.

---自己的测试

mysql> create table t_mul(id int,key1 int,name char(8));
Query OK, 0 rows affected (0.13 sec)
mysql>
mysql> desc t_mul;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
| key1  | int(11) | YES  |     | NULL    |       |
| name  | char(8) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql>
mysql>
mysql> insert into t_mul values(1,1,'a');
Query OK, 1 row affected (0.01 sec)

mysql> insert into t_mul values(2,1,'a');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> desc t_mul;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
| key1  | int(11) | YES  |     | NULL    |       |
| name  | char(8) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql>
mysql> create index i_001 on t_mul(key1,id);
Query OK, 2 rows affected (0.03 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql>
mysql> desc t_mul;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
| key1  | int(11) | YES  | MUL | NULL    |       |
| name  | char(8) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7364032/viewspace-545350/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DBA的性格 (zt)
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1325796