请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
qaz123(uid:151254)
职业资格认证:尚未取得认证
  • 这种表有没有什么比较好的优化,现在十几万条数据已经把数据库卡崩了attach://121410.png
  • data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbQAAADUCAYAAAD0t9aoAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAABq+SURBVHhe7d1RjB1XecDxs+ukVUkVLGHVWxO8S5N2o9IiqighphE3kfOQVqI0L+SlykqrSmlfCiqlQn3Y4H1CQEqooK0JtbpJ+xAqNarUhxThKovSGOIQrIBWjaOC1xQTHEgcUoKaYrv3m51v/d2z58yduXfu3Zkz/590MuecOXNm7tzM/XxmZmdmLly4cNkZhw8fdsePH89L9Xr00UfzXNg999zjzp49m5eKbWxs5Lnyrrrqqjw3mpMnT7rrrrsuy7/tbQezKQCgGWbzaXWba265H/wkAB5eXc+q1lelvOpWs+lht7y2mdX3Z2xNW+TcuXNZALMJANBcs1lAMqmcTbd25GG3sHK8P5pbcb31dSchrbfSz0uu168/dm8/kD3Rb5nNkP+2yoEDB9zNN988kAAAzTUrpxf9NNwZt7nZc72e5HtuRYJaVi/y+vkFt7C52W8JAMDkZSM0q9wobcHNz/dHZVtnGt3m2lo2Qttyxp2RYdlmfzo/328JAMDkZSM0G8QGy+tu9fCqCVZq3i0t9fJrZofdEXe7GaH1lzrSr19+2C0sLfVbAgAwedlNIXqacefozD+daPRWtk9RHluyYWvBLR3bql8JLggAQP0GbgpRGuCqWl+V0Vx/VLe8tnUzCAAAU7Lj79Amib9DAwBMyuh/hwYAQIMQ0AAASejUKcfz58+7733ve3lpNJxyBIBm4hpaBVxDA4Dm6uQpxzNnzri//tu/cQ/85QPuE5/6pPv0g592Dz30kHvttdfyFgCAtskCmt6yv/Pv0HYq06bp/vmxx9zd7/999+E//bD78z/7iPvgn3zQ3fU7d7kvHPu7vAUAoG0GRmjy92cpBKxh9ly1x73xxhvu0qVLeY1zF3920bnLUzv7CgCo2cxNN90U/BWvGtzK/DF2U66hSTB75B//wf341VfdxYuX3J49s+4X3vQm93vve5878MsHsjYhXEMDgObKbgqRwFX26SBV2vq4KQQAMCmVbgrREVvbT0tyUwgApGdHQIsFKzsyq3o6smm4KQQA0jOl2/ab9ahibgoBgPQMBDQ7CrNC9dVGac16b/Uf3/dH7sv/ftx95q8+4z71wAPZ9PEv/Vt2DU+dO3cuu2ZmEwCgubafFGKDViwvhpXDZIQ2z00hAICJyUZoGpRkatl6TVqvaXC5+BuuAQCYpOzv0PwRl4iNujSIjaIpI7TPfu6z7vWf/tTNzgxeQpyZcdmNIjGM0ACguYIPJy4KWikENPHkk0+6Pf3yoVtvzWuGI6ABQHMF73IsClijBrOmue222yoFMwBAs03ptn0AACarU+9Dq8NLL72U5wAATdLagAYAgMUpRwBAEghoAIAkENAAAEkgoAEAkkBAAwAkoVRA21xbCzyfEQCA5igR0Nbd2sPNep8ZAAC+LKCtr8qT81fdajY97JbX8gC2vprVr2dP0d9qw0gNANBEsxKgeisrriehqnfcHT92bz+QPbH1juneijt+XOb13Mrx/rwsDwBA8+RPCpER2Ho/nm0Ftit54ZdHV+eTQk5vnMhz07dvbjHPwffDF59n/7QE31Ux2T933nXlLfYY9OXHH3V3vysvNMTMv/QD2lYQW3Pzx465Jbfmlo84d/+xpfy1nCagra+79Z6M10ZTd0Dbjf/Z5EvkRyCOH8n24LsqRkAr1sSANmuD0/qRw+7w8sNuYUmDmVhw8/MS1Prz5KxkXgsAQJOYuxwX3NIxuU523K0MRK357frjgzMAAGiM/C7H/E7G5bWtm0EAAGiZLKD1VvIR2PZ1szQ8+OCD26lMGQDQXiX+sBpNdfvtt+c51E32rU2YHPZ13N69ewcSBu258b6B1NoXfHKX49YPwRNPPJGXmiGlO+fs/m3ivh5XE74rf782aT835S5HCWT93+kd+d3WlLscJZBd/M+jWT7pEZp/SnFYuY3kBwBIRWr/aMD0SGDjlGNLpThiaCLZz+xroNkkmImkA9qHPvSh7VSmDPgkkEliJAw0V/CUozyYOETqNbWJf0pxWLlt9EeWH1sAXSdBLTpCs0Esu6U/T2gOHT0AqeAfZxjHwF2OGrz8fF24y7EeetBrMPPLuymVuxz9H9YU/+HQlO/K7usm7ecm3OXo36rflDscRRPuctRrZyoLaBK8LAlkBLSwJt2230SpBLQu4Lsq1oSA1mRNuW3fyk45SuDS4GWDmAQ1PwEA0ETb19BCwcoPdDbYRW2uuWUNgKtb77eWN2IDADBJO24KGW8UtunWjjzsFrJnQ+bvT+vXyhuxAaBLrrnrrjxXXtEyo/TXNVlAkyBmR2KjO+M2N3uul71lpudWanjLNQDAuZ88/vjQgFclpajUXY42X6w/QltedptLW+9U21xbc2eWlvpBLRun1X5TyG7gIjqAMn77ox91//Hxj+elcoYtUzS/yvpG2bY2CAY0P4DtDGjyBut11wuNwNZXt6+dzd97zB1bkhfS1B/QXn755Tw3fb2tISgC1tf7/1+wf1rBfldHjhxx999/f5bHlrL/L//s0KE8V91VJwb/YS592bphfftt/f5iqrSNaeKxPmJAq4qA1hUEtPbwvysJaoLAtmWc/5erBpcQWb6OfmJSDGjBm0LGC147yRuxATSPBDFNyi9jsiSwaLLlUcT6ipVTMxDQJJCFgtm4AU7eiA2geWQ0ZpOtw2jqOJ2H0ewYoQHoHh2VfexjH8trBs3MzOS5evj91d2/Ncm+J6Xq6UNLltXlNe+XUzVwDa0JJn0NTZ4bN+7z4rhGFMc1tPaIfVcSAC5fvvKz4JfHFeqv6jqGBalx+xej/L9cNljERnC6vM6XctnRnt92WHlcrbiGljL/gbMArpAffQ0UmvfLZfnLl2GXCSWfBKhQ2i02YMg0lmJkeVHUBsU6FdBSfGI6UKdQgNBUlgSf2DI6z7Lt7XKhulHJ8qGgWJdxRj+ybF2jJ+1L0rCy1qWEa2gAauMHrGGBKBTgypJlQ2naJDCME4xk2bpGZbavUD40LyXbAU1u1w+J1fvKtgMApcEsFJT8sk+WDaVpa3pgkO3T0di4wbfpBkZoGpSqBjepl1v7qy4HoFlsEPFTVVWX9YOSX+6aKsEn1lYDmQ1qKcsCmgYk/XuzUHDSNj5bH1oOQDvYABJLVWj7qsuVZQOmTU0gwSOWQmL145A+bZCTvAa2om1psyyghQKVXzcsmKlQUAstuxv0LkfudgSG84NDmWAhwauonT9f8lrWfKisdZb0FUohsnxs3iRo8AilEKm3AcgPRkVibYvWpSk12d+h2QAUCkiWnR9rG2oj0zLa/CxHPWgmefBU7XvaB3Lob1Ni21B228q0C7WZ9mdXdr3+NgwrK62Pza+D/12F1umvv2ieJfNEaH7RcmpY30XLh+aXWaeviX9n1SSN/Ts0DTY26EjeT8qWy+ZTJAeJTVqnU1uvbH0sjSvWRx19j0J+SPx1Szn0o+Mnn62z7bSv0DKWXSaWrNB8P8XoPL+tXSa0b6xh8yetaL/6358l82Lzp/2ZZF1F24p0DNwUYsmoyk8YpAetJq3TqeZ9Os9vq+VxST/+D8ZuHdSyXt0Wzftlq2hfSFtbH2onZb9Pny4XSj5bb9vZ+hid77f3l/PLvmHz62D3rUz1u9Gk6tqWUfux2+nzt1XVtc1ovu2bQuxU6AjLJssGOru8XydsPjV6EOmBZKeanxZdp90Gf2rnT4v8oMRSSGj7pC7W3le23bj8bbL7Vqf+thRtmy5v+7DlSQptp5+mKba+ou3YrW1Fc2w/y1GCjgatogDkBzZllx9H266hyY+NHkCat3W+Mj9Otr+y/PX521K0TXWKXZeJsfNj2xzrQ+pD/P6s2DJWbF22PrZNQucVrcuf7/dV1H9duEZUjP1TrIn7JxrQQsHJr48tE1u+jLIB7fTG7tyhs29ucccPdhn64+T/UA0r+8r80Nk2sfyk1B3QYmyf/jr8fqxQnRWbL/VC52lZ2WW0D9tXLC9CZWXr6ybfFZCSgYAmJBDFAlKoXuv86ajaepdj2R+sonnCL1s6r0ybmGHzxxUKaMPo9vifLza1pE6F5pWps4qWiS3r10tZab1tE2rvz/Onk2C/K3l1DO9AG9TEEUiTNHH/DNwUUhSIJFApyWvSsj+181MmPziSYnktW/48vzwO/8fP73NSP44xsr5hqQ7ST2j/hfar1oVSkdA6pKyfwfYRqrP5EJnn74/Y56qbBDPeVI2269z70Orgj0Dsj1DdZVWmndSVFVpHHYb9q63oc2g+NrVtbN6vs7Re2bYhofl+nZZjfYXmx/Ii1E+orm7yXflvoJAXfOpLPu2Ire7tGdafzi+z3qrbVrY9I7RijR+hod3kILVJ63Tqz5sG+fGwU1m35oUt+9s1bDtD86VOUx1CP35SDtW3kQQtmzSg7WYws3RfA2UQ0MakB6YcdHqgal7L4wr1U3Sg++u229QEul2h7dHt9udpuehzlyXLx9Iw2q7sdth+bV5JOdSX7qNpkVONsg06OtNt1e2y+TL85YvYtnYZP69TPxXVo1s6FdDkGY6a6mAPHvkB0h8hzUuyB5e2s7Rs2ymt85dRof61fWg9fvtJ020Rdt3+NmibUHul9cLmRyHLx5Jlt0e32baTqdYrmxfa3ial/QmZal+hNGk6IrPb6aeyZHtjy+g8n7a3y5WpG1Yv7H6UFKtD+3UmoEkQk+sFmuoIaqGDx2fnl2ln2/jlENumavtJ89ej67bJipX9el9sfqi+Sl9+PtZfrF2ovYjN12VDqS0kONjtnfS2azAaFpT8femXkQZOOQLYdTpSCgWmWLCSehugYu3QHZ0JaPZuLh2tARikQSWUqqqyLKMl1KFzIzSCGRCmQaUoVaHtqy5nSTAMLR+ql3IseGpg1fl+GWno3E0hBDOgHP/HvsyPf1FQEcPmK22nQcsuY+t9sf6lXlOojDR07qYQAGEaCHQqP/Y2OPjlUOAQ2k5SlYDh9+2vT9h6TVqvyV9u2DZU2UY0W+dGaDYBKKY/9jZAqKJAIPNi86U+1p/O02X9trZeU6yM7pk9fHjVyTO311fl2YtbebFVztPymtvM693mmlvO6pfd2nZl88nozE8AtoSCiE2qrkCh/dj1Cr8s6lon0jerT+Lqray4K0/lWnfr6z23cjx/ueexJTef1W+6tSPrrndM6pfc5hET6AC0ViiI+GkS/H5j6ylaf9Vtm9Rnwe6LnHKUYNZz6ztGYmfc5uame3hZ6vujuX7+TD4HAIDddCWgrfdHZXlWRmhrawv5CK0/ElvWU5ELbn5+3t2bjdC2Rm4LWT0AALtrduneM25VRmL9iNUfk7nVVQld/TC1vpxfQ+sHs14vPx0575bu77fKRmj9tHYmPxUJoGvstTWgCVr7PrTTGyfy3HTtm1vMcwCAJuEFnyPQl9rx2vqd7Ev/2D/NxndVjBd8FuMFnwAATAgBbQTyr1nLL3cd+6c9+K6QEk45jkCG2fbA51TNFXoagv3TfHxXxTjlWIxTjomK3e1V911gRf1VXdew9nVue6yvOtch/P7GXW+ZdqE2ZfsvUkcfo4itt+7tKeqv7LpsO8n7Sdk80tapgFbncxz1X7IylScP+AeNlOt8IkEd/cUO7FB96DNV0YT9U3a9Uucnn62z7bSv0DKWXSaWrNC2T0qT/l/WebHPLvWabFmW0T5tXhT1h7R0JqBJELPPcazr4cShg8svl+UvX7fQgS1le/DXzX4ezfvlsvzli9h2/nI2r/RHMLQvpK2tD7WTst+nT5cLpSaw+0Xzfrksf/kypK3uC5nGlrVt7L6zy6ObOhPQJvEwYv2XrR5YoVSWHoyhZcY9UGV5TVr2p3a+knX6dVXs9v7R9qEUEvqssb5DyrYrS/obZ/9XsdvfVaheyv7nt3Uy1eX8Oi2rUF9IT+euoekpxyY9bV8ONHsw23yIPWg1FdVLf5q07E/t/KaRz2G3bZrbGVqX3bea13IR29ZPqZDPUuW70s8v7TRvk63X9kLq/b61zq9Hd3QuoNV9ynE32APXHsCxeqU/EJaU9UcCV9gfUJuE3beaL7MfbVs/dZX9/FXy+n1ovRr2HSBtnQtok6AHVyhVNcqy0lYP8hhto/x8lfVVJX3HUlVVlrVt/TSM7h87tftM+7B92fltZfeRn6oaZ9ki0p9+H3X3jXbr1E0hk6AHVlGqQttXXW4Yvz//h6Du9Snpd1iqQtsPW872H0t1kH5CP6pS59drXSg1gb9/QqkKbT9sudC+CNUJydv+JG/no9s6dVOIXj+b5DU0/+Aqc7ANOyiL5ku9HuCxdlLnp6J6JWXtuy6hdQwzzv5Ro6xX+f1L3u4Xna9J62wboXWhFOKvZ9r0syi/HCLbW9QuNF/3gaZYnZC8LG+TnR9Tth3arVOnHPX6WZ3BTA4UO9UDTvllm7fsgVr3gSf92aR1OvXn1Uk/r05lHXYf+GWbt7SdpDLbqf3otGi9fn/D+g/NlzpNbVVlnwmbt7SdpLL7I9ZX0Tps3/56yq4XaeEa2gTowRQ6GIsONJkXmy/1fn+hH4xQOyX1dhltG2pv29VN+w2tt2idMi82X+pD/VlF69XP68/Tcpn+h5HlY8kndbHPOk1F+6xo+2RebL7U+/2F6or2gcyLta/SD9JCQBuDPVD0QLJJ1XUwaT/af6xfuy3CtveX0TrbXvjtRqHrFHYdk1iX0H6qrjfUXmm9sPlRyPKx5AvVTVJoH9ik6tou7cdfR2hq5ytZ3m6LzNeyTG172w5pI6CNwT9QpOynSSjTt21TtX1d/P50HTZNgt+vv87QfEvLfr0vNj9UP2pf0+KvX8p+moTQemJJhfK2TvhldAMBDQCQhNa+Pub0xok8N1375hbzHACgSVob0A4ePJjnpuvUqVO8I6kA75BqD76rYuyfYrwPDQCACSGgAQCSQEADACSBgAYASEInA9revXvzHAAgFZ0LaAQzAEgTpxwBAEnoVECT0dmFCxfyEgAgJZ0JaAQzAEhb50Zoeg2Na2kAkJbOBDQZnWnSMgAgHZ27KYQRGgCkqXMBzR+pAQDSMPPcc8+18k14PG2/mXhCeXvwXRVj/xTjafsAAEwIAQ0AkIRKAU1evvnss8+6p556yp08eXI7PfPMM1n66le/6jY3N/PWAABMT6VraOfPn88C1ssvv+z27NmT114xMzPj3vGOd7i5ubm8ZnJOb5zIc9O1b24xzwEAmqRSQLt48aJ7/fXX3QsvvOBeeumlLKhJEBOSv/HGG93+/fu36yaJm0KaiQvp7cF3VYz9U6z1N4VIoLrmmmvcDTfc4Pbt25cFuMuXL7urr746q5ORWWjkBgDApFUKaLOzs1l685vf7K6//vpsKgFMRkuSZB4AALthpAgkozJ50satt97q7rjjDrewsOAuXbq0nQAAmDaGVACAJMxcuHChUU8KkT8NKKPqTSGhZzeO8vgrbgopxoX09uC7Ksb+Kdb6m0Lazj7HcZRgBgBoLk45AgCS0KmAJqcdNQEA0tLZU44ENQBIy1gB7X/f+D93+jv/7U4+97x78plvDSSpk3nSpgm4ZgYAaRs5oJ3/0YUsaMk0FLSkzrbZbYzIACBtIwc0GX2VVaXtpOhpRk2M2AAgLZ29hgYASMvIAe3A/rfkubhz/7WRTcu0BQBgHCMHtB/88BW3+Ctvc7/0lr3u53/u6rz2Cglm77rlPdlU2gIAMEkjB7SLFy+557/93ezmj7fO7XO/ufj2LH3huf/J0m13HHannn7KHbj+17O2AABM0tjX0F597Sfu22e/7775/HfcB//pm+5Xf+OdWfqLf30hC2bqi49+Mc8BAFC/kR9O/O3vft+d+8GP8pLLRmUSyF741nPZVEj+D9/5i9lpxw/c84EsqMm0iH048YsvvugeeeSR7AGYt9xyS1675fTGiTw3XfvmFvMcAKBJRg5oJ76x4W6Yf6t75dXXslHa5555ZSCQ2fx9v3Wt++7pbw0NZsJ/2v5XvvIVt7i46Pbv35/XbKn6tP268LT9YjyhvD34roqxf4ol9bR9/xqapSM1zR/9xo9LBbOQ9773vTuCGQAAvtquoflsUBsHfzMGAChj9pVXRrul/tfefl2e2/K715zdEcA0qH3i/TfmNdXINbSHHnrIPf3003kNAABhs1//+tfzbDXy92c3v3Mxm8pNH3JHowY1m47+wU1Zm1HMzc25d7/73W5+fj6vAQAgbKxTjvIH1TJSk+tjeifj3y/fOpBCf3RdRd3X0PRZjgCAtMzeeeedeXY8o970MUyd19D0ocSSCGoAkJaxbwqZJLmG9vnPf9597Wtfy2tG5z9hn5tNACAtjQ5ok7iGxilHAEhTowOakD/ck8BWB045AkC6Gh/Q6sRpRgBIV6cCGqMyAEjXzNGjR0d6luOkHDp0KM8VG+VZjjagjTpa41mOxXj+XXvwXRVj/xRr4v6ZOXv2bGMC2rXXXrvj4cQxPJy4mfgRaA++q2Lsn2JN3D+dOuUIAEgXAQ0AkAQCGgAgCQQ0AEASWntTyOmNE3luuvbNLeY5AECTZAHt7rvvdo899lhetXu4y7H9uDOsPfiuirF/ijXyLkcJZkKmfgIAoC1mdWQmU01aBgCgLbKbQiR42ZEZwQwA0DbZKUcNYpq0DgCAtshOOWoQU6kGNnmWo00AgHQU/h2aBrZU6LvQeI0MAKRn+5Sj0LytS5GMzghqAJCW4F2OKY3KAADdUOHRV0+5T979yf5/fVXrdxejMwBIU3bKsdyI7D3uI499pP9fX9V6AADqt33KUen1M047AgDaZMcpR66hAQDaqHOvj+H6GQCkqXMBDQCQJgIaACAJBDQAQBJmjh492pg3VotDhw7luWK84LOZeClie/BdFWP/FGvi/pm5cOFCowJa2TdWn944keema9/cYp4DADRJawMaI7Rm4l+17cF3VYz9U6yJ+4draACAJBDQAABJIKABAJJAQAMAJKFTAU1eHaMJAJCWzgQ0fQ+aJoIaAKSFU44AgCR0JqDpqEyTlAEA6ejcCI1TjgCQps5dQwMApIlraACAJHANDQCQhE6N0PT6GcEMANLDKUcAQBIIaACAJBDQAABJIKABAJLQ2jdWn944keema9/cYp4DADRJawPawYMH89x0nTp1iteyF+C19e3Bd1WM/VOsefvHuf8HcYiPkUX0CPgAAAAASUVORK5CYII=这种表有没有什么比较好的优化,现在十几万条数据已经把数据库卡崩了
  • 1.假设我现在有两张表或多张表,我是把每张表都写一个SQL,还是所有表关联写在一个SQL里 2.一张表里有多个字段,我只想使用几个字段,然后其他字段是不管还是怎么处理 3.一张表有的字段使用有的不使用,不使用的字段在 使用的字段增加新数据时 增加一个默认的值
  • 118688 将前三列相同的数据合并成一行,天数日期不显示,根据天数将对应数量求和,现在可以完成一天数据,所填数据会将所有数据相加
  • 现在有一张表,其中一个字段 ort01 是有多个数字加 / 组成的,字段长度不固定,但是就够都是四个数字加 / 我想把表变成这种样子 问题:拆分我使用的是 with as 的方法,虽然拆分成功了,但是以前没使用过 with as的写法,将所有表都进行with之后,关联在一起查询就报错了 思路: 1.使用 split 函数拆分,在SQL中好像没有这个函数,可以查找到 SplitIn(varchar @c, varchar @split) 函数,但是使用之后好像只可以得到拆分后的第一个数; 2.使用临时表,在网上找了 with as 的用法,拆过得到需要的临时表照葫芦画瓢已经完成了,但是再多表关联的时候就老是报错 希望可以做成一张临时表的样式, 只要做出来就行了,时间很赶,拜托各位大佬了
  • 如图一,关键日期是自选的,不是数据库中的,且筛选条件是小于这个日期所有参数, 现在要求是用自选条件的日期来减去数据库中的一个日期,作比较,进行其他操作, 问 : 怎么在单元格中获取条件中的日期

17

34

17

10

12
个人成就
内容被浏览8,541
加入社区6年117天
返回顶部