Download Zend Enterprise PHP Patterns

Transcript
C H A P T E R 1 0 N T H E M Y S Q L D A T A B A S E
&&&&&&&&&&&&&&&&&&&&&&&&&&&0*nks&&&&&&&&&&&&&&&&&&&&&&&&&&&
Beah`[j]ia6sknh`*?epu*@eopne_p
Iej[r]hqa6=^d]oe]W=ld]vapeY
I]t[r]hqa6Ì
Iej[hajcpd6I]t[hajcpd6.,
Ailpeao[kn[vanko60
Jqhho6,
=rc[r]hqa[kn[]rc[hajcpd65*,-50
Op`6JQHH
Klpei]h[beah`pula6R=N?D=N$.,%JKPJQHH
&&&&&&&&&&&&&&&&&&&&&&&&&&&1*nks&&&&&&&&&&&&&&&&&&&&&&&&&&&
Beah`[j]ia6sknh`*?epu*Lklqh]pekj
Iej[r]hqa60.
I]t[r]hqa6-,1,,,,,
Iej[hajcpd6.
I]t[hajcpd64
Ailpeao[kn[vanko6,
Jqhho6,
=rc[r]hqa[kn[]rc[hajcpd6/1,024*../2
Op`63./242*543,
Klpei]h[beah`pula6IA@EQIEJP$4%QJOECJA@JKPJQHH
1nksoejoap$,*,-oa_%
NTip There are a couple of caveats when running LNK?A@QNA=J=HUOA$%. The first one is that you cannot
take the result too literally while your data is still small. For example, the output recommended a r]n_d]n$//%
for the city name but decided that districts only go up to 20 characters.
A second caveat is that LNK?A@QNA=J=HUOA$% can be quite overzealous to recommend using ENUM and
SET data types. In the example we disabled ENUMs/SETs from being considered by adding two additional
arguments: LNK?A@QNA=J=HUOA$-(-%* See dppl6++`ar*iuomh*_ki+`k_+nabi]j+1*-+aj+lnk_a`qna)
]j]huoa*dpih.
Download at WoWeBook.Com
237