本文共 1208 字，大约阅读时间需要 4 分钟。
?????????
?????????????????????????????????????????????????
???????User??????????????????
- username?????- ??????????????
- password????- ?????????????
- id????- ??????????
????????
??InnoDB????????? username?????????????????? id????????????????????? ?????Result???????????????????
- id????- ??????????
- userid????- ???????????id??????????
- totalcount?????- ???null?????0
- wincount??????- ???????0
????????
totalcount??????null?????0???????? wincount????????????0?????????? ????????????? SQL??Game.sql???????????SQL?????InnoDB?????????utf8???????????
??????????
???????result? - id???int???????null?????
- userid???int?????????null???????
- totalcount?????int?????null?????0
- wincount?????int??????null?????0
- ??primary key???id??
- ??????fk_userid???user??id??
- ???????user?
- id???int???????null?????
- username???varchar???????null????50
- password???varchar???????null????50
- ??primary key???id??
- ???????unique_username???????????
????????
- ??InnoDB????????ACID???????
- username?????varchar??????????????
- id??????????????????????
- ??????0?????????
- ????????????????
???????????????????????????????????
- ??username??????????
- ?????password??????
- ??????????????????
???????????????????????????????????????????????????????????????????????????
转载地址：http://xdok.baihongyu.com/