- 链接地址:https://blog.csdn.net/Liangheng32/article/details/121748268
- 链接标题:【精选】MySql数据库高级语句(一)_select count(store_name) from store_information wh_一只小毛驴 呀的博客-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:8024
文章浏览阅读500次。SELECT显示表格中一个或数个栏位的所有资料语法:SELECT "栏位" FROM "表名";例:SELECT Store_Name FROM Store_Info;DISTINCT不显示重复的资料语法:SELECT DISTINCT "栏位" FROM "表名";例:SELECT DISTINCT Store_Name FROM Store_Info;WHERE有条件查询语法:SELECT "栏位" FROM "表名" WHERE..._select count(store_name) from store_information where store_name is not null
版权声明:本文发布于特牛生活网 内容均来源于互联网 如有侵权联系删除