SELECT column_name(s) FROM table_name

LastName

FirstName

Address51Testing软件测试网/E{0J\$Vw

*rL7V9Eu1K0City51Testing软件测试网f#a6Z1G-S#rM

Hansen

y{k)K{J9X{:S0Ola

4p5~/_WY0Timoteivn 1051Testing软件测试网DgyQo+a

4YW6q#k@~0Sandnes

Svendson51Testing软件测试网|v[W6{/g.Y

Tove51Testing软件测试网H!GrN&{V2w0OP

Borgvn 2351Testing软件测试网p5r'H;Rz

Sandnes51Testing软件测试网-AUF;`9?Jr&[

hqSd,g4R8X6a0Pettersen51Testing软件测试网
rg#Ssu ~d6A;k

Mu/CJp#W2d5T,p0Kari51Testing软件测试网3J2El2Zg

\
U4F!JG^3A0Storgt 2051Testing软件测试网'n3ct B*Gk3U] d

Stavanger51Testing软件测试网9m[oi:x

SELECT LastName,FirstName FROM Persons

LastName

FirstName51Testing软件测试网&NINT"C-f7G
N(y

Hansen

|)E A"c w
vq!DQ0Ola51Testing软件测试网+h~5j;Qy,bF9~

Svendson

Tove

$D[M_ S"W0Pettersen

Kari51Testing软件测试网(s8UXX
j:T

SELECT * FROM Persons

5F4To{
b1U0LastName51Testing软件测试网h7Q1a)qjJP

}cgc!fe#CT0FirstName

L#q4t"DIV*TecD0Address51Testing软件测试网D}~ a4?]/X![IU6} V

City51Testing软件测试网tG9w f7P't)H3UA

9Fcn|Z0D0Hansen51Testing软件测试网\2?3b7E){t"s-apa

Ola51Testing软件测试网#H
{@-Yf6E9HZ

&jw}^ p0Timoteivn 1051Testing软件测试网%HJRS!z"T!i$i

]t6e!n6jGyW0Sandnes

N4~3i g$hL0Svendson

Tove

Kq5{pr4LE(h[0Borgvn 2351Testing软件测试网0DZS8{M2@1p)I

Sandnes

T y M.lV9n@0Pettersen51Testing软件测试网:}]3w%h+p0{|!kD

Kari51Testing软件测试网M n @,Q9sbn3t

u8eHNZwc0Storgt 20

Stavanger51Testing软件测试网+pd LC2S

SELECT column FROM table WHERE column condition value

SELECT * FROM Persons WHERE City='Sandnes'

LastName

FirstName51Testing软件测试网w6F*jW$a"@C

nY;}Bd)M
U0Address51Testing软件测试网 ]n*qP7O.aW.{/M

City51Testing软件测试网*}bb.Oa/x'LJ

Year

Hansen

/MTCsn9I0Ola

s@1`3w S'_;?4g0Timoteivn 10

Sandnes

1951

"c4`4?_:n9G+O;S5^c*l {0Svendson51Testing软件测试网F$?0Hp#cf [_

Tove

Borgvn 2351Testing软件测试网4D4K.A(uU+}^

B#L;d F'LA3J0Sandnes

}}&e1Q ? Oo$Vx y0197851Testing软件测试网T+fow3Qe

aW-|["a5vQ0Svendson51Testing软件测试网,b#oBiP3lHV}Gr

1Q9z'SO0Vd&d-V([0Stale

Kaivn 18

/~@ v Nzm st0[tL:i%ME0Sandnes51Testing软件测试网e1gx6E `(ut

1980

Pettersen51Testing软件测试网TqN{R:}D P/u

Kari51Testing软件测试网@:F H:Po r

N2z nMB({Lg|F0Storgt 20

Stavanger

196051Testing软件测试网Z6LvR0j:C

1d-i0I`)d0LastName

5MxR,j9f9J0FirstName51Testing软件测试网Y?.O0[V]r

Nfk:G]0Address

*]/BN#m!D @4Wq3wY0City51Testing软件测试网R9Vf2S\

Year51Testing软件测试网$@c#o.R{
p

Hansen51Testing软件测试网@(s5w],L V

[D!Ej6HC[0Ola51Testing软件测试网1V5t2Ag'KX|

Timoteivn 10

Sandnes51Testing软件测试网-W"L-T"Dj [*Z"pg,Zn

FkC [XUU#F0195151Testing软件测试网._|Te:`_

Svendson51Testing软件测试网W"NuwZ ZN1t]w9O-_

!fq6N4S(a%l3B0Tove

Borgvn 2351Testing软件测试网)]? U/UxR6?2W*H

w3p~'Q;y`x0Sandnes51Testing软件测试网zDC{$?r3Xy

1978

1x?U1KjzZG0Svendson

;dn"adQ4w;Nja0Stale

Kaivn 1851Testing软件测试网
Z J
a.NMWd8b!i/?_}

F#eQrb-C0Sandnes

_i2u-A v0198051Testing软件测试网 Nt*aF`0v

LastName51Testing软件测试网 r~&e F{gDv_

?-~A%\
M{H2D|0FirstName51Testing软件测试网(e4~+q4?B9H}

Address

f:oS1l'qG@Fz7Bq,W0City

Hansen51Testing软件测试网uxMR;bZ NPzL

uKa4D+G%L0Ola51Testing软件测试网}S_4p#x.i1~JG

N3Q
wP aFZ-C0Timoteivn 10

Sandnes

*V0d b8T4lz9I0Svendson51Testing软件测试网8r.R-lLc

pm$u`'{^n8fH(JiM0Tove51Testing软件测试网,\in%v2Zbb^4\&v

Borgvn 23

^7Lo]$pLdlB5jW ~0Sandnes51Testing软件测试网,hPfW0@_&U8Y

Svendson

Stephen

dnWt)s u0Kaivn 1851Testing软件测试网7wu!D1[2?5Rt:}"h

Sandnes51Testing软件测试网h jZv{o vb

SELECT * FROM Persons

WHERE FirstName='Tove'

AND LastName='Svendson'

LastName

/[%m I(`!E!f-p1l0FirstName

)O}XV6y(i!z0Address

City51Testing软件测试网P%C9s ^J7d4gQD[ }

g:X,E!MFS.W"QR0Svendson

Tove51Testing软件测试网n$a:Inx'Ib

"SlOS3[n?0Borgvn 23

Sandnes51Testing软件测试网7^f9lB#FnQY

SELECT * FROM Persons

WHERE firstname='Tove'

OR lastname='Svendson'

LastName51Testing软件测试网W5O6Nt
a9]j9E0g5~

4P6p6xDl0FirstName

1D"~2p8A;nH r8^)]5p0Address

VQUdt0City51Testing软件测试网cJwo(?!vm|9`7V

Svendson

i J
h&xm W0Tove

Borgvn 2351Testing软件测试网$n1}j/P-A/wd(e?

Sandnes

R-V|,PzL)ey0Svendson51Testing软件测试网E(g;I-i3~Uq`s

Stephen51Testing软件测试网8B]!HR9Svn7E0x4q;H

Kaivn 1851Testing软件测试网'F"c9v)@`"W#WB6a:@4j

9D0E6zx~5}t"H%T|&l0Sandnes

SELECT * FROM Persons WHERE

(FirstName='Tove' OR FirstName='Stephen')

AND LastName='Svendson'

LastName51Testing软件测试网"ia
_j@y D+_*}:^

FirstName

X,z(BPC'X0Address

City

d_;jr$^WDH l x [0I0Svendson51Testing软件测试网 jVK&iyR Z;So/T

Tove51Testing软件测试网
uE5p f Z G

Borgvn 23

0UR
TF2qiM~0Sandnes

D R5UQ7j#vV"e0Svendson

A1A U6?#|0Stephen51Testing软件测试网6vWo?3Z)V

Kaivn 1851Testing软件测试网c c.\.c)U{H

Sandnes51Testing软件测试网`6Cvb z3U/}

SELECT column_name FROM table_name

WHERE column_name

BETWEEN value1 AND value2

LastName

1] T{2NJ(Ha/^0\ND8j0FirstName

Address

City51Testing软件测试网%[1b(lc`LQ}
f5aX:I

Hansen

'EbE1||,D-b/h0Ola

Timoteivn 1051Testing软件测试网6dkdA ]&~)v

Sandnes

"v/Dhrcx*UOh0Nordmann

Anna51Testing软件测试网Z J;oEF

Neset 1851Testing软件测试网6q1j/q1OJ(oP
ze

$w9s/VRPm-P0Sandnes

VpP DlDV0Pettersen51Testing软件测试网/^3U#x"H8wu%g

] Bb$p2x8cR7m3j,j0Kari

Storgt 2051Testing软件测试网Y!p h:{zP

Stavanger51Testing软件测试网f)Qm(CCDbs

/Mj;~h+jE-qF0Svendson

Tove51Testing软件测试网#u} d/m5L2t"P

X2E.vwJ;} c0Borgvn 2351Testing软件测试网1}!k*|;B1ul[*`7Tj~

Sandnes

SELECT * FROM Persons WHERE LastName

BETWEEN 'Hansen' AND 'Pettersen'

hN G+p$x-L4n0LastName

FirstName51Testing软件测试网c8SnD7]WQ

0~+r8D1\*P W*`0Address

City51Testing软件测试网h%W NDJ d|oj

Hansen51Testing软件测试网6D$}D
J,_ } v

J0bm'?|)Y0Ola51Testing软件测试网m(fa8K\]@T,l

Timoteivn 10

Sandnes

Nordmann51Testing软件测试网RU)|cX9}

