mysql一共多少兆_为何 mysql安装文件只有几十兆 而sql server

MYSQL 5.5 顺利通过 .

create table t1 ( id int ,atypeid varchar(20), btypeid varchar(20) ) ;

insert into t1 (id, atypeid, btypeid) values (1,'a','c');

insert into t1 (id, atypeid, btypeid) values (2,'a','c');

insert into t1 (id, atypeid, btypeid) values (3,'b','c');

insert into t1 (id, atypeid, btypeid) values (4,'b','c');

insert into t1 (id, atypeid, btypeid) values (5,'b','d');

-- insert into t1 (id, atypeid, btypeid) values (6,'c','d');

create table t2 (typeid varchar(20), name varchar(20) );

insert into t2(typeid, name) values ('a','xxx');

insert into t2(typeid, name) values ('b','yyy');

insert into t2(typeid, name) values ('c','zzzz');

insert into t2(typeid, name) values ('d','rrr');

create view v_test

as

select t1.id,t2.name as atypename,t3.name as btypename

from t1 left join t2 on t1.atypeid=t2.typeid

left join t2 t3 on t1.btypeid=t3.typeid

mysql> select * from v_test;

+------+-----------+-----------+

| id | atypename | btypename |

+------+-----------+-----------+

| 1 | xxx | zzzz |

| 2 | xxx | zzzz |

| 3 | yyy | zzzz |

| 4 | yyy | zzzz |

| 5 | yyy | rrr |

+------+-----------+-----------+

5 rows in set (0.00 sec)

取消

评论