一、基本的查询语句
select子句:select<列名1>,<列名2>,等
from子句:from<表名>;
实际操作:
- 查询出全部列(*)
![cf4c8ac8bd2c5cc3a6f550b7b6a74a46.png](https://i-blog.csdnimg.cn/blog_migrate/4e1f021894baf1feeb66dc99ed5b7b3f.png)
![b33c28f1fcf9dda6091b83637932cdb4.png](https://i-blog.csdnimg.cn/blog_migrate/a3067a20f1e09a16e85cbf96a43e896b.png)
- 设定别名(as)
![de20be206bb8137e81aedd52a28f32f1.png](https://i-blog.csdnimg.cn/blog_migrate/5ad7ae8dc1bdfaf1ebd85b6c7763b791.png)
![43daf32e9be9a9c4b2cc4d884fc89b4d.png](https://i-blog.csdnimg.cn/blog_migrate/25b074e7a5c4f6cba3625e6bdd7547e1.png)
- 删除重复数据(distinct)
![4948ac906002408dde7813f230e3701d.png](https://i-blog.csdnimg.cn/blog_migrate/acbcd1df458cfd125c7b866dcc84593c.png)
![53eef4782d2cefb5f4d69410deff4421.png](https://i-blog.csdnimg.cn/blog_migrate/560336bf29c461a89fe4b17095f027b5.png)
二、指定查询条件:where子句
注意:SQL的运行顺序和书写顺序不一致
- select字句:查询结果,最后运行
- from字句:从哪张表中查找数据,第一步运行
- where字句:查询条件,第二步运行
三、注释和SQL语句注意事项
注释能帮助更好的理解SQL语句,明白想要查询的具体内容,在复杂的查询语句中显得尤为重要
- 单行注释
![8d1ef73e48178d257699fd76dad8db0a.png](https://i-blog.csdnimg.cn/blog_migrate/792cacd021ff3a57e7b7a86d0b855600.png)
- 多行注释
![335dc650423e6e9f98258771cf30c078.png](https://i-blog.csdnimg.cn/blog_migrate/61a1be2d483822a486bcd5c6096047d7.png)
![e5787fcdcc4519aec31b702bcde1ed04.png](https://i-blog.csdnimg.cn/blog_migrate/4138b9a6d52e6d8def66a7fd4133f035.png)
四、运算符
常见的算术运算符: +, -, *, /
![8be5ef404a21c4cdd57e8e91f8c9f3aa.png](https://i-blog.csdnimg.cn/blog_migrate/2276fe7ec2c590f4520d3f7aa1798dad.png)
![d052afeb38b2c3b0c23b2fa45380bb48.png](https://i-blog.csdnimg.cn/blog_migrate/fb15ff48767b2010e9e964dc66cbf10a.png)
常见的比较运算符: =, <>, >=, <=, >, <
![7ed8f50dd841934ffdfb4209fc94bffe.png](https://i-blog.csdnimg.cn/blog_migrate/cc2e4d16012a24dd4dfcc5a58e6b6e0a.png)
![1f00e2c5e5f9216c69668050dc7a3321.png](https://i-blog.csdnimg.cn/blog_migrate/4d0f250a55b434d1c91cd3aa202f0de1.png)
常见的逻辑运算符:not, and, between, or, in
![362f2a945409ce841424d9298ca51d00.png](https://i-blog.csdnimg.cn/blog_migrate/81a03901ddb4420802adeae1f94084ff.png)
![fbb6b85a9422fd3f2cce819f2b43d444.png](https://i-blog.csdnimg.cn/blog_migrate/f5ab9cc6adda95215239920f0cb006fb.png)
![7903c23d28cafa217c9b0e8406a6052f.png](https://i-blog.csdnimg.cn/blog_migrate/eaa0c0cbd263bfebb665a6cdb452adf6.png)
![acb9da57f67c106fc5c99d6891d49a91.png](https://i-blog.csdnimg.cn/blog_migrate/3ebd6c2c84858bc17eda50a2809c3300.png)
![a49a3e708235177b24553bb5a3d4c19f.png](https://i-blog.csdnimg.cn/blog_migrate/bd3570f1f0b820c2d1232e7e73ba98b0.png)
![a4d530ca41af741eb9ce2ac6a5a16899.png](https://i-blog.csdnimg.cn/blog_migrate/e6c9914da4b9b801b456bf9fcba9b28d.png)
![bf02025b86baff845cfda01defb726a9.png](https://i-blog.csdnimg.cn/blog_migrate/286bfbe62c9c6e9aceae24820ade61e0.png)
![d8c9ac618db10eca22fc39242d0b3c9e.png](https://i-blog.csdnimg.cn/blog_migrate/99ae4146663941bdcc99b249a440d836.png)
五、字符串模糊查询:like
- %表示任意字符串
- _1个下划线表示任意一个字符
![9bce86c3f66d61f21b827b5b6f8c9314.png](https://i-blog.csdnimg.cn/blog_migrate/eca8d6f5996eff9fff7105682ca6a92a.png)
![cc7688ddef76d6e0f2d8b3425b994674.png](https://i-blog.csdnimg.cn/blog_migrate/02f393c4652ee8ee1ed3d4a28f752346.png)
![a9ac0a2d6d6d8b9f740a8f7d1ae5e183.png](https://i-blog.csdnimg.cn/blog_migrate/1b3c94d1b75fb19c2c1de73176008f8e.png)
![ea564b55fc2f89352880a6cbc01f7aa6.png](https://i-blog.csdnimg.cn/blog_migrate/8d2d507829201d0836b24c3fdace55fa.png)
![25e7220f190bcddcbabc2a54fe2a6bca.png](https://i-blog.csdnimg.cn/blog_migrate/60f406512e3db3d93466da35e0b3042d.png)
![5b828579a317be45f3f423e7b453ca43.png](https://i-blog.csdnimg.cn/blog_migrate/ef508c6dc08ee5efca4bde0ca05f2dd0.png)
![b93a6dd8565bff17815f2375294207ea.png](https://i-blog.csdnimg.cn/blog_migrate/232986002e68527cf1fde6edc4644e1f.png)
![6a9b1b945e8b5ddff312b12721fccaff.png](https://i-blog.csdnimg.cn/blog_migrate/cf8962008da061e601d3d73a73dcbbd5.png)
六、Sqlzoo练习
![baedc8194c26bbb859dcbb0ed83828ac.png](https://i-blog.csdnimg.cn/blog_migrate/52ac8cf90feb3c86bc5625593b64eb5d.png)
![22d87912ae57f3680a1819ca640ee9c8.png](https://i-blog.csdnimg.cn/blog_migrate/9423ca45a045a7683d95afeb490e0ba1.jpeg)
![d19da8b599cbb2e4ac4b288c49f7efd6.png](https://i-blog.csdnimg.cn/blog_migrate/1c4480cf64617fae20f028ecdfabfdc9.jpeg)
![a7c6d9f7db612e3903849f753797544c.png](https://i-blog.csdnimg.cn/blog_migrate/9974d4a0c1dee908913802a23c82aca6.jpeg)
![4d879461a86d82f204f7243a8b9190ae.png](https://i-blog.csdnimg.cn/blog_migrate/0d9b7f1a50c48f8383c2eaf1b4c14434.jpeg)
![b24e1796bf7c328be3f904a0a9387a2f.png](https://i-blog.csdnimg.cn/blog_migrate/905280dc3c4a3549ca6207a86962fb7b.png)
![ff98f5aa992942c73910d4e3e2471d52.png](https://i-blog.csdnimg.cn/blog_migrate/5e1b45ca423c32927ccefeb7ed62cbd6.jpeg)
![4a71fac965212b2b0c41eb3c5335a8ce.png](https://i-blog.csdnimg.cn/blog_migrate/e63da240bc65c4c6cd27ad5656814aee.jpeg)
![f79d445a77c278208289115328eab98d.png](https://i-blog.csdnimg.cn/blog_migrate/0bf5ff9106e26bedaa1043024b4a4414.png)
![7bcb50da6c12733546fb33149a9527b9.png](https://i-blog.csdnimg.cn/blog_migrate/7c080906ad5e472eb009d1633fd94e67.png)
![32fa9ccc23da0b6e657a03ae0ef64857.png](https://i-blog.csdnimg.cn/blog_migrate/4728a7002a3220338d7f39b94de735f7.jpeg)
![9b9164c05fe0935b2c2e7d4fe920fbae.png](https://i-blog.csdnimg.cn/blog_migrate/1cf96fe76df213887e354b45775de589.jpeg)