MySQL???????????????
???????????? ???????[ 2016/12/26 10:46:16 ] ????????????? MySQL
????6????????
??????????????????????????????????????????????????????????????????????????????
???????磬???????????????????????????????????????????????????customerinfo???е?CustomerID???salesinfo????CustomerID???κ??????к??CustomerID??????????????????salesinfo?С?
????CREATETABLEcustomerinfo( CustomerIDINTNOTNULL??PRIMARYKEY(CustomerID))TYPE=INNODB;
????CREATETABLEsalesinfo( SalesIDINTNOTNULL??CustomerIDINTNOTNULL??
????PRIMARYKEY(CustomerID??SalesID)??
????FOREIGNKEY(CustomerID)REFERENCEScustomerinfo(CustomerID)ONDELETECASCADE)TYPE=INNODB;
????????????е????“ONDELETECASCADE”???ò????????customerinfo???е????????????????????salesinfo????????????????????????????????????MySQL??????????????????????????????????????????????InnoDB??????????????MySQL???????????????????????CREATETABLE????м???TYPE=INNODB?????????????
????7?????????
?????????????????????????÷??????????????????????????????????????????????????У???????????????а?????MAX()??MIN()??ORDERBY??Щ??????????????????????
??????????Щ??ν??????????
?????????????????????????Щ??????JOIN??WHERE?ж??ORDERBY?????????????????????????????????д?????????????ν????????????????ENUM????????????????????????????п???????
????????customerinfo?е?“province”..??Σ????????????????????????????????????????????п????????????????????????????????????????????????????????????ALTERTABLE??CREATEINDEX?????????????????MySQL??汾3.23.23??????????????????????????????MySQL???????FULLTEXT????????????????????MyISAM??????????????????????????????????????FULLTEXT????????У?????????ALTERTABLE??CREATEINDEX???????????????????????????????????????????FULLTEXT????????У???й????????????
????8????????????
???????????????£????????????????????????????SQL?????ò??????????????????????????е????á?
???????????????????????檔
?????????????????????????μ???б????????
??????MySQL3.23???????????????????????????????粻????????????????INT??κ?BIGINT??ν??б??????????????????????CHAR???????κ?VARCHAR??????ε???δ?С???????????????????б???
??????Σ?????????????????????????ú??????в?????
???????磬?????DATE?????????????YEAE()?????????????????????????е????á????????????????????????????????????????????????
???????????????????????????????????????LIKE????????????????????????????????????????????????????
???????????????????????е??????????
????SELECT*FROMbooks
????WHEREnamelike"MySQL%"
????????????????????????????????????????????????
????SELECT*FROMbooks
????WHEREname??="MySQL"andname??"MySQM"
???????????????????????MySQL????????????????????????????????????ò??????á?
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???mysql?????????????mysql????? distinct?÷?MySQL?н???????????з??Mysql?????????MySQL Cluster??δ????????????????ν?MySQL??????????300???????MySQL???Uber???????????????????MySql SQL??????????MySQL?????????????????λЧ?????SQL???Java???????:?????MySQL???????linux?°??mysql????MySQL ???????????????????binlog??MySQL????????????Щ??????MySQL???????Mysql???????JDBC?????mysql?????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????