{"id":159621,"date":"2020-09-24T02:13:19","date_gmt":"2020-09-23T18:13:19","guid":{"rendered":"http:\/\/4563.org\/?p=159621"},"modified":"2020-09-24T02:13:19","modified_gmt":"2020-09-23T18:13:19","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e4%b8%bb%e9%94%ae%e5%ad%97%e6%ae%b5%e5%90%8d%e5%8f%abid%e4%b8%8d%e9%a6%99%e4%b9%88%ef%bc%8c%e4%b8%ba%e4%bb%80%e4%b9%88%e9%9d%9e%e8%a6%81table-%e5%90%8did","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=159621","title":{"rendered":"\u6570\u636e\u5e93\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u53eb`ID`\u4e0d\u9999\u4e48\uff0c\u4e3a\u4ec0\u4e48\u975e\u8981`table \u540d+ID`\u3001`table \u540d\u7f29\u5199+ID`\uff1f"},"content":{"rendered":"
\n
\n
\n

\u6570\u636e\u5e93\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u53eb`ID`\u4e0d\u9999\u4e48\uff0c\u4e3a\u4ec0\u4e48\u975e\u8981`table \u540d+ID`\u3001`table \u540d\u7f29\u5199+ID`\uff1f <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : luxinfl <\/span> <\/i> 1<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u5927\u4f6c\u4eec\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u662f\u600e\u4e48\u5b9a\u4e49\u7684\uff1f\u96be\u9053\u4e0d\u53eb ID \u8fd8\u4f1a\u6709\u4ec0\u4e48\u597d\u5904\u4e48\uff1f\uff1f<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (100<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : kiracyan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8bed\u4e49\u66f4\u660e\u786e\u5427 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : alexmao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f53\u4f60\u6709 10 \u4e2a\u8868\u7684\u65f6\u5019\uff0c\u90fd\u53eb`ID`\u4f60\u8bb0\u5f97\u8fc7\u6765\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : laravel <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u5408\u4f5c\u7684\u5c0f\u4f19\u8fde id \u90fd\u6ca1\u6709 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lichao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd8\u6709\u7c7b\u4f3c\u7684\uff0c\u8868\u540d\u7528 t_User, t_Customer <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wangyzj <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @laravel #3 \u53c8\u770b\u5230\u8fd9\u4e2a id \u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : islxyqwe <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6709\u5916\u952e\u67e5\u8be2\u65f6\u952e\u540d\u80fd\u7edf\u4e00 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : luxinfl <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao \u4f60\u8bf4\u7684 10 \u4e2a\u8868\u4ec0\u4e48\u573a\u666f\uff1f\u5199\u67e5\u8be2 sql \uff1f\u7528\u522b\u540d\u4e0d\u884c\u9ebd\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : qq292382270 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8868\u591a\u4e86\u597d\u8ba4 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Rwing <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u662f\u7684\uff0c\u6211\u89c9\u5f97\u6ca1\u5fc5\u8981\uff0c\u4e0a\u8bf4\u7684 t_\u524d\u7f00\u4e5f\u6ca1\u5fc5\u8981\uff0c\u5f53\u521d\u63d0\u51fa t_\u524d\u7f00\u65f6\u662f\u4e3a\u4e86\u533a\u5206 view \u548c sp\uff0c\u73b0\u5728\u90fd\u4e0d\u7528\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : luxinfl <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @islxyqwe \u53ef\u662f\u6211\u4eec\u4e0d\u7528 id \u5f53\u505a\u5916\u952e\u5173\u8054\uff0c\u6211\u4eec\u90fd\u662f\u7528\u8868\u91cc\u9762\u5b9a\u4e49\u7684\u552f\u4e00\u4e1a\u52a1\u7f16\u53f7 code \u5173\u8054 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : luxinfl <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @qq292382270 \u6211\u4eec\u4e0d\u7528 id \u5173\u8054\uff0c\u6240\u4ee5\u6211\u662f\u9009\u62e9\u6027\u5ffd\u7565\u4e86\u9ebd <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : tabris17 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao \u90fd\u53eb id \u4e3a\u4ec0\u4e48\u4f1a\u8bb0\u4e0d\u4f4f\uff1f\u4f60\u60f3\u8868\u8fbe\u7684\u662f\u4e0d\u5b9c\u533a\u5206\u5427\uff0ct1.id AS t1_id \u4e0d\u53ef\u4ee5\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6bd4\u8f83\u4e0b where t1.id = t2.user_id \u548c where t1.user_id = t2.user_id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lichao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd <\/p>\n

    \u5f53\u7136\u662f where user.id = topic.user_id \u597d <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : qwerthhusn <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    xxx \u5bf9\u8c61\uff0c\u8868\u540d xxx\uff0c\u5b57\u6bb5\u540d xxx_id xxx_name xxx_???<\/p>\n

    \u8fd9\u6837\u505a\uff0c\u4e00\u4e2a\u662f\u6709\u4e9b\u5c5e\u6027\u50cf order name status \u8fd9\u4e9b\u53ef\u80fd\u662f DB \u7684\u5173\u952e\u5b57\uff0c\u6709\u65f6\u5019\u5de5\u5177\u6216\u8005\u4ee3\u7801\u9ad8\u4eae\u663e\u793a\u7684\u5f88\u5947\u602a\uff0c\u4f46\u662f\u57fa\u672c\u4e0a\u4e0d\u62a5\u9519
    \u53e6\u5916\u4e00\u4e2a\u539f\u56e0\u5c31\u662f\u8868\u8fde\u63a5\u7684\u65f6\u5019\uff0c\u4e24\u4e2a\u8868\u53ef\u80fd\u6709\u4e00\u6837\u7684\u5b57\u6bb5\uff0c\u9700\u8981\u8868\uff08\u522b\uff09\u540d\u70b9\u5b57\u6bb5\uff08\u5f53\u7136\u5e73\u5e38\u4e5f\u5e94\u8be5\u52a0\u4e0a\u522b\u540d\uff09 <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ztxcccc <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    user \u8868\u5982\u679c\u4e3b\u952e\u53eb user_id\uff0ctopic \u8868\u91cc\u7684\u7528\u6237\u5b57\u6bb5\u5c31\u8be5\u53eb topic_user_id\uff0c\u8fd9\u4e48\u5199 SQL \u4e0d\u53cd\u4eba\u7c7b\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ColinZeb <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd \u53c8\u4e0d\u662f\u4ee3\u7801\u751f\u6210\u5668\uff0c\u4e3a\u4ec0\u4e48\u53eb t1t2,user \u53ef\u4ee5\u7b80\u5199 u\uff0ctopic \u7b80\u5199 t\uff0c\u6240\u4ee5\u5c31\u662f u.id = t.userid <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : baobao1270 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53eb ID\uff1aORM \u81ea\u52a8\u6620\u5c04
    \u4e0d\u53eb\uff1a\u624b\u5199 SQL \u8fde\u8868\u67e5\u8be2\u65b9\u4fbf<\/p>\n

    \u770b\u4f60\u662f\u624b\u5199 SQL \u8fd8\u662f\u7528 ORM \u54af <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mebtte <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u79d1\u666e\u4e00\u4e0b, SQL \u6709\u4e2a AS \u5173\u952e\u8bcd <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f53\u7136\u6ca1\u5fc5\u8981\u4e86,\u5f00\u53d1\u4e86 n \u4e2a\u9879\u76ee,\u76f4\u63a5 ID,root-class,\u53cd\u800c\u5f00\u53d1\u6548\u7387\u66f4\u9ad8,\u5c01\u88c5\u8d77\u6765\u66f4\u5bb9\u6613,\u524d\u7aef\u5bf9\u63a5\u4e5f\u4e0d\u7528\u5173\u5fc3,\u7f29\u5199\u554a\u4ec0\u4e48\u7684\u81ed\u6bdb\u75c5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yogogo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8c01\u8bbe\u8ba1\u7684\u542c\u8c01\u7684\uff0c\u80cc\u9505\u4e5f\u4e0d\u4f1a\u662f\u4f60 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao \u4f60\u96be\u9053\u7528\u5b57\u6bb5\u7684\u65f6\u5019\u4e0d\u7528\u8868?\u60f3\u5b66\u4e60\u4e0b\u8fd9\u6837\u7684\u4e1a\u52a1\u573a\u666f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : alexmao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @THESDZ \u7528\u8868\u662f\u7528\u8868\uff0c\u4f46\u662f\u5982\u679c\u80fd\u533a\u5206\uff0c\u4e3a\u4ec0\u4e48\u4e0d\u533a\u5206\u5462\uff1f\u591a\u4e00\u70b9\u4fe1\u606f\u4e0d\u662f\u66f4\u52a0\u660e\u786e\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao \u65e2\u7136\u7528\u4e86\u8868,`table.id` \u548c `table.table_id`,\u4f60\u975e\u8981\u9009\u540e\u8005,\u7406\u7531\u662f\u8bed\u4e49\u66f4\u6e05\u6670? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : alexmao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @THESDZ \u5728\u4e00\u4e2a\u8868\u91cc\u53eb id\uff0c\u53e6\u4e00\u4e2a\u8868\u91cc\u653e\u8fd9\u4e2a id \u7684\u65f6\u5019\u53eb table_id\uff0c\u4e0d\u89c9\u5f97\u5f88\u4e0d\u89c4\u6574\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : netnr <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e2a\u4eba\u5f3a\u70c8\u63a8\u8350\u5b57\u6bb5\u6309\u8868\u7edf\u4e00\u52a0\u524d\u7f00 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jintianfengda <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5173\u6ce8\uff0c\u6211\u4e2a\u4eba\u662f\u503e\u5411\u4e3b\u952e\u5c31\u53eb id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : linxl <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ea\u8981\u9879\u76ee\u91cc\u7edf\u4e00\u53e3\u5f84\u5c31\u884c, \u5404\u6709\u597d\u5904\u5427.
    \u9664\u4e86 id, \u8fd8\u6709\u5f88\u591a\u5176\u4ed6\u5355\u8bcd\u4e5f\u662f\u5f88\u9ad8\u9891\u7684\u5b57\u6bb5\u540d, \u96be\u9053\u90fd\u8981\u52a0\u4e0a table \u540d\u5417 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : libracloud <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7528 rails \u4e60\u60ef\u540e\uff0c\u6211\u4ec0\u4e48\u90fd\u662f\u6309 rails \u7684\u6765\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao
    1. \u4e0d\u89c9\u5f97,\u89c4\u6574\u5e94\u8be5\u6307\u7684\u662f\u540c\u4e00\u5957\u6807\u51c6,\u800c\u975e\u540c\u4e00\u4e2a\u540d\u5b57.
    2. \u987a\u5e26:\u826f\u597d\u7684\u4ee3\u7801\u5e94\u8be5\u7b80\u4ecb\u7684\u540c\u65f6\u53ef\u4ee5\u81ea\u89e3\u91ca,`ID`\u5728\u5f53\u524d\u8868\u5c31\u662f\u4e3b\u952e,\u6ca1\u4eba\u770b\u4e0d\u61c2,\u800c`USER_ID`\u660e\u663e\u5c31\u662f`USER`\u8868\u7684\u4e3b\u952e
    3. `ID`\u4e00\u822c\u90fd\u6ca1\u6709\u4e1a\u52a1\u542b\u4e49,\u7edf\u4e00\u7684\u597d\u5904\u662f\u5728\u5904\u7406\u7edf\u4e00\u7684\u975e\u4e1a\u52a1\u903b\u8f91\u7684\u65f6\u5019,\u4e0d\u9700\u8981\u8003\u8651\u4e00\u4e9b\u5f02\u5316\u7684\u95ee\u9898,\u4ece\u6211\u6709\u9650\u7684\u5f00\u53d1\u7ecf\u9a8c\u4e2d,\u6211\u8ba4\u4e3a\u5168\u90e8\u4f7f\u7528`ID`\u6548\u7387\u66f4\u9ad8. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : chendy <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u81ea\u5df1\u7684 id \u5c31\u53eb id\uff0c\u5173\u8054\u5230\u522b\u4eba\u7684\u5b57\u6bb5\u53eb xxx_id
    \u5176\u5b9e\u600e\u4e48\u53eb\u4e0d\u662f\u5f88\u91cd\u8981\uff0c\u4e3b\u8981\u8fd8\u662f\u8981\u6709\u7edf\u4e00\u7684\u547d\u540d\u89c4\u8303 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zhaokun <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4eec\u66f4\u5947\u8469
    \u4e3b\u952e\u7528 pk_\u8868\u540d\u5168\u79f0
    \u5916\u952e\u7528 fk_\u8868\u540d\u5168\u79f0
    \u5b9a\u8fd9\u89c4\u5219\u7684\u4eba\u8bf4\u662f 10 \u5e74\u9ad8\u5fb7\u5730\u56fe\u7684\u90fd\u8fd9\u4e48\u7528\uff0c\u73b0\u5728\u662f 2020 \u5e74\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : NO9527 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u559c\u6b22 ID
    \u5f53\u4e00\u4e2a table \u5f88\u957f\u7684\u9002\u5408\uff0c\u53d6\u4e00\u4e2a\u5f88\u957f\u7684 table_id \u611f\u89c9\u4e0d\u8212\u670d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : crist <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u2122\u5929\u738b\u8001\u5b50\u6765\u4e86\u6211\u4e5f\u76f4\u63a5\u53eb\u5b83 id \uff01 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sonxzjw <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8c8c\u4f3c\u8868\u540d+id \u7684\u547d\u540d\u65b9\u6cd5\u5f88\u65e9\u5f88\u65e9\u4e86\u5427\uff0c\u4e0d\u8fc7\u5f88\u65e9\u5f88\u65e9\u4e4b\u524d\u6211\u5c31\u53ea\u7528 id \u4e86<\/p>\n

    \u4e5f\u7b26\u5408\u547d\u540d\u7b80\u5355\u660e\u4e86\u7684\u89c4\u8303\uff08\u5f53\u7136\u8fd9\u662f\u5355\u8868\u89d2\u5ea6\uff09<\/p>\n

    \u4f46\u662f\u591a\u8868\u89d2\u5ea6\u7684\u8bdd\u90fd\u4f1a\u6709 \u8868\u660e.\u5b57\u6bb5\u540d\uff0cso \u4e2a\u4eba\u89c9\u5f97\u8fd8\u662f id \u5408\u9002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : tadebao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @lichao \u8fd9\u79cd\u7528\u6cd5\u9057\u4f20\u81ea\u4ee5\u524d\u7684\u865a\u62df\u4e3b\u673a\u65f6\u4ee3 \u4e00\u4e2a MySQL \u5e93 \u8dd1\u591a\u4e2a\u5e94\u7528 \u5728\u8868\u540d\u4e0a\u52a0\u524d\u7f00\u6765\u533a\u5206 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cedoo22 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8bb0\u5f97 powerdesinger \u91cc\u9762\u5efa\u6a21\uff0c\u9ed8\u8ba4\u68c0\u67e5\u6709\u6548\u6027\u7684\u65f6\u5019\uff0c\u4e0d\u540c\u8868\u76f8\u540c\u540d\u5b57\u7684\u5b57\u6bb5\u662f\u6709\u8b66\u544a\u26a0 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : gaorenhua <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u80fd\u662f\u591a\u8868\u8054\u67e5\u7684\u65f6\u5019\uff0c\u53ef\u4ee5\u76f4\u63a5\u64b8\uff0c\u4e0d\u7528\u62c5\u5fc3\u5b57\u6bb5\u51b2\u7a81\uff1f\u4e5f\u4e0d\u7528\u7528 tableA.id as Aid \u6765\u591a\u5199\u51e0\u884c\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : woodensail <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u770b\u4e86\u4e0b\uff0c\u597d\u50cf\u6ca1\u4eba\u63d0\u903b\u8f91\u4e3b\u952e\u548c\u4e1a\u52a1\u4e3b\u952e\u7684\u533a\u5206\u3002
    \u8bf4\u767d\u4e86\u4e3b\u662f\u7528\u903b\u8f91\u4e3b\u952e\u7684\uff0c\u6240\u4ee5\u4e3b\u952e\u4e0d\u53c2\u4e0e\u5173\u8054\uff0c\u662f\u4e2a\u65e0\u610f\u4e49\u5b57\u6bb5\uff0c\u81ea\u7136\u4e00\u4e2a id \u5c31\u884c\u3002
    \u800c\u91cc\u9762\u63d0\u5021\u300c table \u540d+id \u300d\u7684\u5219\u662f\u7528\u4e1a\u52a1\u4e3b\u952e\uff0c\u4e3b\u952e\u4e2d\u5305\u542b\u8868\u540d\u6613\u4e8e\u5173\u8054\u3002<\/p>\n

    \u6240\u4ee5\u65e0\u6240\u8c13\u5bf9\u9519\uff0c\u53ea\u662f\u903b\u8f91\u4e3b\u952e\u548c\u4e1a\u52a1\u4e3b\u952e\u4e24\u79cd\u4e0d\u540c\u7684\u4e60\u60ef\u800c\u5df2\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : whx20202 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5c31\u53eb id\uff0c\u6ca1\u4ec0\u4e48\u95ee\u9898\uff0c\u591a\u8868\u5173\u8054\u65f6\u5019\u5e26\u4e0a\u8868\u540d\u5c31\u884c\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : draguo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u76f4\u63a5\u7528 id \u5427\uff0c\u6211 orm \u7528\u7684\u591a\uff0c\u7528\u5176\u4ed6\u5b57\u6bb5\u5f97\u624b\u52a8\u6307\u5b9a\uff0c\u5e26\u8868\u540d\u4e5f\u5c31\u8054\u67e5\u65b9\u4fbf\u4e86\u4e00\u70b9\u70b9 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : OneMan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u89c4\u77e9\u95ee\u9898\uff0c\u975e\u539f\u5219\u95ee\u9898\uff0c\u6ca1\u4ec0\u4e48\u5927\u4e0d\u4e86\u548c\u8ba8\u8bba\u7684\uff0c\u770b\u4ec0\u4e48\u83dc\u4e0b\u4ec0\u4e48\u9505\u5373\u53ef <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : MarioLuo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u76ee\u524d\u611f\u89c9\u552f\u4e00\u6709\u7528\u7684\u5730\u65b9 select xxx_name, yyy_name …join a.xxx_id=b.yyy_id\uff0c\u4e2a\u4eba\u503e\u5411\u4e0d\u52a0\u524d\u7f00\uff0c\u6bd5\u7adf\u8c01\u4e0d\u4f7f\u7528 ORM \u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : tsingke <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5dee\u522b\u662f\u4e0d\u5927\uff0c\u4f46\u662f id \u7701\u4e8b\u597d\u7528\uff0c\u5b8c\u80dc\u5570\u55e6\u7684 xxx_id\uff0c\u5f53\u7136\u7528 id\uff0c\u4e0d\u4f1a\u771f\u6709\u4eba\u7528 xxx_id \u5427\uff0c\u6b63\u7ecf\u4eba\u8c01\u7528 xxx_id \u662f\u5427\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dayFvckingByte <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7edf\u4e00\u53eb\u201dID \u4e0d\u9999\u4e48\u201d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lin07hui <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u591a\u8868\u67e5\u8be2\u65f6\uff0c\u5b57\u6bb5\u53ef\u4ee5\u4e0d\u7528 AS \u3002\u4ed6\u53ef\u80fd\u4e0d\u77e5\u9053 AS \u7684\u5b58\u5728\uff0c\u4e5f\u53ef\u80fd\u4ed6\u5c31\u662f\u770b\u4e0d\u8d77 AS \u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RickyC <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @alexmao a.id, b.id \u4e0d\u9999\u5417? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RickyC <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e16\u754c\u4ece\u6765\u4e0d\u662f\u6709\u5e8f\u7684, \u800c\u662f\u4ece\u65e0\u5e8f\u4e2d\u5bfb\u627e\u6709\u5e8f, \u4eba\u4eec\u5c06\u8fd9\u79f0\u4e3a”\u52b3\u52a8”. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : littlewing <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u81ea\u589e\u4e3b\u952e id \u5e94\u8be5\u662f\u4e00\u4e2a\u548c\u4e1a\u52a1\u65e0\u5173\u7684\u5b57\u6bb5\uff0c\u6240\u4ee5\u53eb id \u5c31\u597d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jorneyr <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5e73\u65f6\u7528 id \u6216\u8005 table_name_id \u9009\u4e00\u4e2a\u5c31\u597d\u4e86\uff0c\u4f46\u8003\u8651\u5206\u5e93\u5206\u8868\u65f6\uff0c\u4f7f\u7528 table_name_id\uff0c\u4f5c\u4e3a sharding key \u4f1a\u6bd4\u8f83\u597d\u7528 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : gadsavesme <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5c31\u662f\u5728\u5173\u8054\u8868\u91cc\u770b\u8d77\u6765\u8212\u670d\u70b9\u5427\uff0c\u4e0d\u7136\u4e3b\u8868\u53eb id\uff0c\u5173\u8054\u5b50\u8868\u91cc\u53eb xxid\uff0c\u8bed\u4e49\u4e0a\u4e0d\u662f\u5f88\u53cb\u597d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : akira <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53eb id\uff0c\u81ea\u589e\uff0c\u4e0d\u53c2\u4e0e\u4efb\u4f55\u4e1a\u52a1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZXCDFGTYU <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    user: id,username,pwd,salt <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZXCDFGTYU <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @ZXCDFGTYU user_info: id, user_id,phone<\/p>\n

    id \u6bcf\u4e2a\u8868\u7684 id \u4e3a pk\uff0ctable+_id \u4e3a\u5173\u8054\u5b57\u6bb5 id\uff0c\u6211\u4e2a\u4eba\u4e60\u60ef\u611f\u89c9\u8fd8\u597d\uff0c\u5982\u679c\u8981\u662f\u8868\u540d\u592a\u957f\u7684\u8bdd\uff0c\u53ef\u4ee5\u7528\u5176\u4ed6\u610f\u601d\u76f8\u8fd1\u7684\u82f1\u6587\u5355\u8bcd\u66ff\u4ee3\u3002\u8fd9\u6837\u7684\u8bdd\uff0c\u80fd\u591f\u5355\u770b field \u5c31\u80fd\u77e5\u9053\u8fd9\u4e2a\u5b57\u6bb5\u5173\u8054\u7684\u54ea\u4e2a\u8868\uff0c\u66f4\u65b9\u4fbf\u4e00\u70b9\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZXCDFGTYU <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e0a\u8bf4\u7684\u5355\u72ec\u7684\u5173\u8054\u8868\u4e5f\u53ef\u4ee5\uff0cuser_info_rel\uff0ctable1+table2+_rel\uff0c\u5b57\u6bb5\u91cc\u5c31\u662f user_id \uff08 user.id \uff09\uff0cuser_info_id(user_info.id)\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZXCDFGTYU <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4ee5\u4e0a\u4e3a\u4e2a\u4eba\u4e60\u60ef <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : songco <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u540c\u4e00\u4e2a\u9879\u76ee\u7edf\u4e00\u98ce\u683c\u5c31\u597d<\/p>\n

    \u771f\u7801\u519c\u6709\u80fd\u529b\u5236\u5b9a\u9879\u76ee\u547d\u540d\u89c4\u5219\uff0c\u5c31\u6309\u81ea\u5df1\u504f\u597d\u6765\uff0c\u81ea\u5df1\u5236\u5b9a\u4e0d\u4e86\uff0c\u5b66\u4f1a\u9002\u5e94<\/p>\n

    \u73b0\u4ee3\u7f16\u8f91\u5668\u6bd4\u8f83\u5148\u8fdb\uff0c\u5404\u79cd\u98ce\u683c\u5dee\u522b\u4e0d\u5927 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lithiumii <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u4e48\u559c\u6b22\u7edf\u4e00\u4e3b\u952e\u540d\uff0cmongodb \u6b22\u8fce\u4f60 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lululau <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u522b\u4e89\u4e86\uff0c\u672c\u8868\u4e3b\u952e\u540d\u79f0\u4ee5\u52a0\u8868\u540d\u4f5c\u524d\u7f00\u7684\u5c31\u662f\u6c99\u96d5\u884c\u4e3a\uff0c\u6ca1\u6709\u4efb\u4f55\u597d\u5904 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : qiumaoyuan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8ba8\u8bba\u6280\u672f\u95ee\u9898\u6700\u70e6\u201c\u89c4\u6574\u201d\u3001\u201c\u592a\u91cd\u201d\u3001\u201c\u5947\u602a\u201d\u8fd9\u7c7b\u4e0d\u660e\u6240\u4ee5\u7684\u5f62\u5bb9\u8bcd\uff0c\u6211 TM \u90fd\u4e0d\u77e5\u9053\u8fd9\u4e9b\u4eba\u5230\u5e95\u5728\u8bf4\u5565\uff0c\u6807\u51c6\u90fd\u8ba9\u4f60\u5b9a\u4e86\uff0c\u522b\u4eba\u8ba8\u8bba\u4e2a\u5c16\u513f\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : whenwind <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    tp \u8fde\u8868\u67e5\u8be2\u91cd\u540d\u7684\u4f1a\u54ed\u6b7b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : h82258652 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u90fd\u53eb id\uff0c\u4e0d\u7136\u7528 orm \u8fd8\u5f97\u53bb\u914d\u5217\u540d\u6620\u5c04\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : hbolive <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7edf\u4e00\u53eb id\uff0c\u4e3b\u952e\u81ea\u589e\uff0c\u6ca1\u6709\u89c9\u5f97\u4e0d\u65b9\u4fbf\u6216\u8005\u6709\u6df7\u6dc6\u7684\u5730\u65b9 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : SAnii <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u9047\u5230\u9879\u76ee\u91cc\u8868\u7279\u522b\u591a\u8054\u67e5\u7684\u65f6\u5019,\u6709\u524d\u7f00\u5c31\u5f88\u65b9\u4fbf\u6e05\u6670\u660e\u4e86. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sambawy <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7231\u600e\u4e48\u7528\u5c31\u600e\u4e48\u7528\uff0c\u90fd\u6ca1\u9519\uff0c\u98ce\u683c\u7edf\u4e00\u5c31\u5b8c\u4e8b\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : darknoll <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u5c31\u53eb id\uff0c\u8c01\u4e0d\u670d\u8c01\u81ea\u5df1\u5199 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fpure <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u6837\u8fde\u8868\u67e5\u8be2\u7684\u65f6\u5019\u5f88\u76f4\u89c2\uff0c\u4e00\u773c\u5c31\u77e5\u9053\u8fde\u54ea\u5f20\u8868\u54ea\u4e2a\u5b57\u6bb5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Outshine <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f53\u524d\u8868\u7684\u4e3b\u952e\u5c31\u53eb ID \u554a\uff0c\u5916\u952e\u624d\u4f1a\u5e26\u4e0a\u8868\u540d\uff0c\u6bd4\u5982\u6587\u7ae0\u8868\u7684\u7528\u6237 ID \u5c31\u53eb user_id \u6216\u8005 creator_id
    \u4e3b\u952e\u5e26\u5f53\u524d\u8868\u7684\u8868\u540d\u5c31\u5f88\u6c99\u96d5\uff08\u8fd8\u6709\u8868\u524d\u7f00\uff09 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zhuweiyou <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f53\u524d\u8868 id, \u5176\u4ed6\u8868 xxx_id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zppass <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u64e6\uff0c\u521a\u60f3\u8bf4\u70b9\u5565\uff0c\u53d1\u73b0\u81ea\u5df1\u9879\u76ee\u4e2d\u7684\u4e5f\u662f\u7528 ID\uff0c\u5982\u679c\u4e0d\u662f\u5173\u952e\u5b57\u4ec0\u4e48\u7684\u5176\u5b9e\u5e94\u8be5\u6ca1\u591a\u5927\u95ee\u9898\uff0c\u50cf\u4ec0\u4e48 ISXXX \u4e4b\u7c7b\u7684\u5c3d\u91cf\u4e0d\u8981\u7528\uff0c\u6709\u7684\u6846\u67b6\u4f1a\u89e3\u6790\u9519\u8bef\uff0c\u8868\u540d\u5565\u7684\u5c3d\u91cf\u80fd\u505a\u5230\u89c1\u8bcd\u77e5\u610f\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : guanhui07 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4e2a\u4eba\u662f\u503e\u5411\u4e3b\u952e\u5c31\u53eb id\uff0c \u67e5\u8be2\u53ef\u4ee5\u522b\u540d as <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : greg0220 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4eec\u4f7f\u7528\u7684 id \u3002\u4f46\u662f\u611f\u89c9\u8fd9\u4e2a\u5b57\u6bb5\u9664\u4e86\u552f\u4e00\u6027\u6ca1\u4ec0\u4e48\u5176\u4ed6\u7528\u5904\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : xpol <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u53f8\u57fa\u672c\u4e0a\u6709 id \u5217\uff0c\u4f46\u4e0d\u7528\u3002\u989d\u5916\u6dfb\u52a0\u4e00\u5217\u540d\u66f0 code \u6216\u8005\u8868\u540d+code \u3002\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u503c\u662f\u7f29\u5199\u52a0\u6570\u5b57\u3002\u624b\u52a8\u5b9e\u73b0\u4e00\u4e2a\u540e\u9762\u7684\u6570\u5b57\u7684\u81ea\u589e\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zhuyichen1017 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u542c\u9886\u5bfc\u8bf4\u662f\u767e\u5ea6\u5148\u5e26\u51fa\u6765\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : 0bit <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e3b\u952e\u4e0d\u53eb id \u7684\u90fd\u662f\u5f02\u6559\u5f92 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : alexmao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7167\u4f60\u4eec\u8fd9\u4e48\u8bf4\uff0cuser_name, artical_name, category_name\uff0c\u90fd\u53eb name \u5f97\u4e86\uff1f\u53cd\u6b63 sql \u7684\u65f6\u5019\u90fd\u5e26\u7740\u8868\u540d\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : 7654 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u524d\u4eba\u683d\u6811\u540e\u4eba\u4e58\u51c9\uff0c\u524d\u4eba\u6316\u5751\u540e\u4eba\u906d\u6b83 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ritaswc <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u89c9\u5f97 id \u597d\u7528\u554a\uff0c\u6bcf\u6b21\u5728 Orm \u91cc\u9762\u7528\u5230\u4e3b\u952e\u7684\u65f6\u5019\uff0c\u8fd8\u8981\u60f3\u4e00\u4e0b\u662f\u4ec0\u4e48\u3002\u516b\u6210\u8bbe\u8ba1\u8868\u7684\u4eba\u5bb3\u6015 join \u7684\u65f6\u5019\u4e3b\u952e\u51b2\u7a81\u5427\uff0c\u7b11 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Still4 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    user_info: id, name, company_id, phone_id
    company_info: id, name
    company_structure: company_id, user_id, user_level
    phone_info: id, name
    \u8054\u8868\u4e00\u67e5\uff0c\u55b5\u55b5\u55b5\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : nutting <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zhaokun \u8fd9\u4e2a\u597d\u50cf\u662f\u963f\u91cc\u89c4\u8303\u4e5f\u662f\u8fd9\u6837\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lazing <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6709\u5951\u7ea6\u5176\u5b9e\u6bd4\u8f83\u597d\u3002
    \u6bd4\u5982 \u4e3b\u8868 primary.id \u5916\u952e\u5c31\u53eb other.primary_id
    \u4e3b\u8868\u662f table.code,\u5916\u952e table_code
    id \u7528 bigint code \u7528 varchar <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    [https:\/\/data.stackexchange.com\/stackoverflow\/query\/new]( https:\/\/data.stackexchange.com\/stackoverflow\/query\/new) \u53f3\u4fa7 demo \u4e2d\u90fd\u662f id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jasonding <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e3b\u8868\u5c31\u53eb id\uff0c\u5916\u952e\u7528 table_id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : nekoneko <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @Rwing #9 \u6709\u7528\u5230\u7684,\u7528\u6765\u5bf9\u8868\u8fdb\u884c\u5206\u7ec4 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lepig <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4e2a\u4eba\u503e\u5411\u5c31\u662f\u6bcf\u4e2a\u8868\u90fd\u6709\u4e00\u4e2a ID \u4e3b\u952e\uff0c\u5916\u952e\u7528 table_id <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lambdaq <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    postgres \u91cc id \u5c31\u662f\u4e00\u4e2a\u5355\u72ec\u7684\u8868\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : liuxu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u9999\uff0c\u7ed3\u8d34\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cs419 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u91cc\u7684 `table \u540d+ID` \u8fd9\u4e2a\u662f\u6307 user \u8868\u4e2d \u7528 user_id \u5f53 pk \u4e48
    \u5982\u679c\u662f\u8fd9\u79cd \u90a3\u5e94\u8be5\u7528\u7684\u4eba\u6bd4\u8f83\u5c11\u5427 <\/p>\n

    \u5927\u90e8\u5206\u4eba\u5e94\u8be5\u90fd\u662f \u7528 id \u4f5c\u4e3a\u552f\u4e00\u6807\u8bc6
    user \u8868\u7684 pk \u662f id
    order \u8868 pk \u662f id fk \u662f user_id <\/p>\n

    \u540c\u65f6\u7528 id \u548c code
    id \u662f pk \u81ea\u7136\u662f\u552f\u4e00\u7684
    code \u4f5c\u4e3a\u5916\u90e8\u5173\u8054\u6807\u8bc6\u5e94\u5f53\u662f\u552f\u4e00\u7684
    \u8fd9\u6837\u7684\u8bdd \u4e0d\u89c9\u7740 id \u7565\u663e\u591a\u4f59\u4e48 \u5e72\u8106\u522b\u7528 id \u76f4\u63a5 code \u4f5c\u4e3a pk <\/p>\n

    \u901a\u5e38\u8868\u91cc\u8fd8\u4f1a\u52a0\u4e24\u4e2a\u5b57\u6bb5 \u521b\u5efa\u65f6\u95f4 \u4fee\u6539\u65f6\u95f4
    \u67e5\u6700\u65b0\u6570\u636e\u7528 \u521b\u5efa\u65f6\u95f4\u5b57\u6bb5 \u6bd4 id \u5b57\u6bb5 \u66f4\u6070\u5f53 <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Numbcoder <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u4e48\u7528\u7684\u57fa\u672c\u90fd\u662f\u91ce\u9e21\u7a0b\u5e8f\u5458\uff0c\u51e1\u662f\u6b63\u89c4\u5b66\u8fc7\u6570\u636e\u5e93\u8bfe\u7a0b\u7684\u4eba\u90fd\u77e5\u9053\u4e0d\u5b58\u5728\u8bed\u4e49\u95ee\u9898 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : everhythm <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u770b\u60c5\u51b5\uff0c\u76f4\u63a5\u5197\u4f59\u4e5f\u662f\u53ef\u4ee5\u7684\uff0c1 \u4e2a\u8868 id \u548c user_id \u90fd\u6709\u4e5f\u6b63\u5e38\uff0cuser_id \u4e0d\u662f\u5b57\u7b26\u4e32\u7684\u60c5\u51b5\u4e5f\u662f\u6709\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : bugFactory <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e2a\u4eba\u4e60\u60ef\u5427
    table a (id pk, b_id fk) <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : bugFactory <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @bugFactory table b (id pk) <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mirrorpen <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e2a\u4eba\u503e\u5411\u5b57\u6bb5\u540d\u7edf\u4e00\uff0cid \u5c31 id\uff0cname \u5c31 name\uff0ctitle \u5c31 title\uff0c\u5916\u952e\u7528 table_\u5b57\u6bb5\u4e0d\u5c31\u597d\u4e86\uff0c\u800c\u4e14\u4e0d\u540c\u8868\u5bf9\u5e94\u4e0d\u540c\u4e1a\u52a1\u4e3a\u5565\u4f1a\u6df7\u6dc6\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : pastgift <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u89c4\u8303\u800c\u5df2\uff0c\u4e0d\u5fc5\u5927\u60ca\u5c0f\u602a\u3002
    \u4e00\u822c\u89c4\u8303\u90fd\u6765\u6e90\u4e8e\u8840\u6cea\u53f2\uff0c\u800c\u6bcf\u4e2a\u4eba\u7684\u8840\u6cea\u53f2\u90fd\u6709\u6240\u4e0d\u540c\uff0c\u6240\u4ee5\u6709\u4e0d\u540c\u7684\u89c4\u8303\u5f88\u6b63\u5e38\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : adoula <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6839\u672c\u4e0d\u9700\u8981\u524d\u7f00\uff0c\u4f60\u4eec\u8fd9\u4e9b\u7b28\u86cb\uff0c\u5927\u7b28\u86cb <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : mirrorpen <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @mirrorpen \u6709\u7684\u65f6\u5019\u8868\u540d\u592a\u957f\uff0c\u5b57\u6bb5\u540d\u524d\u52a0\u8868\u524d\u7f00\u662f\u53c8\u4e11\u53c8\u957f..\uff08\u6697\u6307\u6211\u53f8\u8001\u9879\u76ee\u7684\u6570\u636e\u5e93\u8bbe\u8ba1\uff09 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : malaohu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7edf\u4e00\u89c4\u8303\u3002
    \u5217\u8868\u76f4\u63a5\u53eb d \u4e5f\u53ef\u4ee5\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : forty <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u201c\u975e\u8981\u201d \u662f\u6307\u4ec0\u4e48\uff1f \u8c01\u975e\u8981\uff1f\u4f60\u5973\u670b\u53cb\u7684\u8981\u6c42\uff0c\u4f60\u9886\u5bfc\u7684\u8981\u6c42\uff0c\u8fd8\u662f\u56e2\u961f\u7684\u89c4\u8303\uff1f
    \u6bcf\u4e2a\u56e2\u961f\u6709\u81ea\u5df1\u7684\u4e60\u60ef\u548c\u914d\u5957\u7684\u5de5\u5177\u7b49\uff0c\u8fdb\u884c\u7edf\u4e00\u8981\u6c42\u80fd\u591f\u5e26\u6765\u4e00\u4e9b\u4fbf\u5229\u3002<\/p>\n

    \u53eb xxx_id \u800c\u4e0d\u662f id \u7684\u597d\u5904\u5c31\u662f\u53ef\u4ee5\u5355\u72ec\u7528\u7684\u65f6\u5019\u4e5f\u5177\u5907\u8fa8\u8bc6\u5ea6\uff08\u5305\u62ec\u8bed\u4e49\u3001\u53ef\u8bfb\u6027\uff09\uff0c\u591a\u8868\u534f\u540c\u7684\u65f6\u5019\u80fd\u63d0\u4f9b\u4e00\u90e8\u5206\u4fbf\u5229\u3002<\/p>\n

    \u4f60\u5728\u4e00\u4e2a\u7cfb\u7edf\u91cc\uff0c\u7edf\u4e00\u89c4\u8303\u5c31\u597d\uff0c\u522b\u4e00\u4f1a\u4e1c\u4e00\u4f1a\u897f\u3002<\/p>\n

    \u5982\u679c\u4f60\u4e00\u822c\u90fd\u662f select * from xxx order by id desc limit 1 \u8fd9\u4e48\u7b80\u5355\u7684\u4e8b\u60c5\uff0c\u90a3\u663e\u7136\u6ca1\u5fc5\u8981\u7ea0\u7ed3\u3002<\/p>\n

    \u5c31\u50cf\u5199\u4e2a hello world \u6ca1\u5fc5\u8981\u5f15\u5165\u4e00\u5927\u5806\u6846\u67b6\uff0c\u641e\u4e0a\u4e00\u5927\u5806\u8bbe\u8ba1\u6a21\u5f0f\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : newmlp <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u7684\u5b57\u6bb5\u600e\u4e48\u5b9a\u4e49\u5173\u4f60\u5c41\u4e8b\uff0c\u8fd9\u4e5f\u8981\u53d1\u5e16\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cheng6563 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ea\u53eb ID \u5c31\u884c\u4e86\u3002\u52a0\u77ed\u524d\u4e0d\u5c31\u662f\u5308\u7259\u5229\u547d\u540d\u6cd5\u4e48\uff0c\u7f00\u7a0d\u5fae\u591a\u51e0\u4e2a\u8868\u5c31\u8981\u91cd\u540d\uff0c\u7136\u540e\u8981\u4e48\u8981\u7279\u6b8a\u8bbe\u8ba1\u8bb0\u4e0d\u4f4f\u7684\u524d\u7f00\uff0c\u8981\u4e48\u8fd8\u662f\u8981\u5e26\u4e0a\u8868\u540d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u6570\u636e\u5e93\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u53eb`ID`\u4e0d\u9999\u4e48…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/159621"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=159621"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/159621\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=159621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=159621"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=159621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}