h*I%c(dBe ]0Anna

Cy&]$`W(_nv:D0Neset 18

Sandnes51Testing软件测试网ESx;CF-y

pw6QS @R'u0Pettersen51Testing软件测试网wJ Tis sIl

Kari

WF,f,N ull5LJ0Storgt 20

5s%PB-n~X(P(G7U(c0Stavanger

SELECT * FROM Persons WHERE LastName

NOT BETWEEN 'Hansen' AND 'Pettersen'

8h)?,FN'}hf+eqo0o0LastName

FirstName

A/}%H'@.|Z-v0Address

%|^0W,[6K:N]n2@hP0City

^M#I }$ZJw c0Svendson51Testing软件测试网Dr#\:O'\S*Z

Tove51Testing软件测试网q0x;TO:K_$?

Borgvn 23

Sandnes51Testing软件测试网l~{WCjZ

SELECT DISTINCT column-name(s) FROM table-name

(@J9?&S0k8[0Company

OrderNumber51Testing软件测试网1ASTstPs

Sega

Cu)S:^0zp%~0341251Testing软件测试网`/`p/rRBLdjE

W3Schools51Testing软件测试网grR!nJ&O

231251Testing软件测试网n]Bj-^lX}

Trio51Testing软件测试网
Y-g q4J b:Q:bX.Oav

4678

#w&cGw5gW0W3Schools

6798

SELECT DISTINCT Company FROM Orders

Company51Testing软件测试网SDh$^,@9n{:E#JV

Sega51Testing软件测试网'E`0C/^9V ~@

