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