mysql一些基本题跟mysql连接

最新推荐文章于 2024-07-25 11:05:57 发布

Lord_zang

最新推荐文章于 2024-07-25 11:05:57 发布

阅读量121

点赞数

本文链接：https://blog.csdn.net/Lord_zang/article/details/101025910

版权

#查询年龄为50，性别为女的记录
SELECT * FROM stu1 WHERE gender=‘女’ AND age=50;
#查询学号为S_1001，或者姓名为liSi的记录
SELECT * FROM stu1 WHERE sname=‘hualili’ OR sid=1;
#查询学号为S_1001，S_1002，S_1003的记录
SELECT * FROM stu1 WHERE sid IN (1,2,3);
#查询学号不是S_1001，S_1002，S_1003的记录
SELECT * FROM stu1 WHERE sid NOT IN(1,2,3);
#查询年龄为null的记录
SELECT * FROM stu1 WHERE age IS NULL;
#查询年龄在20到40之间的学生记录
SELECT * FROM stu1 WHERE age>=20 AND age<=40;
#查询性别非男的学生记录
SELECT * FROM stu1 WHERE gender!= ‘男’;
#查询姓名不为null的学生记录
SELECT * FROM stu1 WHERE sname IS NOT NULL;
#like方法
SELECT * FROM stu1 WHERE sname LIKE ‘w%’;
SELECT * FROM stu1 WHERE sname LIKE ‘%w%’;

#sid 为1 的同学的成绩和姓名
SELECT score,NAME FROM score JOIN student WHERE score.sid=student.id AND sid=1;
SELECT c.score AS c,s.name AS s FROM score c,student s WHERE c.sid=s.id AND sid=1;

SELECT * FROM score LEFT JOIN student ON score.sid=student.id ;

SELECT * FROM student LEFT JOIN score ON score.sid=student.id ;

内连接 2边都有数据才会输出多少个数据
左连接主要看你左边的数据有的话就输出右边没有这个数据就显示null

mysql也是有基础的学习了一点接下来学习前端的东西比如一个简单 html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>w</title>
</head>
<body>
<table width="100%">
    <tr>
        <td>
            <img src="../img/logo2.png" height="50px" >
        </td>
        <td>
            <img src="../img/header.jpg" height="50px">
        </td>
        <td>
            <a href="#" target="_top">登入</a>
            <a href="#" target="_top">注册</a>
            <a href="#" target="_top" >注册</a>
        </td>
    </tr>

            <table width="100%"  bgcolor="black"  >
                <tr>
                    <td style="text-align: center"><font color="white" size="2px">首页</font></td>
                    <td style="text-align: center"><font color="white" size="2px">首页</font></td>
                    <td style="text-align: center"><font color="white" size="2px">首页</font></td>
                    <td style="text-align: center"><font color="white" size="2px">首页</font></td>
                    <td style="text-align: center"><font color="white" size="2px">首页</font></td>
                </tr>
            </table>
    <tr>
        <img src="../img/1.jpg" width="100%">
    </tr>



</table>

</body>
</html>