W3Schools

Trio51Testing软件测试网9^Y6dQ9UPyd
r

SELECT column-name(s) FROM table-name ORDER BY{ order_by_expression [ ASC | DESC ] }

(f3C9uNe)j+Qh0Company51Testing软件测试网'j1whu.LI]

OrderNumber

}C,lB*S)m#z0Sega51Testing软件测试网t d D@l3b

XM(xlS q_U0341251Testing软件测试网F'^tAr2v

|l:dyZrI1cJ[0ABC Shop51Testing软件测试网T1XE9Ze q*E

567851Testing软件测试网K i'ioU"b

W3Schools

2312

E;uN:Mv4v;pZ,U0W3Schools

I!N${{cn\p_/R0679851Testing软件测试网Xf_+Mt|

SELECT Company, OrderNumber FROM Orders

ORDER BY Company

npvYB+o:l:e Uwgv0Company

OrderNumber

ABC Shop 

5678

Sega51Testing软件测试网R:k ].o#W@

ObNR3w03412

W3Schools51Testing软件测试网)|tYMd"E

)u'beN0fP-zT0679851Testing软件测试网.v"D9~v/d.{2}9[

W3Schools51Testing软件测试网 hKx,GD1Axe[4}m`

t&o#g u
tb_02312

SELECT Company, OrderNumber FROM Orders

ORDER BY Company DESC

Company51Testing软件测试网*f'@ F[ T1Gb4M,w

OrderNumber51Testing软件测试网 J S,] t,eQ7i

/FsR z3uH n|0W3Schools

679851Testing软件测试网!ta4|bK!j^2h [

/Z}2I \
cB0W3Schools

\&[NJy
t02312

'OU*s#[MA0Sega

#q)]8ye{1Qtt5g.]0341251Testing软件测试网w T&?3aY;q

R/CwDnj,j
in0ABC Shop

QCU/}^0~;}[ r05678

SELECT column,SUM(column) FROM table GROUP BY column

Company

Amount51Testing软件测试网5E }0q4k:QekCjj(]

#[M){ T\/W;O[1?:E!?0W3Schools

550051Testing软件测试网R4d Zo.I.o+T2s
`0C

1Eo3R'I"_O&mYE0IBM51Testing软件测试网!X'A6f+MP/c
_

/pNTp [)E%tr04500

W3Schools51Testing软件测试网G-no'oZ

qX^mA Xm-M[d07100

SELECT Company,SUM(Amount) FROM Sales

GROUP BY Company

Company51Testing软件测试网?'~Kt%Naa@

Q0n+cU8Q {*a0SUM(Amount)

W3Schools

1260051Testing软件测试网-G|r7? uj:q~/F1h v

sZD W;o)g0IBM

7m3B Z]3Z(m2?04500

SELECT column,SUM(column) FROM table

GROUP BY column

HAVING SUM(column) condition value

L:oG(hK7NcY#P0Company51Testing软件测试网Ph-\DgNrMJ4a,p

'[,`'iY J4x^0Amount

uy&Z
H SCV V0W3Schools

550051Testing软件测试网*V9X/V c_(`MdE a

iKzW JMsg*M0IBM51Testing软件测试网R0yfsPu

#K~?+BU/i\0450051Testing软件测试网s-[.s&WM._\

u)F:m"v"io0W3Schools

*GA`2s
Qw N0710051Testing软件测试网.Z!K"Tw3|X&E},|g

SELECT Company,SUM(Amount) FROM Sales

GROUP BY Company HAVING SUM(Amount)>10000

Company51Testing软件测试网4m
EK$B;i*H y

}!z2CNUQD0SUM(Amount)51Testing软件测试网~J"GgQ)fj

qkTaE-gu3W0W3Schools

12600

ID

Name

c
xZ5i"l4k1c00151Testing软件测试网p2{] [8?W&YWD

Hansen, Ola

0251Testing软件测试网 K9o;S9\"D

Svendson, Tove51Testing软件测试网7W2Bh+E;l

-d*W)}z4J8F7RH!H@!?003

B"wlsr.v6J0Svendson, Stephen51Testing软件测试网U"u!p8sm/M*Mn

Y8u2dL k8Pp~0d&~5N004

Pettersen, Kari51Testing软件测试网CB9i,YK~

ID51Testing软件测试网X NO'u)l(ySz

F"~?%RG"q8V0Product

01

Printer

0351Testing软件测试网/V#f%FJ7?j4]

Table

3x2kYn"G0f7k(J"A00351Testing软件测试网"n is#Z+|A

py#\/B0S i!F8g0Chair

SELECT Employees.Name, Orders.Product

FROM Employees, Orders

WHERE Employees.ID = Orders.ID

1Pf,B.S_
M&Q0Name51Testing软件测试网cvd)rP

