rhce 第22题 数据库查询

1.先进入Contact数据库
show tables;
desc name;
desc pass;
select * from name join pass where name.aid=pass.bid;
这样就把两个表结合在一起了
select * from name join pass where name.aid=pass.bid and password='tangerine';
考试的的时候，可以把考题切换到英文版看看，看看到底是first name还是last name
如果是first name那就填写mary ,是last name的话填写wang
老师说应该是first name ，这是个填空题。
desc name;
desc loc;
show tables;
select * from name join loc where name.aid=loc.cid;
select * from name join loc where name.aid=loc.cid and first name='John' and loction='Santa Clara';
select count(*) from name join loc where name.aid=loc.cid and first name='John' and loction='Santa Clara'; 选择题
quit

转载于:https://blog.51cto.com/11009105/2137246