摘要:
insert into student (name,cid,gender,age,score)values('tom',1,1,20,80.0): update table1 set field1=value1 where 范围 select name from student where dele 阅读全文
摘要:
1、IN 关键字 SECLET * FROM SCORES WHERE gno IN (SECLET gno FROM games WHERE gtype=’棋牌‘) 注意:子查询一般不写成SECLET *FROM.... 2、EXISTS关键字 SECLET * FROM SCORES WHERE 阅读全文
摘要:
多表查询:(多张表中数据集合到一张表中) SELECT USER_NAME AS '昵称‘,GNAME AS '游戏名称’,SCORE AS '分数‘ FROM USERS,GAMES,SCORES WHERE USERS.USER_QQ=SCORES.USER_QQ AND GAMES.GNO=S 阅读全文