Product

Hansen, Ola51Testing软件测试网P_S`3A7GB+\

@o.X*`2oRl0Printer51Testing软件测试网/tL9Zyu]xi s

%J
HfK6HFt0Svendson, Stephen51Testing软件测试网UI%^k6R*Q

GK2z_1] n$Qn(rg/W0Table

Svendson, Stephen

!X5Oo@bS0Chair51Testing软件测试网bJ9LxlUh*Xq

SELECT Employees.Name, Orders.Product

FROM Employees

INNER JOIN Orders

ON Employees.ID = Orders.ID

SELECT field1, field2, field3

FROM first_table

INNER JOIN second_table

ON first_table.keyfield = second_table.foreign_keyfield

SELECT field1, field2, field3

FROM first_table

LEFT JOIN second_table

ON first_table.keyfield = second_table.foreign_keyfield

SELECT Employees.Name, Orders.Product

FROM Employees

LEFT JOIN Orders

ON Employees.ID = Orders.ID

6O[oe%?6t4r)}],J0Name51Testing软件测试网c3_;pYL B5Xy

:v+FXUi
u0Product

"L]:?i|P9Sx0Hansen, Ola51Testing软件测试网2N*lP
S1N

G1@YE2G;d0Printer

Svendson, Tove

Svendson, Stephen

)y9Nbbm#XL H6p0Table51Testing软件测试网)@0dZp[

