摘要:
a) SELECT * FROM video WHERE vid=35 结果: b) SELECT user.* FROM user JOIN post ON user.uid = post.uid WHERE post.vid = 35 结果: c) SELECT count(*) FROM wa 阅读全文
摘要:
SELECT commodity.name,onsell.status,onsell.rem_amount,AVG(orders.buyerrate),COUNT(*) FROM onsell JOIN orders ON onsell.cid = orders.cid AND onsell.sid 阅读全文
摘要:
a) SELECT People.pid,People.name,City.name FROM People JOIN City ON People.cid = City.cid WHERE People.pid = 1 结果: b) SELECT vaccine.name,count(*) FRO 阅读全文
摘要:
CREATE VIEW user_friend AS SELECT u2.uid, u2.nickname, f1.note, f1.type FROM user u1 JOIN friend f1 ON u1.uid = f1.uid1 JOIN user u2 ON u2.uid = f1.ui 阅读全文