第八节:SQL语法--学学习网
学学习网
首页 SEO SEM 网络营销 Internet web开发 应用开发 数据库 设计工具 淘宝开店 联系指导

Select

SELECT "栏位" FROM "表格名"

Distinct

SELECT DISTINCT "栏位"

FROM "表格名"

Where

SELECT "栏位"

FROM "表格名"

WHERE "condition"

And/Or

SELECT "栏位"

FROM "表格名"

WHERE "简单条件"

{[AND|OR] "简单条件"}+

In

SELECT "栏位"

FROM "表格名"

WHERE "栏位" IN ('值1', '值2', ...)

Between

SELECT "栏位"

FROM "表格名"

WHERE "栏位" BETWEEN '值1' AND '值2'

Like

SELECT "栏位"

FROM "表格名

大娃小哇母婴童生活馆