Svendson, Stephen51Testing软件测试网 X.{"J*L%H%J

+q#n*m3d$k@k.t0Chair

Pettersen, Kari51Testing软件测试网+q3|P]*H

 51Testing软件测试网 ?1L/DGPrF1u5P]:|6E

SELECT field1, field2, field3

FROM first_table

RIGHT JOIN second_table

ON first_table.keyfield = second_table.foreign_keyfield

SELECT Employees.Name, Orders.Product

FROM Employees

RIGHT JOIN Orders

ON Employees.ID = Orders.ID

?.?:mP(x*S|F0Name51Testing软件测试网d~-z2OOm

Dg
x+B%b*eK0Product51Testing软件测试网J,Ff8}$@8b

%jx'?A;yoD e#?$t+q0Hansen, Ola

Printer51Testing软件测试网
Bm(vjG"S W

USd0_c#q3r8o4W0Svendson, Stephen

k!d}|R4jk0Table51Testing软件测试网 AcN/m@*m.z

Svendson, Stephen51Testing软件测试网W%A']7snx#i

Chair51Testing软件测试网 zF&M QXMRca

SELECT column AS column_alias FROM table

SELECT column FROM table AS table_alias

/z+u5OL B!El8I.Y-e0LastName51Testing软件测试网/T,R FS$Y2Q4x]u

FirstName

oD6H&rK:]H&?/?/T0Address51Testing软件测试网\,KuM-^j:Fp

City

'?y
H'QA'TQ0Hansen51Testing软件测试网 NL ?Bm0rI

Ola51Testing软件测试网*dE,dLTqt yj(k

mK&Bucd0Timoteivn 1051Testing软件测试网m2z9a S"w;QdYb`:fp3S

m l(\Kf
M"t6Uc0Sandnes51Testing软件测试网f#^%Ox4u!g"`

Svendson

;O0s;PP zZdl0Tove51Testing软件测试网$OF@fGr

V)]&i&}3~r
o|;P0Borgvn 23

m,dAmS(`8?X6BH0Sandnes51Testing软件测试网*G@W7mLv Q%\ ]o

Pettersen51Testing软件测试网y5ajrvU(u

Kari51Testing软件测试网(TrwB
C A

Storgt 2051Testing软件测试网 tYl$DgK-mN,I*{/^JN&v

Stavanger

SELECT LastName AS Family, FirstName AS Name

FROM Persons

+s7P8aKV |Ks+SH0Family51Testing软件测试网E2|Dl)t!PP

%Q(`2VVP-v'e%z0Name51Testing软件测试网1MGq zM ?7l&g

^{+u8B w)M(Y0Hansen51Testing软件测试网X&`m
X!x:S

/q@`1h n[(l'K/bh0Ola51Testing软件测试网"zOp Wq\;by+?

;Gmr,O7da*L0Svendson

Tove

/dHnqf0Pettersen

Kari51Testing软件测试网5iX(elt6h"N4F"OFL.`4H

SELECT LastName, FirstName

FROM Persons AS Employees

0h!s.B_4G"w-S9LY{8o0LastName

#[Lg[2GUH;u0FirstName51Testing软件测试网0J$hiA
_!z.Z

Hansen

Ola51Testing软件测试网VU;vN|~m0}5wDs-Q

*s*^4Oq8{x+N)[m \)}0Svendson

5ZW[)a"O'F`e0Tove51Testing软件测试网6WjH:]:iE2r,qp&O

Pettersen

[LS,w9j/[)W
o(h7I(Jl
x0Kari

INSERT INTO table_name

VALUES (value1, value2,....)

INSERT INTO table_name (column1, column2,...)

VALUES (value1, value2,....)  

w%L-m hXG0LastName

FirstName51Testing软件测试网lN&\ UZ:rt1\

Address

City

fSM9cZ"j#R0Pettersen

G C wYiD9m8k0Kari51Testing软件测试网&Qh;O]@%u

Storgt 20

hS J&sV#M$WS0Stavanger51Testing软件测试网 uOg%[4[ u.GM2C0Q g

INSERT INTO Persons 

VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')

LastName

FirstName51Testing软件测试网-YP T{G$\

Z1v)[.A$tZ Zcv/]0Address51Testing软件测试网%y+N!V#n'I*W

City

Pettersen

Kari

Storgt 2051Testing软件测试网zNU+LvW

Stavanger

7T b1m?;G,i*U:rr Y9D0Hetland

o5R gN
U3P~0Camilla

Z?Y$_
L0Hagabakka 2451Testing软件测试网_OTo0N-N

Sandnes

INSERT INTO Persons (LastName, Address)

VALUES ('Rasmussen', 'Storgt 67')

LastName

FirstName

\ ?.`Y?t t0Address

p8`?*P0R:u!VZ z0City51Testing软件测试网ZX M.~9L2z

O)H+Za4v5J ed0Pettersen

Kari51Testing软件测试网OrMi6`'X^[

Storgt 20

Stavanger

3E:|J(b`-g.L0Hetland51Testing软件测试网p P OJ4\)\1k

Aq]4I+~#rU3Q0Camilla51Testing软件测试网|H|!_K"sd5y
w Y4]s

