特牛生活网

【精选】MySql数据库高级语句(一)_select count(store_name) from store_information wh_一只小毛驴 呀的博客-CSDN博客

网友收藏
文章浏览阅读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