下载提示
- 1.该资料是网友上传的，本站提供全文预览，预览什么样，下载就什么样。
- 2.下载该文档所得收入归上传者、原创者。
- 3.下载的文档，不会出现我们的网址水印。
文档列表
文档介绍
该【2022年MySQL面试题和答案 】是由【cjc201601】上传分享，文档一共【12】页，该文档可以免费在线阅读，需要了解更多关于【2022年MySQL面试题和答案 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。:.
MySQL
Mysql,myisaminnodb
!"#!$%
&'()*+,-./0123(45 6
789:;<=>9"#9$%
"#?***@ABC
MylSAMDInnoDB,HEAPDBOB,ARCHIVE,CSVE
MylSAM FGDHIDJK4LMNO CPQ &'7E><
InnoDB &'DRSETUD"#6I VWX9 &'YZ[E
MySQL"#\.]^_`abcde=fg,
h3ijklmnopq
"#\tuvwxy"#z{|g}~join
b. "#?@[
\N
d."#gM
e /memcached,apeE
f. ¡F¢£
g.¤SQL /SELECTxFROMTABEL¦SELECTfield_l,field_2,
field_3FROMTABLE.
§9¨g©ª«¬®n¯°±²³´ µ¶
g`3¶·q
a.¸¹º» ¼Q&½¾µ¶g
"#\µ¶
c,¿ÀRyµ¶ÁÂ7ÃÁ>/ÄÅÃÁ
d.-.ZÆÇÈ
e.É v¨
f.ÉÊË`3ÌÆͲµ¶gAΧUÏ6op
ÐÑÏ6SQLop?:.
(1)Ó¸
eMySQL¦ÔÕÖA×ØMylSAMInnoDB,ÙØÚAÛAÜ
MylSAMCÝÞ9gßà§A9g-.$ ás âãäå
ÝÞupdateØ æØÚ çè±éÏê:ë NÏêÚì°-.í
îN-.ïF àðMylSAM§SELECTCOUNT(x)ñ?3ë òLì/
InnoDBóô Ø
õö§C!ð /MylSAM÷
ø ß ð&'''6" ;-./01ûü +oý $þÿ
(2)
!" #$% &'"()!*+( -.&
/0&)
23
4567(89: INT;<=>
: MEDIUMINT,SMALLINT?@
TINYINT"ABC$%DEFGHIJ
: DATEG DATETIMEKL
MN
DOFGPQRQSTUJ
(3)VWXYZX[
X[\E]^6@_=>?@`$%aD&b
(c DdG"Ae ;
<WX
******@VghiX[
jkDGWX***@lmn
2ohipm
X[
(4)qr: Selectxstuvw
23xy6"zL {\|
$%D
t}~WEB}~@i}~
"Z
:DGxy&p
OEG x/
0^O
_;
(5): ENUM******@VARCHAR
ENUM***@ke# ¡a¢£¤
g¥¦***@TINYINT,§g¨&¤©ªV
« ¬;
;<C®!&zL¯M°±²$
³´µ¶·µ¸
¹º» C¼½@(¾|¿^
23
Do: ENUME@
VARCHAR
(6)À: NOTNULL
jkD( Á´ ÃÄ: NULL½
Dod@ÅD¥NOTNULLo
NULLg¢FGƨUJ
\|
aDÇÈ ÉIÊ
DËÌ"ÍÎMN
u\E@-D6E: NULL+
Ï¢ÐÑ@ÁÍÎ
ÒÓ"(CÐÑÔ
DFG:
NULL½
(7)¿^ÕÖ&"#
$%&bp×@''¿^ÕÖ"
Ú &"ÛÜV@''static"?
"fixed-length"²$
&b7($Ô
VARCHAR,TEXT,BLOB.'G
DÝÞ+gb C
23 &6E@''¿^ÕÖߺ&à+
¬
MySQL[
â" ãä å;æ8:.
¿^ÕÖ&"³
ÃVMySQLWçL"#C
ÃV C¿^ÕÖ@Áèé
êëÔ ìí
îïv¼ðNO"Á#$%E@^Õ
23
ñ
òGóÔô
FGËÌóõ=>
\|
¿^ÕÖ&OèéÛö¦÷hEø
`ùú @
¿^ÕÖ"û
üCUJ
ÃV^ÕýþD E
ÿ
!"#$%&'(SQL)* (+,
-./01 234510
678(7801
9:;<=>?@
A BC
DE'%
-FGA
645AHIJ
9KL23MNOPQRSTUV
WW XYZ[\]^ _`a bcZdeAfghij Zkldmn
oKLGApqrsh tu:vZ sGwxA Xyz{|}~
+, ]!p
B+ h B+
zG InnoDBxy
z./ ¡+,
¢`a£+,¤¥¦./
M§¨LIKE)* ©ª«
0R)*¨IOJ./+,
6°±no²8³ ´ varcharZGµ,¶·ldm¸³¹int±º
SQL)*
orderby»¼!
alter23e½ss:.
insertpdelete¾¿
ÀÁ
MySQL
ÂÃJÄMÅÆ_sÇÈ ÉÊÅÆË:ÌÍÎÆÏÐÑx |ÒÓÒÔ
SQL)*Õ+,
-Ö
6£
9×Ø
sqlÙÚÛ
ÜÝÞ ßàáµ âãÞx
sqlÙÚâã
äåæç¡
èéêëìí
îïGð¶ñò./òð¶
ìíóôõ
c¦
1.öTÑ÷/øFùú 2ld45ûüøFýg 23wøF£NOTNULL,þ '
‘'
ENUM
2.
OIN)
3.
(UNION)
4. !"
5.#$ %& !"
6.
'()%&#$
7.*+,
8.%&-.:.
0123mysql4)+,)5()67+,)+,
8)9:;<=>?***@ABCDEFGHIJ
+,K7LMNOInnoDB:; P+,K QR7STUVWJ)XYZ[\9
:; ]^W_`,
ab
7c+d1ef(gKEYhINDEX$i+,J67jKkl9:;mnop
7c+,qrs+,:;tZ[uvwxy=z${S:;t|}Z[~q
w, S:;t+,
f(gUNIQUEX$i 7S67+,
K)67+,:;_`67
5()K7LM67+,)7 4}=$i7S5(+,)5(
677
_`)
f(gPRIMARYKEY
+,S:;t)xINDEXcoiumnA,columnB+,)K+,
+,:;op)K ¡¢£¤¥¦§¨ op)© ª«
¬F® )¯°®+,NO
:;<4 K?@
transactionK® 7S1±7T>²:;<®xyT4^W®³U
´)µ¶ U´)· }>7S®¸¹) U´xy^W®ºU) µ
»)¼½¾|®
^W¼¿:;<ÀÁxy7S®¸¹)µ |ÂÃ) ^
W®AB³|ÄÅACIDÆM)ÇÈÉ7ÊËÌ
ÍÎXSSÏÐÑÒxÓÔÕÒ
xssKÖ×ØÙÏÐ)ÚÛKÜ
Ö×ØÙÝÞ7SMßàá⪫ÏÐãäåØÙ,
æçÜ
èéActiveXêOª«ër«
htmlspecialcharsì:9»íîÀ«ïð) gñò]IMñóôõ&
SQLö¤ÝÞ÷øÇ©ÒxÓÔÕÒ
SQLö¤÷øÇ©ùÁ²úûïÁ4örüýFsql-.þ9MgñÀ«ïð)
ÿ
POST GET
sql
SQL
!"#$%& magic_quotes_gpc magic_quotes_runtime(#
sql)*+addslashes,sql-.
Sql/01 2345678 978
:;sql& <=> update?insert?delete?select?x?
***@ABCD EF GHIJKLM3 EFNBOP QRGHKS2TUVW :.
Php"#$%&(#register_globalsXoff,<Y
Z
[\]^_`K23abcdefg]^_`Kh]^_`0Wij$%&
XD&kEFlmnokABpqrst(uv
EFpqwxy z{|date,time|enum,char>varchar>blob,text
wx}~AEpqKi ,pqKEpqKykABpqK
wxlm+ ABpq
)
Datatime:YYYY-MM-DD))KXWK+8Ek
Kdatatimepq)<
Timestamp:)K+4EK1970-1-1 U2038-1-19,¡¢
N£¤¥¦§k)K¨©aª« AB¬)®¯k¬timestamp«k°
Date:r±iv+kEA²*+E.3³K*+date´µ33
EKi¶·K¸¹+i)ºA,iku»
Time:) ¼kAB
½:23*+Epq¿i)ABr²E+kKa,
ÀÁ:¹+ikºAv
*+inti)2Â*+timestamppq
L¤<ÃqABCÄÅKÆ7ÇÈM3 ÉÊKËÌÍÎ
<Æ7 ÏÐÑ
a?Æ7 Ò ÓÔÕ
Ö×ØÐABD& Q§_`K
@ÙÆ×Ú
ÛÜÝÞÆ7KßàABCD&áAB ÝÞ
â×D Dã äå
*+æç èPé,ABÙÆ)K¡êë³Àì&æç èP )
b?Æ7LABCÃí îïðñÓÔÕ
îïðñ
ÛÜÆ7 òóÆ7µ3ôõ)Kö)÷øAB ùâÄùâúÆ7µ3+st
K2ûDµ3+ABKáÆ7üµ3+stúÈLD,ù?Zh?
)ýÆ7ü3¯þòóKöÿ
c
!"#$%&'(.
*+,-&'(
d ./01234
56"#789:;<=>?***@ABCD<E34 :.
56GHIJE34EBKLM&'NtextO
PQMySQLR7MylSAMSInnoDBTH
TH6UVR?+GWXUYZ[\]^ _`:\]^Xb6E
c3XR
InnoDBdMylSAMTHe
InnoDB\]^ef+ghOLTPOnlineTransactionProcessing,ijklmnK
go EXpqrstuACIDjk\]^BDBpqtujk\]^Ev
wxyz{n
GWe
|}~ tuEtujkEtu{E~
Xtumvcc }~
MylSAM\]^eXMySQLK\]^Ef+ghOLAPOnlineAnalytical
Processing,ilmnKgo
GWe
3tujkE~
Xtu{Y ~EtuSL
E3
MySQL dTH
./X e ¡¢£¤¥¦E§X¨3 ©ª«ZE¬q
®`¯S°q7®`¯±²
X³«Z E´µq«Z¶·¸¹º«Z`¯E3¹º«Z`
¯3»¸¼½¾¿7EÀ³±²}
U½¾¿73ÁÂùº«Z}EcÄÅ»ÂÃÆ Ç=Èq7
®}EÉÊË01´ÌÍÎ
ÆEÇES
ÆEÏÍÆEÆ
fEÆ7®`¯Ð»¸¼½¾¿7E56Ñ
Ç7Ò±²`¯EÓÔ+ÕÖEÇ×5oÑ&'A NULLØÙÚ Ç
EÏÍÇEÇ
fEÇ7®`¯Ð»¸¼½¾¿7 ÆSÇÛ
ÜÝEMySQLÞßÅ3tu
¸ÊË (MySQLR\]^àÍNÖe3T
á!n
MylSAM> Merge MemoryHeap Example,
Federated,
âãq^
Myql7jkäåæçèQ:.
jkX éêëqR-<EÉ+/ì+/3ìEXq3Ûí
îïðEjkäåX¨ñjkòwró5Rôõö÷
+øùúûR7Èq3øùEü¾§ý3XqjkþEÿ
,
!"#,
$%&'()*+,-./012!3)
4
5678 !"#9 :;!
127<
SQL=>?***@ABCDEFCD5AGHIJKLE
MNSQL=>?***@OP/Q(DDL)ROPHI(DML),OPHI(DCL)4OPST(DQL)
UCD(
OP/QNCreateTable,AlterTable,DropTable,Craete/DropIndexV
OPHINSelect,insert,update,delete,
OPHINgrant,revoke
OPSTNselect
WXYZ?***@AGE
MNOPWX(DataIntegrity) [OP!X(Accuracy)4\X(Reliability)(
]0^_U`N
1)abWXNc/!Fde
f!ab(
2)gWXN [
!hijklmno/!OP`pYZq
YZr?***@stuvR
wxVc/(
3)yzWXN [{!|JKL4}JKL!OP~ !OP!
XOP Q!OPeOP
(
4)/Q!WXN!JOPPq~!6Go
!YZ(/Q!WX mo/JOP!YZ,m
b~ijkl!>Q6¡(
¢J!YZN?***@hYZ(NOTNULL(¤¥YZ))4YZ(PRIMARYKEY,foreign
keyRcheckRUNIQUE)?
§¨ 12E©qoXE
MN12N h!OPHI OP~!ª«¬®¯(
12oXN:.
(1)°±XN]²X126¨³D&´d6¨³D&´d0
(2)XµX(12!´d¶·OP¸n ¹"#º»¼½n ¹"#
(3)¾¿X(e12 ¹ÀÁ +Â12OP!ÃÄÅÀÆ~ÃÄqÇ1
2
(4)ÈÉX(12 ¹ÀÁÊqËÌÍXÎeOP
¶e12ÀÁÊq
ÇÏÐ12!ÑÒËÌÓÔ·8Î(
Õ9ÖÒ×N
12 &Ø/eÙI0¬ÚI®Û!SQL>Ü]ÝÞÌÃÄ>ÜHI
ßà¨WHI&ß^ÊHIÔ7<8HI"#Õ áâã.0¹
6¨´d6¨´d^¶12(6ÍÝ>ÜI012åæ6çèACID
éê°±XX¾¿X4ÈÉX(
§¨ ëE
MNOP ì¶!íîïð()ìñòóÎsOPeOP
Ôôõì12ÎsOP!ö÷(ø.ñòHIùHI Ôús4Îû
¹!OPüýOP!X(
ùë ¼OPñòHI!¤þ6!ÿ
,
!"#$%&'
()%*+,
-.
/0 123 45
6 786
9:;<=>?***@A9:>
B3<=ACDEF%8G!7HI8JK%L+MN<=
OPQ,
<=RSA!C8TUV8%
TW%XY<=%ZP*[\/08]^_`a
bc
-deJfV8Qg
?***@3AQgh%ijYkCelh!m%nI?***@MN$elo%p$
qijY%
rsC
TV
MNijY
tZPCu*^v?@w
Axyz{nI
%|}?@~_y
9:A >v9:hv>
B3 AC%SQLAK% AxC
N o MNvjxy
SQL,^v fe
SQL
yMNvC hv :.
s¢%v>7]%£A9:>
B3s¢ CDp¤%Qg8
¥%¦s¢§MN¨v] ©
%rs]ª1«
¬®¯°o±%²³*xyQg´0±µ¶ MN·¸¹y%
s¢MNAºC%
s¢K»$eWTUAVW£A]¼½"
³¾%©¿K|ÀO "
¥%ÁÂÃÄ
ÅRÆÇIÈÉÊË?
B3ÍCÊË31NFAÎÏ%ÐXÏÑÒyÎÏG!ÐXÏ*MÓÈÔ
ÍÕÊË32NFAÖ³%×CÏÑÒyÖ³!×C@ØÙ®Ú%×CÏÔ
ÍÉÊË33NFAÛÜÝÞÏ%ÑÒÙßÅÛÜ*+à)ÛÜá¯h]yÛ
Üâ!ÝÞ
ÊË£3
3
MNãä_¼å
ÝÞ^_-.ÚæÄ
£:èQgxyV8
éê¼åë_mìO í_mì-î
s¢
ïÊË3
:MN¼å8_éêMN-ð_
s¢
£:
ÝÞNñ
òS
_ZPxy-V%0ó
9:A/08>9:A<=?
B3/08A0ôõ%8SQLoCé öC8<=AqCT÷
/08ø%8<=0ô*õ
¥oACE8
ùú<=%?
B3û1<=+üdvý%û2<=^vý+NVDþ¿ÿ3
4X
NULL!"#$
%&NULL'()*+UNKNOWN,-.:01*+2345. NULL'()6:.
89:;<=>(NULL) ?1***@68)A(NULL)BC9:DEFGH
IJK(%L
MNISNULLOBCNULLPQ
RSTUSVWXYZ[
RSTUSVWXYZ
\&
RS-^_`abcD1defD1# 2
US-*USg*RSDUShidefDhi2)
WX-j3kldef)Dmhid(2)
nN&
RS-NOopqr
US-NOVst*uvwN
WX- xyz{|}
(&
RS-RS~d(
US-(*hid(US
WX-(*hid(^WX
hiN!"Oo*3k~ )
%&CheckD0F
*\DNOj)
hiNO
*3k )Dm'F*
\D'h<F
SQL¡¢£¤d¥[(§¨©a)
(1)Where«¢¬&where*®¯°±²FstWherea³´Dµhi¶
·¸¹º»bca³°±²FWhere«¢¼½.HAVING¹¾
(2)NEXISTS¿ÀINTNNOTEXISTS¿ÀNOTIN
(3)ÁÂFWXGMNÃÄ
(4)ÁÂFWXGMNISNULLVISNOTNULL:.
(5)yzBC£¤DÅÆ»ÁÂÇ*ÈÉDÊËÅÌÍFwhereÎorderbyÏÎ
GuWX
(6)ÅÆ»ÁÂFwhere«¢¬3kBCnull)PQDÐÑÒÓÔXÕÖ×MNW
XØBCÇ*ÈÉ
(7)ÅÆ»ÁÂFwhere«¢¬3kBC*ÙÚÛnD'ÒÓÔXÕÖ×MNWXØ
BCÇ*ÈÉ
SQL¡¢¬TÜÝ«yzDA'ßÜÝ«yzDd!"YZ[
%&«yz&àáFstyz¬yzâ
«yzãâäåDØæç«yz¡¢âUåyz(ãâRyz)
Çå«yzhiè éêDëÜÝ«yzVßÜÝ«yz
(1)ßÜÝ«yzìUåyz«yzD«yzíîïCðDïCqñ¾Ò)ò
óôUåyz
(2)ÜÝ«yzïCõöìUåyzDUåyzïCCD«yz÷ïCð
øßÜÝ«yz9ÜÝ«yzùúx
charVvarcharYZ[
%&ûüêýDvarcharÑhþüêýD0ÿ
char(M)
M
M,MySQL
!"#$%.' ()*+,-./$01!"#2345)
varchar(M)
789:;<=>
1?***@A
(CDEL+1).
varcharFGHI
#J FKLMNOLPQ2.#JPR3ST UVWXYZ[\3.]Q
#^YZ#J
CharFHI
YZ_`abF(md5 cde g) MhiF#J(jEvarchar
klmn!o?@#J) SGpqrSTF#J STst 0uvwxFyz
{|0uYZ[\ }FS9io~
MySQL
Mysql,myisaminnodb
!"#!$%
&'()*+,-./0123(45 6
789:;<=>9"#9$%
"#?***@ABC
MylSAMDInnoDB,HEAPDBOB,ARCHIVE,CSVE
MylSAM FGDHIDJK4LMNO CPQ &'7E><
InnoDB &'DRSETUD"#6I VWX9 &'YZ[E
MySQL"#\.]^_`abcde=fg,
h3ijklmnopq
"#\tuvwxy"#z{|g}~join
b. "#?@[
\N
d."#gM
e /memcached,apeE
f. ¡F¢£
g.¤SQL /SELECTxFROMTABEL¦SELECTfield_l,field_2,
field_3FROMTABLE.
§9¨g©ª«¬®n¯°±²³´ µ¶
g`3¶·q
a.¸¹º» ¼Q&½¾µ¶g
"#\µ¶
c,¿ÀRyµ¶ÁÂ7ÃÁ>/ÄÅÃÁ
d.-.ZÆÇÈ
e.É v¨
f.ÉÊË`3ÌÆͲµ¶gAΧUÏ6op
ÐÑÏ6SQLop?:.
(1)Ó¸
eMySQL¦ÔÕÖA×ØMylSAMInnoDB,ÙØÚAÛAÜ
MylSAMCÝÞ9gßà§A9g-.$ ás âãäå
ÝÞupdateØ æØÚ çè±éÏê:ë NÏêÚì°-.í
îN-.ïF àðMylSAM§SELECTCOUNT(x)ñ?3ë òLì/
InnoDBóô Ø
õö§C!ð /MylSAM÷
ø ß ð&'''6" ;-./01ûü +oý $þÿ
(2)
!" #$% &'"()!*+( -.&
/0&)
23
4567(89: INT;<=>
: MEDIUMINT,SMALLINT?@
TINYINT"ABC$%DEFGHIJ
: DATEG DATETIMEKL
MN
DOFGPQRQSTUJ
(3)VWXYZX[
X[\E]^6@_=>?@`$%aD&b
(c DdG"Ae ;
<WX
******@VghiX[
jkDGWX***@lmn
2ohipm
X[
(4)qr: Selectxstuvw
23xy6"zL {\|
$%D
t}~WEB}~@i}~
"Z
:DGxy&p
OEG x/
0^O
_;
(5): ENUM******@VARCHAR
ENUM***@ke# ¡a¢£¤
g¥¦***@TINYINT,§g¨&¤©ªV
« ¬;
;<C®!&zL¯M°±²$
³´µ¶·µ¸
¹º» C¼½@(¾|¿^
23
Do: ENUME@
VARCHAR
(6)À: NOTNULL
jkD( Á´ ÃÄ: NULL½
Dod@ÅD¥NOTNULLo
NULLg¢FGƨUJ
\|
aDÇÈ ÉIÊ
DËÌ"ÍÎMN
u\E@-D6E: NULL+
Ï¢ÐÑ@ÁÍÎ
ÒÓ"(CÐÑÔ
DFG:
NULL½
(7)¿^ÕÖ&"#
$%&bp×@''¿^ÕÖ"
Ú &"ÛÜV@''static"?
"fixed-length"²$
&b7($Ô
VARCHAR,TEXT,BLOB.'G
DÝÞ+gb C
23 &6E@''¿^ÕÖߺ&à+
¬
MySQL[
â" ãä å;æ8:.
¿^ÕÖ&"³
ÃVMySQLWçL"#C
ÃV C¿^ÕÖ@Áèé
êëÔ ìí
îïv¼ðNO"Á#$%E@^Õ
23
ñ
òGóÔô
FGËÌóõ=>
\|
¿^ÕÖ&OèéÛö¦÷hEø
`ùú @
¿^ÕÖ"û
üCUJ
ÃV^ÕýþD E
ÿ
!"#$%&'(SQL)* (+,
-./01 234510
678(7801
9:;<=>?@
A BC
DE'%
-FGA
645AHIJ
9KL23MNOPQRSTUV
WW XYZ[\]^ _`a bcZdeAfghij Zkldmn
oKLGApqrsh tu:vZ sGwxA Xyz{|}~
+, ]!p
B+ h B+
zG InnoDBxy
z./ ¡+,
¢`a£+,¤¥¦./
M§¨LIKE)* ©ª«
0R)*¨IOJ./+,
6°±no²8³ ´ varcharZGµ,¶·ldm¸³¹int±º
SQL)*
orderby»¼!
alter23e½ss:.
insertpdelete¾¿
ÀÁ
MySQL
ÂÃJÄMÅÆ_sÇÈ ÉÊÅÆË:ÌÍÎÆÏÐÑx |ÒÓÒÔ
SQL)*Õ+,
-Ö
6£
9×Ø
sqlÙÚÛ
ÜÝÞ ßàáµ âãÞx
sqlÙÚâã
äåæç¡
èéêëìí
îïGð¶ñò./òð¶
ìíóôõ
c¦
1.öTÑ÷/øFùú 2ld45ûüøFýg 23wøF£NOTNULL,þ '
‘'
ENUM
2.
OIN)
3.
(UNION)
4. !"
5.#$ %& !"
6.
'()%&#$
7.*+,
8.%&-.:.
0123mysql4)+,)5()67+,)+,
8)9:;<=>?***@ABCDEFGHIJ
+,K7LMNOInnoDB:; P+,K QR7STUVWJ)XYZ[\9
:; ]^W_`,
ab
7c+d1ef(gKEYhINDEX$i+,J67jKkl9:;mnop
7c+,qrs+,:;tZ[uvwxy=z${S:;t|}Z[~q
w, S:;t+,
f(gUNIQUEX$i 7S67+,
K)67+,:;_`67
5()K7LM67+,)7 4}=$i7S5(+,)5(
677
_`)
f(gPRIMARYKEY
+,S:;t)xINDEXcoiumnA,columnB+,)K+,
+,:;op)K ¡¢£¤¥¦§¨ op)© ª«
¬F® )¯°®+,NO
:;<4 K?@
transactionK® 7S1±7T>²:;<®xyT4^W®³U
´)µ¶ U´)· }>7S®¸¹) U´xy^W®ºU) µ
»)¼½¾|®
^W¼¿:;<ÀÁxy7S®¸¹)µ |ÂÃ) ^
W®AB³|ÄÅACIDÆM)ÇÈÉ7ÊËÌ
ÍÎXSSÏÐÑÒxÓÔÕÒ
xssKÖ×ØÙÏÐ)ÚÛKÜ
Ö×ØÙÝÞ7SMßàá⪫ÏÐãäåØÙ,
æçÜ
èéActiveXêOª«ër«
htmlspecialcharsì:9»íîÀ«ïð) gñò]IMñóôõ&
SQLö¤ÝÞ÷øÇ©ÒxÓÔÕÒ
SQLö¤÷øÇ©ùÁ²úûïÁ4örüýFsql-.þ9MgñÀ«ïð)
ÿ
POST GET
sql
SQL
!"#$%& magic_quotes_gpc magic_quotes_runtime(#
sql)*+addslashes,sql-.
Sql/01 2345678 978
:;sql& <=> update?insert?delete?select?x?
***@ABCD EF GHIJKLM3 EFNBOP QRGHKS2TUVW :.
Php"#$%&(#register_globalsXoff,<Y
Z
[\]^_`K23abcdefg]^_`Kh]^_`0Wij$%&
XD&kEFlmnokABpqrst(uv
EFpqwxy z{|date,time|enum,char>varchar>blob,text
wx}~AEpqKi ,pqKEpqKykABpqK
wxlm+ ABpq
)
Datatime:YYYY-MM-DD))KXWK+8Ek
Kdatatimepq)<
Timestamp:)K+4EK1970-1-1 U2038-1-19,¡¢
N£¤¥¦§k)K¨©aª« AB¬)®¯k¬timestamp«k°
Date:r±iv+kEA²*+E.3³K*+date´µ33
EKi¶·K¸¹+i)ºA,iku»
Time:) ¼kAB
½:23*+Epq¿i)ABr²E+kKa,
ÀÁ:¹+ikºAv
*+inti)2Â*+timestamppq
L¤<ÃqABCÄÅKÆ7ÇÈM3 ÉÊKËÌÍÎ
<Æ7 ÏÐÑ
a?Æ7 Ò ÓÔÕ
Ö×ØÐABD& Q§_`K
@ÙÆ×Ú
ÛÜÝÞÆ7KßàABCD&áAB ÝÞ
â×D Dã äå
*+æç èPé,ABÙÆ)K¡êë³Àì&æç èP )
b?Æ7LABCÃí îïðñÓÔÕ
îïðñ
ÛÜÆ7 òóÆ7µ3ôõ)Kö)÷øAB ùâÄùâúÆ7µ3+st
K2ûDµ3+ABKáÆ7üµ3+stúÈLD,ù?Zh?
)ýÆ7ü3¯þòóKöÿ
c
!"#$%&'(.
*+,-&'(
d ./01234
56"#789:;<=>?***@ABCD<E34 :.
56GHIJE34EBKLM&'NtextO
PQMySQLR7MylSAMSInnoDBTH
TH6UVR?+GWXUYZ[\]^ _`:\]^Xb6E
c3XR
InnoDBdMylSAMTHe
InnoDB\]^ef+ghOLTPOnlineTransactionProcessing,ijklmnK
go EXpqrstuACIDjk\]^BDBpqtujk\]^Ev
wxyz{n
GWe
|}~ tuEtujkEtu{E~
Xtumvcc }~
MylSAM\]^eXMySQLK\]^Ef+ghOLAPOnlineAnalytical
Processing,ilmnKgo
GWe
3tujkE~
Xtu{Y ~EtuSL
E3
MySQL dTH
./X e ¡¢£¤¥¦E§X¨3 ©ª«ZE¬q
®`¯S°q7®`¯±²
X³«Z E´µq«Z¶·¸¹º«Z`¯E3¹º«Z`
¯3»¸¼½¾¿7EÀ³±²}
U½¾¿73ÁÂùº«Z}EcÄÅ»ÂÃÆ Ç=Èq7
®}EÉÊË01´ÌÍÎ
ÆEÇES
ÆEÏÍÆEÆ
fEÆ7®`¯Ð»¸¼½¾¿7E56Ñ
Ç7Ò±²`¯EÓÔ+ÕÖEÇ×5oÑ&'A NULLØÙÚ Ç
EÏÍÇEÇ
fEÇ7®`¯Ð»¸¼½¾¿7 ÆSÇÛ
ÜÝEMySQLÞßÅ3tu
¸ÊË (MySQLR\]^àÍNÖe3T
á!n
MylSAM> Merge MemoryHeap Example,
Federated,
âãq^
Myql7jkäåæçèQ:.
jkX éêëqR-<EÉ+/ì+/3ìEXq3Ûí
îïðEjkäåX¨ñjkòwró5Rôõö÷
+øùúûR7Èq3øùEü¾§ý3XqjkþEÿ
,
!"#,
$%&'()*+,-./012!3)
4
5678 !"#9 :;!
127<
SQL=>?***@ABCDEFCD5AGHIJKLE
MNSQL=>?***@OP/Q(DDL)ROPHI(DML),OPHI(DCL)4OPST(DQL)
UCD(
OP/QNCreateTable,AlterTable,DropTable,Craete/DropIndexV
OPHINSelect,insert,update,delete,
OPHINgrant,revoke
OPSTNselect
WXYZ?***@AGE
MNOPWX(DataIntegrity) [OP!X(Accuracy)4\X(Reliability)(
]0^_U`N
1)abWXNc/!Fde
f!ab(
2)gWXN [
!hijklmno/!OP`pYZq
YZr?***@stuvR
wxVc/(
3)yzWXN [{!|JKL4}JKL!OP~ !OP!
XOP Q!OPeOP
(
4)/Q!WXN!JOPPq~!6Go
!YZ(/Q!WX mo/JOP!YZ,m
b~ijkl!>Q6¡(
¢J!YZN?***@hYZ(NOTNULL(¤¥YZ))4YZ(PRIMARYKEY,foreign
keyRcheckRUNIQUE)?
§¨ 12E©qoXE
MN12N h!OPHI OP~!ª«¬®¯(
12oXN:.
(1)°±XN]²X126¨³D&´d6¨³D&´d0
(2)XµX(12!´d¶·OP¸n ¹"#º»¼½n ¹"#
(3)¾¿X(e12 ¹ÀÁ +Â12OP!ÃÄÅÀÆ~ÃÄqÇ1
2
(4)ÈÉX(12 ¹ÀÁÊqËÌÍXÎeOP
¶e12ÀÁÊq
ÇÏÐ12!ÑÒËÌÓÔ·8Î(
Õ9ÖÒ×N
12 &Ø/eÙI0¬ÚI®Û!SQL>Ü]ÝÞÌÃÄ>ÜHI
ßà¨WHI&ß^ÊHIÔ7<8HI"#Õ áâã.0¹
6¨´d6¨´d^¶12(6ÍÝ>ÜI012åæ6çèACID
éê°±XX¾¿X4ÈÉX(
§¨ ëE
MNOP ì¶!íîïð()ìñòóÎsOPeOP
Ôôõì12ÎsOP!ö÷(ø.ñòHIùHI Ôús4Îû
¹!OPüýOP!X(
ùë ¼OPñòHI!¤þ6!ÿ
,
!"#$%&'
()%*+,
-.
/0 123 45
6 786
9:;<=>?***@A9:>
B3<=ACDEF%8G!7HI8JK%L+MN<=
OPQ,
<=RSA!C8TUV8%
TW%XY<=%ZP*[\/08]^_`a
bc
-deJfV8Qg
?***@3AQgh%ijYkCelh!m%nI?***@MN$elo%p$
qijY%
rsC
TV
MNijY
tZPCu*^v?@w
Axyz{nI
%|}?@~_y
9:A >v9:hv>
B3 AC%SQLAK% AxC
N o MNvjxy
SQL,^v fe
SQL
yMNvC hv :.
s¢%v>7]%£A9:>
B3s¢ CDp¤%Qg8
¥%¦s¢§MN¨v] ©
%rs]ª1«
¬®¯°o±%²³*xyQg´0±µ¶ MN·¸¹y%
s¢MNAºC%
s¢K»$eWTUAVW£A]¼½"
³¾%©¿K|ÀO "
¥%ÁÂÃÄ
ÅRÆÇIÈÉÊË?
B3ÍCÊË31NFAÎÏ%ÐXÏÑÒyÎÏG!ÐXÏ*MÓÈÔ
ÍÕÊË32NFAÖ³%×CÏÑÒyÖ³!×C@ØÙ®Ú%×CÏÔ
ÍÉÊË33NFAÛÜÝÞÏ%ÑÒÙßÅÛÜ*+à)ÛÜá¯h]yÛ
Üâ!ÝÞ
ÊË£3
3
MNãä_¼å
ÝÞ^_-.ÚæÄ
£:èQgxyV8
éê¼åë_mìO í_mì-î
s¢
ïÊË3
:MN¼å8_éêMN-ð_
s¢
£:
ÝÞNñ
òS
_ZPxy-V%0ó
9:A/08>9:A<=?
B3/08A0ôõ%8SQLoCé öC8<=AqCT÷
/08ø%8<=0ô*õ
¥oACE8
ùú<=%?
B3û1<=+üdvý%û2<=^vý+NVDþ¿ÿ3
4X
NULL!"#$
%&NULL'()*+UNKNOWN,-.:01*+2345. NULL'()6:.
89:;<=>(NULL) ?1***@68)A(NULL)BC9:DEFGH
IJK(%L
MNISNULLOBCNULLPQ
RSTUSVWXYZ[
RSTUSVWXYZ
\&
RS-^_`abcD1defD1# 2
US-*USg*RSDUShidefDhi2)
WX-j3kldef)Dmhid(2)
nN&
RS-NOopqr
US-NOVst*uvwN
WX- xyz{|}
(&
RS-RS~d(
US-(*hid(US
WX-(*hid(^WX
hiN!"Oo*3k~ )
%&CheckD0F
*\DNOj)
hiNO
*3k )Dm'F*
\D'h<F
SQL¡¢£¤d¥[(§¨©a)
(1)Where«¢¬&where*®¯°±²FstWherea³´Dµhi¶
·¸¹º»bca³°±²FWhere«¢¼½.HAVING¹¾
(2)NEXISTS¿ÀINTNNOTEXISTS¿ÀNOTIN
(3)ÁÂFWXGMNÃÄ
(4)ÁÂFWXGMNISNULLVISNOTNULL:.
(5)yzBC£¤DÅÆ»ÁÂÇ*ÈÉDÊËÅÌÍFwhereÎorderbyÏÎ
GuWX
(6)ÅÆ»ÁÂFwhere«¢¬3kBCnull)PQDÐÑÒÓÔXÕÖ×MNW
XØBCÇ*ÈÉ
(7)ÅÆ»ÁÂFwhere«¢¬3kBC*ÙÚÛnD'ÒÓÔXÕÖ×MNWXØ
BCÇ*ÈÉ
SQL¡¢¬TÜÝ«yzDA'ßÜÝ«yzDd!"YZ[
%&«yz&àáFstyz¬yzâ
«yzãâäåDØæç«yz¡¢âUåyz(ãâRyz)
Çå«yzhiè éêDëÜÝ«yzVßÜÝ«yz
(1)ßÜÝ«yzìUåyz«yzD«yzíîïCðDïCqñ¾Ò)ò
óôUåyz
(2)ÜÝ«yzïCõöìUåyzDUåyzïCCD«yz÷ïCð
øßÜÝ«yz9ÜÝ«yzùúx
charVvarcharYZ[
%&ûüêýDvarcharÑhþüêýD0ÿ
char(M)
M
M,MySQL
!"#$%.' ()*+,-./$01!"#2345)
varchar(M)
789:;<=>
1?***@A
(CDEL+1).
varcharFGHI
#J FKLMNOLPQ2.#JPR3ST UVWXYZ[\3.]Q
#^YZ#J
CharFHI
YZ_`abF(md5 cde g) MhiF#J(jEvarchar
klmn!o?@#J) SGpqrSTF#J STst 0uvwxFyz
{|0uYZ[\ }FS9io~
2022年MySQL面试题和答案 来自淘豆网www.taodocs.com转载请标明出处.
相关文档 更多>>
非法内容举报中心
相关标签
最近更新
- 高中地理必修二城市与环境练习题 (2)
- 安全员的述职报告
- 《培训《销售》课件
- 大班安全教案食品安全
- 14new第02章--财务管理的基础观念——货币时..
- 《循环结构算法》课件
- 《猪的考绩》课件
- 《多种多样的磁铁导学案-2023-2024学年科学..
- 肝细胞周期调控机制的研究
- 我的学校作文600字初中（9篇）
- 医药制造业政策法规与市场准入
- 人道关怀的作文800字9篇
- 周末美好的句子(34条)
- 老师新学期走访学生家与家长沟通记录范文收..
- 形容老师熬夜工作的句子通用53条
- 大扫除日记6篇
- 高淳美丽乡村示范区规划探索的开题报告
- 高压氧对大鼠脑出血后脑消肿的影响及机理研..
- 高中英语合作学习阅读教学模式对学生学习动..
- 骨赘成骨潜能的初步研究的开题报告
- 马克思主义伦理学视野下道德法律化研究的开..
- 《同分母分数加、减法》教学设计（通用6篇）..
- 江西景德镇的导游词13篇
- 申请行政听证申请书模板7篇
- 高速接缝式自动包装机
- 3、我也能发明活动方案
- 老挝语-中文对照发音(共32页)
- 金属探测器课程设计报告
- 《中医诊断学》课程标准
- 医患沟通的一些体会 PPT幻灯片