Hagabakka 2451Testing软件测试网3['c2I'j;S-s_

Sandnes51Testing软件测试网Co~3Yo\z-A ?

Rasmussen

Storgt 67

Ed$[Tj%q!z0 51Testing软件测试网X];B)Q3M;UF6l

UPDATE table_name SET column_name = new_value

WHERE column_name = some_value

LastName51Testing软件测试网)whK
Ih u2hWV h

(B8zjj;a;|U&Dr0FirstName

Address

Z5LqPmpmqvs$mb0City51Testing软件测试网6f w2G3VH'U j ?hl

R"\ |e%[a8L0Nilsen51Testing软件测试网@0F4^E/g/y3|+x"o

Fred51Testing软件测试网6H{!n9]8_*j&B

P~ nu+i(Ue F7Fy0Kirkegt 56

Stavanger

)`:Z0EU$EU/er9s'e$uW8u0Rasmussen51Testing软件测试网(a&t6Rj ~

G-WX~O0 51Testing软件测试网
|1m2o6e!d UC

JwH'M+jw0Storgt 6751Testing软件测试网{DZcl!C

:dF4X\Qt6d0 

UPDATE Person SET FirstName = 'Nina'

WHERE LastName = 'Rasmussen'

$C^ D/T%|0LastName51Testing软件测试网)lf'|7j5u

FirstName51Testing软件测试网;F(Y hrI/H

4Gm3\!g N;M+GW0Address51Testing软件测试网`8Lf3A LC

City

~ L|4UUc8ln*u2T0Nilsen

Fred

Kirkegt 5651Testing软件测试网+sp2a;AO#j7H

4`.@)Z2s+nww0Stavanger

R0aj)J-Z7q0Rasmussen51Testing软件测试网d}
QU-c
n-s'z

Nina

A1E&A)F/@Z;YhO0Storgt 6751Testing软件测试网/Ag)`|#A
B

UPDATE Person

SET Address = 'Stien 12', City = 'Stavanger'

WHERE LastName = 'Rasmussen'

!X}8|j4T5E2O6d wc0LastName51Testing软件测试网
dvOU-J6er}

FirstName51Testing软件测试网X oKb!coS

~*JS7SFJ`"u0Address51Testing软件测试网XgO(FE$}1?x}

(u/a(T/tX l6Hv@0City51Testing软件测试网^J7I-dF{

Nilsen

eO*[5~/P0Fred

Kirkegt 5651Testing软件测试网(mB"Y"f"OU^

'YS&txA\!I_0Stavanger

Rasmussen51Testing软件测试网,cp^ q#P2j9G

4{THz+q.L;_2L0Nina

Stien 12

Stavanger

DELETE FROM table_name WHERE column_name = some_value

LastName51Testing软件测试网*UWWkW+Z$u7z P

FirstName51Testing软件测试网`A'I;FbQ&{aN7d

l)k#ug#X0Address

City

6w4C0A~7Nd0Nilsen

Fred51Testing软件测试网} w+fAi
ZD4E
D
BZy7N

Kirkegt 56

Stavanger51Testing软件测试网9?BR;KG\

)o~oJMH \0Rasmussen

Nina

Stien 12

Stavanger

DELETE FROM Person WHERE LastName = 'Rasmussen'

LastName

FirstName51Testing软件测试网8@ j2Rwk

Address

M:? H:Zj0City

