摘要:
-- 查询时合并列 只针对数值类型字段-- 查询每个同学三门课总成绩-- 数值类型之间可以进行+—%*SELECT sname,html+css+js AS 总成绩 FROM score; SELECT sname,js FROM score WHERE js>=60;-- 查询js成绩及格同学姓名 阅读全文
摘要:
INSERT INTO student VALUES(1,'蔺斐','男','2002-04-09',0.25);INSERT INTO student VALUES(2,'熊大','男','1999-08-08',100);INSERT INTO student VALUES(3,'吉吉国王',' 阅读全文