小葱拌豆腐
SELECT * FROM student;
SELECT * FROM student WHERE studentName='大凡';
SELECTstudentNo,studentName,address FROM student
WHERE studentNo=1009;
SELECTstudentNo AS 编号,studentName AS 姓名,
address AS 住址 FROM student
WHERE studentNo=1009;
SELECTstudentNo编号,studentName姓名,
address住址 FROM student
WHERE studentNo=1009;
SELECT * FROM student,grade;
SELECT * FROM student,grade
WHERE student.gradeid=grade.gradeid
SELECTDISTINCT studentNo,studentResult
FROMresult
WHERE studentResult BETWEEN 85 AND 95;
SELECT studentName FROM student
WHEREstudentNo IN
(SELECT DISTINCT studentNo FROM result
WHERE studentResult BETWEEN 85 AND 95);
UPDATE result SET studentResult=80
WHERE studentNo=1000;
SELECT studentName,address
FROM student
WHERE address!='';
SELECT studentName,address
FROM student
WHERE address='';
SELECT studentName,address
FROM student
WHERE address IS NULL;
SELECT studentName,address
FROM student
WHERE address IS NOT NULL;
SELECT * FROM student
WHERE studentName='李东方' OR studentName='刘奋斗'
SELECT * FROM student
WHERE
studentName='李东方' OR studentName='刘奋斗'
OR studentName='json';
SELECT * FROM student
WHEREstudentName IN
('李东方','json','刘奋斗');
SELECT * FROM student
WHEREstudentName LIKE '李_'
SELECT * FROM student
WHEREstudentName LIKE '李%'
SELECT * FROM student
WHEREstudentName LIKE '%才'
SELECT * FROM student
WHEREstudentName LIKE '%才%'
页:
[1]