Nilsen51Testing软件测试网v4K4|;K S`T8t0C

uX"lqMB/l0Fred51Testing软件测试网?3}0\,qD@kVGQD

9K6P3G\*L$k)Z0Kirkegt 56

Stavanger51Testing软件测试网J2A1Bk:?@+W

CREATE TABLE table_name

(

column_name1 data_type,

column_name2 data_type,

.......

)

CREATE TABLE Person 

(

LastName varchar,

FirstName varchar,

Address varchar,

Age int

)

CREATE TABLE Person 

(

LastName varchar(30),

FirstName varchar(30),

Address varchar(120),

Age int(3) 

)

5J!F[1L_.y.Z+e0Data Type

Descrīption51Testing软件测试网/m8v2?^E0|t

integer(size)51Testing软件测试网)u |p [f|:pq
int(size)
"|eJtj9a0li0smallint(size)51Testing软件测试网JMP/W4Q
tinyint(size)

Hold integers only. The maximum number of digits are specified in parenthesis.51Testing软件测试网*csC[+A/d

decimal(size,d)
q
^]f9y&`gB'R0numeric(size,d)51Testing软件测试网N"g$AE1T/rtu.Y

Hold numbers with fractions. The maximum number of digits are specified in "size". The maximum number of digits to the right of the decimal is specified in "d".

4|_ c8}oQ0char(size)51Testing软件测试网8T!o"J xX E1_~:f#@-N

7t3v^I$Z AP:uT;N0Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis.51Testing软件测试网 b8k;O)V,m$l9F

varchar(size)

Ls~)X#E$mm H0Holds a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis.

date(yyyymmdd)51Testing软件测试网D
ARzW5[*A,Mb6|

{:P ?s"b
{2Mi){0Holds a date

ALTER TABLE table_name

ADD column_name datatype

ALTER TABLE table_name

DROP COLUMN column_name

J*r
\n7f9a!q YA1_4u0LastName

]7fo7P5G0FirstName51Testing软件测试网D9l k IX

Address51Testing软件测试网QPwE1Ut

WV!Z5LH0M(m8j|0Pettersen

~4wCX_'I#tI0Kari

Ad5r0lp3yj"K v,g0Storgt 20

ALTER TABLE Person ADD City varchar(30)

LastName51Testing软件测试网|:]/?7D+}

FirstName

Address

City51Testing软件测试网g8N2x$Xo

Pettersen51Testing软件测试网 f+kUmxm

/Lwt)A1j ]rw0Kari

Storgt 2051Testing软件测试网 Q(}@,Ie-t)GJ
d@

 51Testing软件测试网w5i*B1x)@"BO1{"c

ALTER TABLE Person DROP COLUMN Address

hd` U [i0LastName51Testing软件测试网q(mJ@/F0Z F

FirstName51Testing软件测试网2[H8U'y,_T;e1d;B&Tw

!KU%@St0City51Testing软件测试网:K:K2d9a9_ h$A

od[THe0Pettersen

Kari51Testing软件测试网&}3pE8f"Nb,z`y

 51Testing软件测试网g6Q$i%pE3o

DROP TABLE table_name

CREATE DATABASE database_name

DROP DATABASE database_name

SELECT COUNT(column_name) FROM table_name

Name51Testing软件测试网pom@u+K6B'NR

.xWz`8mwgJ\l8F0Age

:Y0K%~t7A2?Q$L0Hansen, Ola

34

8leTe$By V
f6X:\7g0Svendson, Tove51Testing软件测试网*c6b9d3Hr&JU

4551Testing软件测试网d%\,\@CP @^

O3B;EIa
_~c0Pettersen, Kari

19

SELECT COUNT(Name) FROM Persons

3

SELECT SUM(column_name) FROM table_name

Name51Testing软件测试网7g lw#EY:L3`%r*W$h

Age

Hansen, Ola

34

Svendson, Tove

#H:m&q3N.P.PSy04551Testing软件测试网4Yn_-OgE)I

Pettersen, Kari

*W RU+i&w2I019

SELECT SUM(Age) FROM Persons

98

SELECT SUM(Age) FROM Persons WHERE Age>20

79

SELECT AVG(column_name) FROM table_name

Name

Mw3TuCM0|@0Age

Hansen, Ola51Testing软件测试网e%hn8azinrb

C:h0ipQ*M&f;}034

Svendson, Tove

Ani.U ^'Z0A045

Pettersen, Kari

O,cokG` b019

SELECT AVG(Age) FROM Persons