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