Redis键值结构设计

た 入场券 2022-05-30 04:23 234阅读 0赞

和MySQL数据库关系表的设计不同 <这篇文章是网上已有的加以总结>

用户登录系统

记录用户登录信息表

  • MySQL








    1 mysql> select * from login;







    2 +————-+————————+——————-+——————————-+







    3 | user_id | name           | login_times | last_login_time     |







    4 +————-+————————+——————-+——————————-+







    5 |       1 | fk             |           5 | 2013-09-26 00:00:00 |







    6 |       2 | zhangsan       |           1 | 2013-09-25 00:00:00 |







    7 |       3 | zhaokuangyin   |           2 | 2013-09-01 00:00:00 |







    8 +————-+————————+——————-+——————————- 
  1.    其中:user\_id->主键(可自增), login\_times->每次登录自增, last\_login\_time->当前时间
  • Redis
    key <表名:主键名:列名> # 一般用冒号作为分隔符
    value <列值> 
  1. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  2.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  3.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  4.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">01</code></td> 
  5.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:1:login_times 5</code></td> 
  6.   </tr> 
  7.  </tbody> 
  8. </table>
  10. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  11.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  12.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  13.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">02</code></td> 
  14.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:2:login_times 1</code></td> 
  15.   </tr> 
  16.  </tbody> 
  17. </table>
  19. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  20.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  21.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  22.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">03</code></td> 
  23.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:3:login_times 2</code></td> 
  24.   </tr> 
  25.  </tbody> 
  26. </table>
  28. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  29.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  30.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  31.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">04</code></td> 
  32.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  33.   </tr> 
  34.  </tbody> 
  35. </table>
  37. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  38.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  39.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  40.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">05</code></td> 
  41.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:1:last_login_time 2013-09-26</code></td> 
  42.   </tr> 
  43.  </tbody> 
  44. </table>
  46. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  47.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  48.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  49.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">06</code></td> 
  50.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:2:last_login_time 2013-09-25</code></td> 
  51.   </tr> 
  52.  </tbody> 
  53. </table>
  55. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  56.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  57.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  58.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">07</code></td> 
  59.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:3:last_login_time 2013-09-01</code></td> 
  60.   </tr> 
  61.  </tbody> 
  62. </table>
  64. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  65.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  66.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  67.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">08</code></td> 
  68.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  69.   </tr> 
  70.  </tbody> 
  71. </table>
  73. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  74.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  75.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  76.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">09</code></td> 
  77.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:1:name&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"fk"</code></td> 
  78.   </tr> 
  79.  </tbody> 
  80. </table>
  82. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  83.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  84.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  85.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">10</code></td> 
  86.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:2:name&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"zhangsan"</code></td> 
  87.   </tr> 
  88.  </tbody> 
  89. </table>
  91. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  92.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  93.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  94.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">11</code></td> 
  95.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET login:3:name&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"zhaokuangyin"</code></td> 
  96.   </tr> 
  97.  </tbody> 
  98. </table>
  100. 这样, 知道主键 user\_id后就可以get到所有内容了, \*\*\*但是一般是通过name访问, 所以需要name到主键的映射.  
  103. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  104.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  105.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  106.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">1</code></td> 
  107.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:fk:id"</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code></td> 
  108.   </tr> 
  109.  </tbody> 
  110. </table>
  112. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  113.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  114.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  115.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">2</code></td> 
  116.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:zhangsan:id"</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">2</code></td> 
  117.   </tr> 
  118.  </tbody> 
  119. </table>
  121. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  122.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  123.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  124.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">3</code></td> 
  125.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">SET&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:zhaokuangyin:id"</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">3</code></td> 
  126.   </tr> 
  127.  </tbody> 
  128. </table>
  130. 这样, 知道name就可以get到所有内容了.  
  131. (1)用户登录操作如下:
  133. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  134.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  135.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  136.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">01</code></td> 
  137.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># -*- coding: utf-8 -*-</code></td> 
  138.   </tr> 
  139.  </tbody> 
  140. </table>
  142. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  143.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  144.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  145.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">02</code></td> 
  146.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  147.   </tr> 
  148.  </tbody> 
  149. </table>
  151. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  152.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  153.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  154.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">03</code></td> 
  155.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">from</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">redis&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">import</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">client</code></td> 
  156.   </tr> 
  157.  </tbody> 
  158. </table>
  160. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  161.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  162.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  163.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">04</code></td> 
  164.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">import</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">time</code></td> 
  165.   </tr> 
  166.  </tbody> 
  167. </table>
  169. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  170.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  171.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  172.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">05</code></td> 
  173.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  174.   </tr> 
  175.  </tbody> 
  176. </table>
  178. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  179.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  180.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  181.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">06</code></td> 
  182.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">client.Redis()&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 默认</code></td> 
  183.   </tr> 
  184.  </tbody> 
  185. </table>
  187. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  188.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  189.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  190.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">07</code></td> 
  191.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># r = client.Redis(self, host='localhost', port=6379, db=0, password=None, socket_timeout=None, connection_pool=None, charset='utf-8', errors='strict', decode_responses=False, unix_socket_path=None)</code></td> 
  192.   </tr> 
  193.  </tbody> 
  194. </table>
  196. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  197.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  198.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  199.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">08</code></td> 
  200.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># r = client.StrictRedis.from_url("redis://127.0.0.1:6381")</code></td> 
  201.   </tr> 
  202.  </tbody> 
  203. </table>
  205. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  206.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  207.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  208.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">09</code></td> 
  209.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  210.   </tr> 
  211.  </tbody> 
  212. </table>
  214. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  215.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  216.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  217.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">10</code></td> 
  218.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">name&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"fk"</code></td> 
  219.   </tr> 
  220.  </tbody> 
  221. </table>
  223. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  224.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  225.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  226.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">11</code></td> 
  227.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  228.   </tr> 
  229.  </tbody> 
  230. </table>
  232. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  233.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  234.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  235.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">12</code></td> 
  236.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 根据name获取user_id</code></td> 
  237.   </tr> 
  238.  </tbody> 
  239. </table>
  241. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  242.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  243.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  244.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">13</code></td> 
  245.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">uid&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.get(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:%s:id"</code>&nbsp;<code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">%</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">name)</code></td> 
  246.   </tr> 
  247.  </tbody> 
  248. </table>
  250. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  251.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  252.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  253.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">14</code></td> 
  254.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 自增用户登录次数</code></td> 
  255.   </tr> 
  256.  </tbody> 
  257. </table>
  259. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  260.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  261.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  262.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">15</code></td> 
  263.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">ret&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.incr(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:%s:login_times"</code>&nbsp;<code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">%</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">uid)</code></td> 
  264.   </tr> 
  265.  </tbody> 
  266. </table>
  268. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  269.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  270.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  271.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">16</code></td> 
  272.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 更新最后登录时间</code></td> 
  273.   </tr> 
  274.  </tbody> 
  275. </table>
  277. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  278.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  279.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  280.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">17</code></td> 
  281.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">ret |</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(255,20,147);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">set</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:%s:last_login_time"</code>&nbsp;<code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">%</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">uid, time.strftime(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"%Y-%m-%d %H:%M:%S"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">))</code></td> 
  282.   </tr> 
  283.  </tbody> 
  284. </table>
  286. (2)查看最近登陆的10个用户  
  287. ①MySQL  
  290. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  291.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  292.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  293.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">1</code></td> 
  294.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">select</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">*&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">from</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">login&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">order</code>&nbsp;<code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">by</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">last_login_time&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">desc</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">limit 10</code></td> 
  295.   </tr> 
  296.  </tbody> 
  297. </table>
  299. 如果当表很大时, 可以在last\_login\_time上建个索引, 当需要查看登录次数最多的用户, 又要在login\_tines上建索引...关系数据库不灵活性出现.  
  300. ②Redis  
  303. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  304.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  305.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  306.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">01</code></td> 
  307.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"""查看最近登录用户(显示最近xx条评论用这个比较合适)</code></td> 
  308.   </tr> 
  309.  </tbody> 
  310. </table>
  312. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  313.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  314.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  315.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">02</code></td> 
  316.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"""</code></td> 
  317.   </tr> 
  318.  </tbody> 
  319. </table>
  321. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  322.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  323.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  324.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">03</code></td> 
  325.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">N&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">10</code></td> 
  326.   </tr> 
  327.  </tbody> 
  328. </table>
  330. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  331.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  332.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  333.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">04</code></td> 
  334.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 把当前登录人添加到链表里(登录时就要操作)</code></td> 
  335.   </tr> 
  336.  </tbody> 
  337. </table>
  339. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  340.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  341.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  342.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">05</code></td> 
  343.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">ret&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.lpush(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:last_login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, uid)</code></td> 
  344.   </tr> 
  345.  </tbody> 
  346. </table>
  348. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  349.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  350.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  351.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">06</code></td> 
  352.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 保持链表只有N位</code></td> 
  353.   </tr> 
  354.  </tbody> 
  355. </table>
  357. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  358.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  359.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  360.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">07</code></td> 
  361.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">ret |</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.ltrim(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:last_login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">0</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, N</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">-</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># ltrim (l表示list, trim 一个list,从索引 0到N-1)</code></td> 
  362.   </tr> 
  363.  </tbody> 
  364. </table>
  366. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  367.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  368.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  369.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">08</code></td> 
  370.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;">&nbsp;</td> 
  371.   </tr> 
  372.  </tbody> 
  373. </table>
  375. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  376.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  377.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  378.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">09</code></td> 
  379.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 获得最新登录人的id</code></td> 
  380.   </tr> 
  381.  </tbody> 
  382. </table>
  384. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  385.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  386.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  387.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">10</code></td> 
  388.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">last_login_list&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.lrange(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:last_login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">0</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, N</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">-</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)</code></td> 
  389.   </tr> 
  390.  </tbody> 
  391. </table>
  393. \*\*\*使用sorted set类型更适合
  395. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  396.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  397.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  398.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">01</code></td> 
  399.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"""获取登录次数最多用户</code></td> 
  400.   </tr> 
  401.  </tbody> 
  402. </table>
  404. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  405.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  406.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  407.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">02</code></td> 
  408.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">使用sorted set类型更适合</code></td> 
  409.   </tr> 
  410.  </tbody> 
  411. </table>
  413. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  414.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  415.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  416.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">03</code></td> 
  417.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"""</code></td> 
  418.   </tr> 
  419.  </tbody> 
  420. </table>
  422. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  423.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  424.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  425.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">04</code></td> 
  426.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 把用户和登录次数统一存储在一个sorted set里</code></td> 
  427.   </tr> 
  428.  </tbody> 
  429. </table>
  431. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  432.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  433.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  434.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">05</code></td> 
  435.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># ZADD key 权值 member,python中zadd(key, score, member)</code></td> 
  436.   </tr> 
  437.  </tbody> 
  438. </table>
  440. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  441.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  442.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  443.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">06</code></td> 
  444.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.zadd(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">5</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)</code></td> 
  445.   </tr> 
  446.  </tbody> 
  447. </table>
  449. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  450.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  451.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  452.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">07</code></td> 
  453.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.zadd(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">2</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)</code></td> 
  454.   </tr> 
  455.  </tbody> 
  456. </table>
  458. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  459.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  460.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  461.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">08</code></td> 
  462.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.zadd(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">3</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">2</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)</code></td> 
  463.   </tr> 
  464.  </tbody> 
  465. </table>
  467. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  468.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  469.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  470.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">09</code></td> 
  471.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 某个用户登录，需要额外维护一个sorted set</code></td> 
  472.   </tr> 
  473.  </tbody> 
  474. </table>
  476. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  477.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  478.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  479.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">10</code></td> 
  480.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 对该用户的登录次数自增1</code></td> 
  481.   </tr> 
  482.  </tbody> 
  483. </table>
  485. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  486.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  487.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  488.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">11</code></td> 
  489.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># ret = r.zincrby("login:login_times", 1, uid) &lt;-- 错误, 修正如下</code></td> 
  490.   </tr> 
  491.  </tbody> 
  492. </table>
  494. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  495.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  496.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  497.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">12</code></td> 
  498.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">ret&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.zincrby(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, uid,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># ***和redis官网命令的参数顺序是不一样的, zincrby(key, value, Δscore)</code></td> 
  499.   </tr> 
  500.  </tbody> 
  501. </table>
  503. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  504.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  505.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  506.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">13</code></td> 
  507.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,130,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;"># 获取登录次数最多的用户, 逆序排列取的排名第N的用户即可</code></td> 
  508.   </tr> 
  509.  </tbody> 
  510. </table>
  512. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  513.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  514.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  515.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">14</code></td> 
  516.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">login_times_list&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">=</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">r.zrevrange(</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">"login:login_times"</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">,&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">0</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, N</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">-</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(0,153,0);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">1</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">)</code></td> 
  517.   </tr> 
  518.  </tbody> 
  519. </table>
  • ing

Tag系统

tag信息 存储设计

  • MySQL
    两张表，一张book的明细，一张tag表，表示每本的tag，一本书存在多个tag。








    01 mysql> select * from book;







    02 +———+———————————————-+————————+







    03 | id   | name                          | author         |







    04 +———+———————————————-+————————+







    05 |    1 | The Ruby Programming Language | Mark Pilgrim   |







    06 |    1 | Ruby on rail                  | David Flanagan |







    07 |    1 | Programming Erlang            | Joe Armstrong  |







    08 +———+———————————————-+————————+







    09  







    10 mysql> select * from tag;







    11 +————-+————-+







    12 | tagname | book_id |







    13 +————-+————-+







    14 | ruby    |       1 |







    15 | ruby    |       2 |







    16 | web     |       2 |







    17 | erlang  |       3 |







    18 +————-+————-+

    假如要查找即是web又是ruby的书籍, 关系型sql语句是: 

  1. <table style="width:auto;margin:0px;padding:0px;border:0px;float:none;vertical-align:baseline;height:auto;line-height:1.1em;font-size:10pt;"> 
  2.  <tbody style="padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  3.   <tr style="border-top:0px;padding:0px;margin:0px;float:none;vertical-align:baseline;height:auto;width:auto;line-height:1.1em;font-size:10pt;"> 
  4.    <td style="border-width:0px;font-size:10pt;color:rgb(175,175,175);line-height:1.1em;padding:0px;margin:0px;float:none;vertical-align:top;height:auto;width:3em;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px .3em 0px 0px;margin:0px;border:0px;text-align:right;float:none;vertical-align:baseline;height:auto;width:2.7em;">1</code></td> 
  5.    <td style="border-width:0px 0px 0px 3px;border-left-color:rgb(108,226,108);font-size:10pt;line-height:1.1em;padding:0px 0px 0px .5em;margin:0px;float:none;vertical-align:top;height:auto;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">select</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">b.</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">name</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">, b.author&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">from</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">tag&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">as</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">t1, tag&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">as</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">t2, book&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">as</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">b&nbsp;</code><code style="color:rgb(0,102,153);padding:0px;font-size:10pt;margin:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;font-weight:bold;">where</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">t1.tagname =&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">'web'</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(128,128,128);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">and</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">t2.tagname =&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:#0000FF;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">'ruby'</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(128,128,128);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">and</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">t1.book_id = t2.book_id&nbsp;</code><code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;color:rgb(128,128,128);padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">and</code>&nbsp;<code style="font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:10pt;line-height:1.1em;padding:0px;margin:0px;border:0px;float:none;vertical-align:baseline;height:auto;width:auto;">b.id = t1.book_id</code></td> 
  6.   </tr> 
  7.  </tbody> 
  8. </table>
  10. 关系型数据库不太适合集合操作  
  11. [点击打开链接][Link 1]

  • Redis
    book表用普通kv存储








    1 SET book:1:name “The Ruby Programming Language”







    2 SET book:2:name “Ruby on rail”







    3 SET book:3:name “Programming Erlang”







    4  







    5 SET book:1:author “Mark Pilgrim”







    6 SET book:2:author “David Flanagan”







    7 SET book:3:author “Joe Armstrong”

    tag表用集合存储(因为要进行集合操作)








    1 SADD tag:ruby 1







    2 SADD tag:ruby 2







    3 SADD tag:web 2







    4 SADD tag:erlang 3

    相关操作(与,或,差 对应python set的&, |, - )








    1 # 既属于ruby,又属于web的书







    2 ruby_and_web_list = r.sinter(“tag:ruby”, “tag:web”)







    3 # 属于ruby,但不属于web的书







    4 ruby_not_web_list = r.sdiff(“tag:ruby”, “tag:web”)







    5 # 属于ruby, 或属于web的书







    6 ruby_or_web_list = r.sunion(“tag:ruby”, “       
  • 文章来源： http://blog.csdn.net/mirage520/article/details/25232133

发表评论

表情：
评论列表 （有 0 条评论，234人围观）

还没有评论，来说两句吧...

相关阅读

    相关 Redis键值设计

    丰富的[数据结构][Link 1]使得[Redis][]的设计非常的有趣。不像关系型[数据库][Link 2]那样，DEV和DBA需要深度沟通，review每行sql语句，也不

    墨蓝墨蓝/ 0 赞/ 84 阅读

    相关 Redis键值设计

    丰富的数据结构使得redis的设计非常的有趣。不像关系型数据库那样，DEV和DBA需要深度沟通，review每行sql语句，也不像memcached那样，不需要DBA的参与。r

    偏执的太偏执、偏执的太偏执、/ 0 赞/ 216 阅读