MySQL基础教程——查询数据
SQL数据库开发
共 1685字,需浏览 4分钟
· 2020-09-16
点击上方SQL数据库开发,关注获取SQL视频教程
SQL专栏
SELECT column_name1,column_name2 FROM table_name [WHERE clause] [LIMIT N][ OFFSET M]
![](https://filescdn.proginn.com/61715b2db89e31ef5b75a29946925a02/fcc180671553229751865b98ac0579d9.webp)
SELECT `姓名` FROM customers
![](https://filescdn.proginn.com/8033b69a906feb61dfa14bfba45b487a/7efd3793ae1eee5a8ac060814e1a9cf0.webp)
SELECT `姓名`,`地址` FROM customers
![](https://filescdn.proginn.com/468639df79be201d515fd0d2ecfa1f51/a5dfa6f3b824b74b8935b358f436910e.webp)
SELECT * FROM customers;
![](https://filescdn.proginn.com/61715b2db89e31ef5b75a29946925a02/fcc180671553229751865b98ac0579d9.webp)
SELECT DISTINCT 城市 FROM customers;
![](https://filescdn.proginn.com/c750cb70d2039d00d6504c5a44f41324/b143b42a7ef77498691cf396a16ae1f4.webp)
SELECT DISTINCT 城市,邮编 FROM customers;
![](https://filescdn.proginn.com/f9f8d5a1aa1f5a5f7e993447961963f7/7425de33aa3dd0b7eb40e8f3de25bae7.webp)
SELECT DISTINCT 客户ID,城市 FROM customers;
![](https://filescdn.proginn.com/6d577c1ce93d0a37f16d43989a0e66d1/47dc7ccec4ca1c044dbbd295001197c0.webp)
SELECT * FROM customers LIMIT 3;
![](https://filescdn.proginn.com/5804b1e061e09e392bf297f2857a2121/6859cbedcc8d9ee6ae4cba59947f0d41.webp)
SELECT * FROM customers LIMIT 3,3;
![](https://filescdn.proginn.com/2e1cadf090a1168bcd45d49edddc25af/3aca047c4ecd4fe41ccdb9318613c279.webp)
SELECT customers.`客户ID`,orders.`客户ID`
FROM customers,orders
where customers.`客户ID`=orders.`客户ID`
![](https://filescdn.proginn.com/8795695d16b6262bea8473a7fd382ae6/5c7fc7e9b19bb6a72fd1dbc7711aceb6.webp)
——End——
后台回复关键字:1024,获取一份精心整理的技术干货 后台回复关键字:进群,带你进入高手如云的交流群。 推荐阅读 这是一个能学到技术的公众号,欢迎关注
评论