MySQL简单学习+Navicat 12破解版工具下载

Select

SELECT “字段一” FROM “表格名”;

从数据库中选出字段一的内容

Distinct

SELECT DISTINCT “字段一”

FROM “表格名”;

从数据库中选出不同的字段一的内容

Where

SELECT “栏位”

FROM “表格名”

WHERE “条件”;

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 “表格名”

WHERE “栏位” LIKE {模式};

模式   %q  表示以q结束   q%表示以q开头   %ldq%表示中间包含ldq

Order By

SELECT “栏位”

FROM “表格名”

[WHERE “条件”]

ORDER BY “栏位” [ASC, DESC];

ASC升序   DESC降序

Count

SELECT COUNT(“栏位”)

FROM “表格名”;

计数

通常与distinct结合使用  选出不同字段内容的个数

select  count(distinct  栏位)

from  表格名

Group By

SELECT “栏位1”, SUM(“栏位2”)

FROM “表格名”

GROUP BY “栏位1”;

根据栏位一分组后再根据栏位二求和

Having

SELECT “栏位1”, SUM(“栏位2”)

FROM “表格名”

GROUP BY “栏位1”

HAVING (栏位);

对函数产生的值设定条件

Create Table

CREATE TABLE “表格名”

(“栏位 1” “栏位 1 资料种类”,

“栏位 2” “栏位 2 资料种类”,

… );

Drop Table

DROP TABLE “表格名”;

Truncate Table

TRUNCATE TABLE “表格名”;

Insert Into

INSERT INTO “表格名” (“栏位1”, “栏位2”, …)

VALUES (“值1”, “值2”, …);

Update

UPDATE “表格名”

SET “栏位1” = [新值]

WHERE “条件”;

Delete From

DELETE FROM “表格名”

WHERE “条件”;

关注小陆，不再迷路！

推荐一个学习的工具：Mysql+ Navicat Premium 12

下载地址：进入小程序点击下方“下载”即可自动复制