1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| SELECT * FROM student;
SELECT id,stuName FROM student;
SELECT id AS '学号',stuName AS '姓名' FROM student AS s;
SELECT id AS '学号',stuName AS '姓名', 'Java班' AS '班级' FROM student;
SELECT id,stuName,(chinese+math+english) AS '总成绩' FROM student;
SELECT DISTINCT gender FROM student; SELECT DISTINCT(gender) FROM student; SELECT DISTINCT gender,stuName FROM student;
SELECT * FROM student WHERE stuName = '张三' AND id = 6; SELECT * FROM student WHERE stuName = '张三' OR id = 5;
SELECT * FROM student WHERE chinese > 70; SELECT * FROM student WHERE chinese > 70 AND english > 90; SELECT * FROM student WHERE chinese BETWEEN 85 AND 100;
SELECT * FROM student WHERE english IS NULL; SELECT * FROM student WHERE stuName = '';
SELECT * FROM student WHERE stuName LIKE '张%'; SELECT * FROM student WHERE stuName LIKE '张_'; SELECT * FROM student WHERE stuName LIKE '%张%';
SELECT SUM(english) AS '全班英语总成绩' FROM student; SELECT AVG(english) AS '全班英语平均成绩' FROM student; SELECT COUNT(id) AS '总数' FROM student; SELECT COUNT(english) AS '参加英语考试人数' FROM student;
SELECT * FROM student LIMIT 0,2; SELECT * FROM student LIMIT 2,2; SELECT * FROM student LIMIT 4,2;
SELECT * FROM student ORDER BY id; SELECT * FROM student ORDER BY id ASC; SELECT * FROM student ORDER BY id DESC;
SELECT * FROM student ORDER BY chinese DESC; SELECT * FROM student ORDER BY chinese DESC,math DESC,english DESC;
SELECT gender,COUNT(*) FROM student GROUP BY gender; SELECT gender,COUNT(*) FROM student GROUP BY gender HAVING COUNT(*) > 3;
SELECT * FROM city WHERE NAME REGEXP '^A';
INSERT INTO student(id,stuName,chinese,english,math) VALUES(6,'郭靖',89,78,90); INSERT INTO student(id,stuName,chinese,english,math) VALUES(7,'杨康',67,53,95); INSERT INTO student(id,stuName,chinese,english,math) VALUES(8,'黄药师',87,78,77); INSERT INTO student(id,stuName,chinese,english,math) VALUES(9,'老顽童',88,98,92); INSERT INTO student(id,stuName,chinese,english,math) VALUES(10,'段玉',82,84,67); INSERT INTO student(id,stuName,chinese,english,math) VALUES(11,'段王爷',55,85,45); INSERT INTO student(id,stuName,chinese,english,math) VALUES(12,'黄蓉',75,65,30);
|