首页 技术 正文
技术 2022年11月19日
0 收藏 968 点赞 3,413 浏览 62695 个字

1.插入记录INSERT

命令:MySQL基础(三)(操作数据表中的记录)MySQL基础(三)(操作数据表中的记录),expr:表达式

注意:如果给主键(自动编号的字段)赋值的话,可以赋值‘NULL’或‘DEFAULT’,主键的值仍会遵守默认的规则;如果省略列名的话,所有的字段必须一次赋值。

MySQL基础(三)(操作数据表中的记录) MySQL基础(三)(操作数据表中的记录) MySQL基础(三)(操作数据表中的记录)

MySQL基础(三)(操作数据表中的记录)

INSERT SET(用的较少,一次只能插入一条记录)

命令:MySQL基础(三)(操作数据表中的记录)MySQL基础(三)(操作数据表中的记录)

MySQL基础(三)(操作数据表中的记录)

插入记录INSERT SELECT

命令:MySQL基础(三)(操作数据表中的记录)MySQL基础(三)(操作数据表中的记录)

2.单表更新记录UPDATE

命令:MySQL基础(三)(操作数据表中的记录)MySQL基础(三)(操作数据表中的记录)MySQL基础(三)(操作数据表中的记录)

MySQL基础(三)(操作数据表中的记录) MySQL基础(三)(操作数据表中的记录) MySQL基础(三)(操作数据表中的记录)

3.单表删除记录DELETE

命令:<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfsAAAAeCAIAAACkFyAAAAAgAElEQVR4nO2dZ1ccSdKo92fduzsj4dvR3uK98CCBMBLeeytACO89kgCBEN4JK7z3tmnae99VeT9U0yCEZtDM7Lvv3lGfOJw+VFVWZmTEU1mRkdn/ADD4KT/lp/yUn/J3kH/8x2vwU37KT/kpP+V/Rn4S/6f8lJ/yU/4u8pP4P+Wn/JSf8neRn8T/KT/lp/yUv4tcEx9c/zV9fvvKez/fHnr4tabzH/L53UIeKL9bwh8o/CHnP7DAH23Ot+V/7+gDz/w7iKn5D+nr3/4/+Ob7Qy6/977g+0d/o1sfeOYPCXRf+f/xXvtfJXfU8nBF/fv0+f06XBMfApABRsTYx9+7BgLwrZOR82EIhqGvTrsp51uBAAzBt0uAIRhA17b1zdGvzwTfVvhuOQ/UCAwAfE9bvirhN9TyHS1DBlilVCsVSo1aA0HQV+ff3PTrtny/hr+lxu8IDMMqpWp2ZnZkeOTs9MygN9ytLVI2BK44V1OTU+Nj4xKxBIbhv97s/kvktnUh9gBD92sDhgAMwV/pE9z6/y0Dvr9zv+MpdyrwlRl/7Q7Gu39jUciZ93vEX6EijVpzeHA4MjzyZeGLTqv7O1vLHVGr1Qf7h/19/YsLiyqlCgCg1+l5XN7pyalMJvvWVEw9C8OwRCw5PjwWCcUGveGvrdVtrH11CAL/ADAQ8AVjI2NVFVW11bW11bV1NXWtLa2f+j9trG/KpLJrkhkrLRKKpian6mrqkJMRqaqsevf23eHhEQBAKpV+nvpcXlY+NzunVCrvVEWv129vbTc3Ndfcurymqqa+rn5+dl6lUA0PDtfXNdRU1dyUX1OHnFNVWT3waZDNZgv4gtGR0crrCiNSXVnd3dV9dHD0oGcmAHqdfmN9s621vfr2vaprG+oaFr8sKhQKiUQyOzNbVXmjluam5v6P/TtbO2qV+kYnRhXDPC5vcnKqpro2LycvKzOrIL+gual5aXFJIpHcfv6rFKrR4dH6uvq21raN9Y17q6fT6g72DlqaW2qqa8ZGxoy3+05DbiwJAgAGEARxOdyYqBhvL+/BgUGNRnvPtQBABmh2evZ5yPMA/4D9vX0Igv7jzvM/Lzqt7vjwuKG+saa6trK8su9D3+fJzx96epsbm5e+LN3Wm1ajXV9db6xv7HrfJRVLjcgDAIbgw4PDd2/ft7W27e7sARjMzy3U1zWMjY7zefw7Ot/a3Gpraev70Hd2eo5Y4MX5RVNDU+3XvtBQ3zAyPKLVaGEYnJ6cdr3vqq6qqamuramqqauta2trmxif4PP4er0eKRkyQJcXl20tbV+VU11bV1s/PDhsdOE/oygAhELhu7fvnng9SU9Ll0lkf9WD5P8DEQgEne2ddky79LQMPo8PANjb2SsqLHoe+ryjvcM43gJf+ykMAAA6na6yosrP17+6qubs9OzP9tEtOT057enqqSyvrKmura+rPzs502l1pqP/ADA4PDjMy8mjUekO9o6O9o6O9o5Ojs6eHl4R4RHlZeVLS8t6nd7U9yfHJyXFJQ52DvZ29g72jogwGczQZ6FTk1MAgMvLyzev35CIpJrqGpFIdKc2Go2mv6/fw93DjmXnYOeAXG7Hsndxdq2tqRUJxVmZ2S7OrvYse0d7Rwf7W3exc2AxWOmp6Wura4cHh7nZuTQqzd4OOc3Rwd6RxbR7EfkCqcPv6wUAjVrT3dXj6+PHYrCQhjvYO9rb2bs6u7Y0twoEQjabXVleSafSHewcnBycEPF094yPje/90CeTyU2l6XS61ZXV1yWv/f387Zh2dCqdTqMj+gwLDWtuaj4+PjF1ulgozs3OdXZydnNxq66sFglF347BuVfclqYWBzsHO5Zdfl6+RCy5v1EAqFXq7e2dmenZw4MjyAABACAIYp+zfb19iQRi1/sujVrzPeKPjow6OTrTafTNjc2/J/GVSuX052kXZxcnByc3F7ecrJy2lrbMjExXF9fXJa91Wh18q0fqaurs7eyDg4KXF5eN6gJArVL39vT6+viGPAtZWlyCYbiups7Z0bkgr+Bg/+D2kx4A0Puh19fbNyY6ZmHhCwBArVYvLy27u7nb29k72DkgrmfPsndzccvJzlXIFDAMz8/Nhz8PZzFZphOcHJ18vX0LCwq3NreQzjXoDWur6z5PfOyYdshpiCU7OzpnZWZdca7+PPH5PH59XT0BT4gIi5CIJX9Pa7lXuFxubXWt2SOz8OfhHM4VAGB5aeXliyg6jf66pFSv0wMAIAg+Ozubnp7Z2thSKpSIMWg12pTkVAwKk56Wvre395cRH4DlpeW0lDR3V3dnR2dnJ+f52XmVSmU64R8AgN2d3bjYOLPHZt5PfNLTMjLSMuJj44MDgx3sHVhMu9jo2MnxSeNTAoD9/f201DQMGuvi7JqakpaZkZmZkZmWklb+pnxzYxMAcH5+np2Z/c//+8+iwiKBQHCnQmq1+m3HW7wtnkqhRkZEZmZkZqZnpqem52TlDA0MyWWKjvbOnOycrIysxPhELw8vG2sbBp2B3CgtNb21pfX46Hhneyc2Ovbxo8durm4ZaRmZGVkZ6ZnpqenVVTVIHR6iF7VK3dLUwqAxyERy1MuonKyczIzMjLSMnKyc8dFxmVR2enqal5v36NfHbi5uaSlp2ZnZsTFxbq5uJALpWfCzmekZ03N7fW09MyOLyWAy6IzIiMjiV8XlZRW5OXlBgcFUCs3Nxa26qubq6go5XcATxMXE4TA4K0ursOdhXxa+3KkwZIAWFxYjIyLNHplZW1onxCeKhOLvEf/s9Ky4qCQhPmF4aBgJIkEQxL5g+/v6k4nk7vfdv0H8sdExF2dXJoO5ubH19/RhhUIxMjyCskE7OzoXFxWPjYzNzswW5BfgMLiQpyG8K56J7Otr6/Gx8eaPzWkUWltLm16vR3qTe8UtKS7B2+JDnoacnZ7BMFxSXIJBYRITEne2d+4Qv72tnU6jB/gHfJ76DABQqVRzs3N4WzwOi4sIi8hIy8jKyMpIy8jNzu3seKtWaWAYnpyccndzJ+AJIU9DsjOz01PTw0LDiHgiiUgqe1N+dnYOANDrDV8WFmkUmqW5ZVhomKmcrMzsjvYO8feM5+ECAJ/Hb6xvJBFJkeGRUonUGK78T3fff14A4HF5tTV1luaWEeERiI9zLjl9vR9rqmpmZ+aQQZhGrWlrbX/5Iqq1uVUoECLGYNAbRoZH37x+MzoyKuDf5eSfkfOz80/9A8Wvip2dnFHWqInxCaXiJtbyDwDA7u5ufFy8jZVNcVHxwd7B6fHp9tb25MRkZUWlv58/3pYQ8jRka3NLq9UCAA72D9JS08kkSkpyyuHB4dnZ2dnp2enJ6SX7Enl8XZxf5GTn/PqvX0uKSu4l/ru37/C2eD9f/8GBwbNT4+Vnp2diodigh/hc/vnZ+fnZ+fLicl5uPhaDDQwI3N/bR07jcrlqtXpnZyc2OtbC3CI1JXV/f//87Bw5yrnkKJBH6AO6Sq1Stza3shgsby/vibEJ9jn7piYisUFvODs9y8/LNzczT0lK2d7avji/2NzYrK2pdXF2JRFIr0teI3YvEohKS0oZNIaDvcOrwldLi0sioUghV3IuOZMTk4kJiRQyxcvDq6+3D8GEgCeIj0sg4ImWFlYO9g61NbXa24EXAKQSaVtLG5POtLSwRKPQSYnJYtF9TgsBrVY7Pzfv6+3r5OjU0dahkCs0ag1kgC7Zl0bid/UoFUq5XC7gC0RCkUajgWEYMbgfID4AAAY6rU6lVGk1WoMBUqvUAr5AwBeoVCrIcPdCnVYnkUiQO6qUqtsRAMgAqZQqtUpt0Bu0Wq1YLBYIBKYuM+gNMqlMIBBIxBKtVvttNfR6vUwm4/P5QoFQrVb/+diCQqEYGR5F2aDCwyIO9g9gCJZJZe/evqOSqQ52DsuLyzqdDtHV4OCgr7evuZk5AU9IT01XKBSIJrc2t+Ji44h4Ym52LqLe1yWvcRhccmLyt8Tv7OhkMVnBgcHTn6dNxCfYEhg0xqePn46Pjs9Oz05PT89Pz3lcHmSAAQBTk5/d3dxdXVzbW9svzi9Ojk5mpmfiYuJsrG38/fzn5+YhCNLrDYtfFuk0urWVdW9P7+HB4fnZOWLJPC4fGWbebjUEwVqtFplqut01GrUG6RrTP7UarVKp1Gl1CPHJRPKLiBcyqUypUAqFQpFQpFKpvu0FGAYqlVokFAn4AplMdtu0IAOk0WhUSpVOqzMYIIlEIpFI9Dq9MSBpgFQqlVAo5PP5CrniW9P6bYFhWCFXCAVCAV8glUhvhzIADAwGyHRUcs9Rg1qtVilVer0eMkASsYTP50skEp1O9+2NdDq9VCIV8AVSqZTNvqyrrb9NfIMBkoil3CueSqkCMNDr9FwONyEugUwiF+YXnp+da9Qag94Aw7BcpuBcXslld1uq0xk9SCgQKhQKg8Fw5+5KpUqj0RgMBo1GIxKKjOq61jNkgPQ6/f7eftjzMJQ1amJ88n7io6xRjQ2NSqXxpQMAIBKJPvZ99PL0srK0Lswv5PF4MAwjxKdRaa8KXxn0t2Ymr63qIcS3xdmGPgtdXVkFdz7wzVcOh1NdWY3D4sKfh2s0mttnXRPfsrCgUC6X31PIg4lvx7QLCgja2927WwgAZ6dnebl55o/NC/IKxGIx8s+N9Y242HgsBpeSlIIEu6YmP/v6+BEJxNyc3NOT0zs1WZhfiIyIxOPwcbHxAr4AACDgC+LjEkgEEgaNIeAJL1+8PD0+vV3trc2t5MRkDAqDw+AwaMz3iK/X6tdX12tr6pydnFlMVnZW9sjQyMryqkat4bA5/r7+ZBK5pbllfW1jcGCwtaX1Xee7udk5LpeLPHh+aIwPG+Cjg6PpqemlL0t7u/ufp6bbWtraW9snJybZbLaJznqd/urqanFh8UP3h9aW1s6OzqmJqfOzc9MJMolsdnp2emp6e3N76ctS1/uu9rb2sdFxDocjlUp3d3Y/ffzU1tL2oad3dXlVKpXedmapVLq9tf2p/1NLc0tHW8fnqc/GWz+wx79PfBtrmxeRL46OjgAAMATPzsx5enjhsLiO9k61Wg0AUCiUdbV1LAYLjULb4mx9vH0uzi8Qpx0bHff39bdn2Xe2dwIAEOLbYm3vJf7bjrffEh9vS2Ax7VaWVgyGb2K+AExNTrm5unl5eg0NDiH/1mg0H3s/kolkJwenkeERnVZnIr6Ntc3iwiJS5/s9AgIABhq15vjoZGJs4svColatRWaDhQLh8uLy7PTsxdkFcolep19fXZ8cnzw5Pr3iXDU2NJJJ5PCw8J3t3Ynxic6Ozredb6c/T19eXhpnFIDxIcG+YE9/nu7s6Gxtbh3oH9jb3VMqlchdZFL55vrm1MTU2sra7s5ed1d3X28f94qHsP705HRqYqqjvaOluWVoYOjg4MB44e/1I2SAZDLZ/t7ByNBIe1t7a3Prx96PW5tbWo0WqZhUKt3d3RsZGulo62htae390Lu8tCLgC0zvcCKhaHlpZXJicmd7Z2d7t6erp6W5pfdD7+bGpkwmu30vsVi8trre19vX1tLW19s3OjJWUlxiaWEZGR6JBNAkYsnG+ubszNzJ8alerz8+Ou7r7QsKDCIRSVEvorrfdy/ML1xxriAI2trcnpyY2tvdNw169Ho9j8tbXlzu7eltbW7taOsYHR7d2927XYez0/PPU9NfFhZ3t3cX5hbedrxtbWkdHhw+PT01ugMAAICT45OI8MjfIX5dbf1Xc60AcLncmupaKwsrZ0fn7a1tvU6PRHVoFFp+Xr5apdZpdTqtTqvVGvQGpG8eRnz8s+Bni18Wkct1Wp1Op/uqawG4ZF9WVlThsLbhz8NVSrXJpABsJL6luSXCYp3OWAjihA9KbrlF/ED/wK3NLQiCDAaDwWCAIAiZlzMRPy83H2GuwWBYW12Li4mzxdlmZ2UjuRAV5RU0Cs3P129sdOwrBwMAAKCQKZoamkgEkquz6+KXJYT4cbFxdBrd2dHZ3s7e2cm5+323aSZQr9O/f9fl5eFFp9LdXNzuGeNDRgLKpPLEhEQ6jY5BY7BoLAFPsGPaJSUkCXgCLocb4B9AJpJfRL58EfmCyWDibfEEW4KDnUNdTR1ibT80xtdqdHW1dR7uHr4+vjHRMS7OLgQ8AYe1ZTFZ1VU1Z2fnyIBXwBcgUWwKiUIkEPG2eEd7x1eFr46OjhEa7u3u+Xr7Ojs5h4WGBfgHkElkW5wtk8Eqff2mv68/JjqGQWfgcXgykRwcFDw8NGwc+wCgUCiGh4YjIyKpZCoBTyQSSCymXenr0pOTEyMo/wTxUdaoyIjIo6Mj5J97u3vJick21japyalSqQwAcH52npaSRqPSPD087Vh2eFvCwvyCWq3WaXXNTS0Odg6B/oEL8wu3iZ+UmLy5sWmyTMTC29vaWYy7xCfiiUwGa35uQaVSG8/X6SADBKBbxPfwGhwYQspXKpV9H/pIRLK7m8fE+KRep789xp+bmZPJ5KZy7gwPTfjr6e5xdnIJ8A88PTlFRgCTE5OhIc893D3bWtsQFxAKRLHRsS5OLl3vuy7OL5qbmkkEkqeHV2JCkpOjE4lIItgSXF1cKysquVdcpAsgA7S7s1uQX+Di7EIkEAl4Ao1CC30WujC3oFKpAAAH+wc5WTn2dg7BgcGR4ZG2WFsalT4/O6+QK9ZW1/Jy8hzsHIh4IgFPoJAp0VHRXxYWkQt/oxNhCJZKpMNDw6EhoQw6g0ggEmwJNCotIy2Dw+bAMKxWqwc/DUaERzLpTAKeQMATKCSKt5d3U0OTWCRG3tRXllfiYuNYTNbLFy/DnodRSBS8LYGAJ0RGRE5OTOm0OkT5KpW6p6snMCCQQqYgd3FzdXvi9cTayjoywkj89bX1pMQkDzePlqYWpVLZ3Nhsx7LDYXEYFAaPw1PJ1KdBTycnJnU6XWZGJpVCLSkuQUaKBoOBzWbX1tS5u7pTSBSkqkw6Mzoqemx0zDTq7e7q9vJ84u3l/SLyhc8THxKBZIvDU0iU3Jzc46NjU37gyfFJeFjE7xC/oa7hTnaNWqWem5mjUem2WNuR4RG5XH5wcJiRlkEhUeJi4pYXlzfXNzfWNtZX1y/OLpCUkodFdQhPvJ68f/d+Y20DuXx3e1chV9xkfSHEL69ExvhG4l/Lzs5OXEycpYVlfGz82sra1sYWUs756blee/cd9reI39Jqx7LzeeIz83lGIpLwrni8K55IINKqtSbimz0yy8nOEQlEsAHmcXkN9Q0sJotOo3e0dwAAlAplclIyHodPS0nb39u/e2sAAAxGh0fd3dzpNEZ3dw+CxdjoWHuWfWJCEjLYj4uNVypUCDTPz85TU1LtWPYvI1+mpaTZWNncO8aHYVilUFVXVj8Nfkomkol4oqe7Z3RUdFVFlUQk4VxeBQYE4jA4lDXKxcklNSWtuKg4OCjYwswCj8P3dPeIxeIfIr5GrS17U06l0CzNLWkUWkx0TPmb8sCAIGsrGwd7x4+9HzVqDZK18jToqb2dfWZGZnVldUJcApVCZdAZtTV1Bj0Ew/DO1o6zo7OVhRXBlhDyLKQgvyAiPAJtg8ZhbQl4ooOdQ3JSckZ6hrurO8oaFRwYbByFATAyPOLv64/F4IICg8vflOfl5FFIFLQNur623jhB8keJPzo8ikFhbhOfx+U11jdi0FhvL+/TkzO93jA3Nx8cFOzp4VlSVBITFWNhbtFY3yiVSgV8QV5uHo1KS05Kvry8NBEfb4sPex7W//HT1ub2xtrG5vrm5vrm1uZW8atiConyLfFpFFpne+faytrm+ibiC0K+Mdo7NTnl7ubu4e7R//GTQQ9p1dq93b2w0DBLC8uol9Gbm5sAgNvEb2ttX1le3dzYWl9d39nauUc5ABj0hpnPM54eXkQ8cWxkDJnpqautp1FpWAwuIz0DmZvd3tx2sHNwd3WfnJgU8AXNjc22WFuUNYpgS0hMSCwqLAoKCMKgMC7OLj3dPUjb+Vx+cmIyHod3dnLOysh6Xfw60D/Q3MzC38//6PDIoDfs7u6mJKVYW1pbW9mQSZSw52HBQcFrq+ubG1spySlYDM7J0Tk/L7+ivMLD3cPC3CIuJm5rc+vum8rXIpfLJ8YnmAzm40dmXp5euTm5xa+Ko15EpadlHB8ea7XaifEJB3sHG2uUj7dPbk5u0aui0GehKGsUygb97u07qUQKAFhcWAwPC3/06yMMGuvu6v66pDQ9LYPFYFlZWiUnJR8eHgIA1Gr1xPgknUq3trIJDAgsyC9AJvktzC2sLKwiIyIRbS8vLUdGRDJojLqaOo1aMzgw+CLyJZPOxGFxTo7Oz0Oe5+Xmra6sarXa+Lh4a0vrnOyco6MjcB3VsLK0RtugX0a+LH1dipRvY23j6+OLDCkAAB1tHfZ2DmaPzckkclhoWElRSdTLKBtrGywG29neacwEeQjxbaxsvh3j67S69bUNV2dXLBr7oeeDRCI5ODjMzMjCoDF4HJ5BYzDpTAaNQaVQiwqLDg8OH0h8MomMRWOpZCqTzkTEz9dvZXnlJmr2e8SPj403e2xGsCWYSmDQGPm5+UiC1AOJ39bSxmKy8Lb4J17ewUHBQYFBfr7+qSlpK0srMATOTs8K8grMH5s7O7nExcYlJyWHhoTas+wd7BwK8guQ57lYJI4Mj8SisYX5hZfsy3uID8DM9EygfyCZRG5saAQACPnC2OhYFoP15vWb1pY2F2dXBzuHhfkFZKg1ODDo5enl7+ff1ND0qrDIytLqe1EdGIIVCsXU1JSPt4+zk3NLU4uAL1DIFXq9/pJ9GRgQiEahA/wCPn38JBaJpVLp3s7ei8gXluaWsdGxu7u7P0r8ivJKKoXGYrDKy8qFAqFMJtva3Pbz8cPj8GVvyq+uuJAB4l3x+nr79nb2xGKxQqE43D/MycqhkqkJ8Ql8Hh8hvouTi421TUpyyurKqkwm29neefb0mbmZBYVMbW9rvzi/4PH47zrf0Sg0OpW+vrqu0+nYF5cpySl0Kj0tJW13Z1chV4iEoqbGJhKB9Dw0bHlp2fRw/QPEHxkeRdmgbxNfpVJNjk8y6UyCLWFmekalUr3teOvq4vryxcuxkbGaqhprS+vYmFgej7e9tR0ZHkmn0SsrqvQ6A0K9kpISCpmCw+JoFJrJOBEhE8nWltbPgp+ZiD8/N08mkVE2aAqJgpxDo9B8ffw+9n00Ed/Lw4tIIAYFBiUnJcfFxvl6++JxeF8f37HRcSTjW683LH5ZYtCZVpbWFBKFQWOwGCw6le7l6dXc3HyvZvb39lOSU60trctKy5Bpnsz0TFusrY21Tciz0O2tHb1e393VTSaR4+Pitza3+Dx+U0OTLdaWRCDV1dZzOBy5XD41MRX6LJRKphYXFWvUWoPB8O7tOzqN7vPEZ2hwSCaVyWTy9dV1nyc+lhaWH3s/SqXSvd291JRUlDXK2dG5s+OtWCxmX7ClEll9Xb2DnYO/r//Q4LBMJpNJZStLK+6u7iwGq6e757ezkw8PD6NeRps9No96EbW2ui4WS+RyOZvNPjo8koqlQr4wMjwSbYOOi41b/LIkk8nkMvnezl52ZraluWVwYPDe7p7BYFhcWAx/Hm5hbhEUELSyvCKTyaRSWXlZOY1KC/APmJyYhCGYe8WNehFlY2UTFxu/srQik8mEQuH42PgTrydmj81McfyV5dWoF1EsBquupg6GYLVafXJ8EhsTRyFT83LzD/YPZDIZEhdJjE9E2aByc3KPjo60Gu3nqWl3Nw8cFldZXslms+VyuUwiGx0ZDQ4Kxtvic7Nzkde+zo5OB3sHEpFcmF94dHgkk8rOTs7CnoehbFDZWdkIhP848bVa7fraurOTMwaF6fvQZyI+FoOlU+l+Pn7+fgH+fgE+3j611bXIu8lDiE8ikIh4orubh7+vv5+vn5+vX/TL6M2NTVOK8UOIb2FmwaAz/Xz8jIX4+FWWVxqnwn+E+GgU2o5l7+Ls4uzkbG/n8DLy5cLcAgzBZ6dnBfkFFmYWSGYRAU9A2aBZTLuSohLTu7BIKIoIj8BisK8KX11d3jOeAgDMzMwEBgSRSeTmxmYAgFAgjI2OZdAYNdW1C3MLqSmpOAzuVeErtVotFovzcvNYTFZeTt7C3MKrwiJLC8vvztzCAACwsrwS4B/g5uLW3dVjuM7OvGRfBvgF2OJs37x+w75gI29Ocrn8/bv3OAzOy8Nr8csSZIDGRscfTvzysgoalfY0+Onc7BzyOqLVaBPiEnAYXE52zsnJCYCBTqcTCUXnZxcryyujo2ONDY3PnoYQ8MSI8IiL8wsYhne3d50dnclEcntru0KuAADweLzcnNxHvzwKCgxaX1/X6w2QAZqfnX/i9QSPw09NTGm12tmZWV8fXwqZmp2VM/N5Zn5ufn5uobGhkU6le7h5jA6Pfjs5+WeID0HQzvZOUGCQ2WOzlqYWziXnVeErO6ZdYX7hxdnF6PAoHod3c3U/2D8YGhx64vnE3c29r7fP+BiG4dclr8kkMplE8XT3DPAL8PP19/fz9/P18/cLcLB3RFmjviL+7DyZSMagMS7OLogl+zzxefkianRk1ET8J55P0DZoMolMo9BscbYoG/QTzyfjY+NikRhJBTER39rKxtXF1c/Hz9/P3+eJT2R4ZHdX9z2aAYDH4zU1NqFs0CHPQkUi8crySmjIcwadyWQw3d3cP/V/0mq1Odm5ZCK5urKaw+EI+IKmhiYCnuDt5X2wf4BMaF+yL7Ozcoh4YnpqukKm0Gp0iDGHhoR2v+9eXFicn18Y+DQQ8jTk119+LSstu7q62tvdS0lKwePwsTFxVxwuAMBgMHAuOSlJKWQiOfx5eF9v35eFL/Nz8yPDI77evjgMrqaq5t4MZqMXq9WTE5P2dg4kAml0eFQukyPGaTAYdDqdUqlcWVph0Jl0Kr3vQ59ELDE+1JWqmelZvC2eRCBNTkwqlcrFhcWw0DBbHB7xRET5Q4NDHsHdWO0AAB0xSURBVO4e7q7ufb19Go1mbXWNSWeSCKT+vn6pRIqMus7OzgoLXpk9Nr8h/oqR+LXVtQijxSJxclIKnUp/Xfyax+UhlddqtUkJSWgUGiG+UChsaW7BYXBenl6nx6cmEl5eXlaUVxAJxMCAQD6XD0FQZ2enHcv+ideTT/2fkI5QKVVlb8qwGOztV6IHRXXqv4nqKBXKqYkpMolMxBMnxiYUCsXB/kF6WjqJSIqOip6bnVtaWl5aXF78snRyfILM+j4wV8fL06ujvWNpcQmRjbUNqUR6E8p/SFTH3DImOnb687SpkOOjY+NczcOI39rcymKynB2d6+vqx0bHhgaHBj4Nzs7Mcq94AAZIro6FmUVgQGBNVU1+XoGbqzuFTElPSz86PELUKpfJ42LjcFhcRloG8uoH4K8WpsMwGB0Z83T3ZNAZfb19pjE+g8aora49Pzv/0POBTCS7u7qfHJ/Mzc75+/m7u7l3d/UcHhwW5Bc8gPirAf6Bbi5u3V3d0C3i+/v6k4iktx1vldeTQhqNZm52jkKmuDi5zEzP6nWG8bGJHyI+g86Mfhm9u7Nr8reszCwcFpeeln54eAhBkFAg7OvtS4hPDAwI9PX29fTwZNAZtjjb8LDw87NzZIzv5OBkx7Tr7+tHFqcIBcKyN2WPfnkUHRV9dHSElLyyvBIcFGyLsx0dHkUmKl2dXTEojKODk5+vn6+3r6+Pn7ubOwaNcXJ06u/rN7roX0R8xM0K8gsf/fo4Iz1jemo6IizCydG5rbVNq9Hubu+6urjiMLihgaHysnIHe4fI8MiV5RWkAqaoTmhIaHdX9/LS8tLi0tLi8tLi0tLSckF+IYVMeRr09KtcHTyRQqa2NLcuzC8sLS4tfllcX1vncXmIhqcmpzzcPRh0RkpySnVVTVxsPN6WQKfSP/Z9lEiM/LqO6jCsrWyaGptmZ2eRctZW1y7Zl18h8vq7SqmampxiMe2YdObO9k5nx1tvL+8XkS8TExJdnF1Kiksu2ZdBgcF2LLuR4REkNQvJzgwLDRMJRUioTSwSF78qJtgSkhKTZRKZVCx99jQEh8HRaXQvTy8/Xz9fH18vTy8ahfb418c52TkX5xd7u3vJSckUEiU/L980U723uxcZEYnD4Bg0hvcTb18fX18fX+8nPmQS2cbKpvT1m+8G7gAQi8Xv370n4omeHp4nRyc3Q0YYAGCM2uEwOE93T2PmFfJQN0DHR8cO9g6W5sjLhwwhPpVMbWxoMpn39OdpPx8/F2eXrq4uhUIxPjqOtkHbsew31jZMEyRIFpOFmcU9xK+pMxE/5Zr4fC7/XuKz2ezS16UoG1RMdKxGpTE1QS6Xd3d1MxlMN1e3o4Mjg8HQ2dFpx7R7akoQh4FGo2ltacVhcS8jX26sb/wA8e/G8QG44lxVlldaWVp5enjt7uzq9XokV4dKoebnFWjUN1PDJjU9MFfn2dNnKysrNxd+Y5S/TXwkV6cgv+CrXJ2He/utmdsAv4C1tXWdTq9Ra9RqjVarRSYMTdmZGekZJ8cnx0fHdbV1SKpcc1MzMkTVaXVFr4rIJPKzp8+mP09/exeFXNHa3Eqj0DzcPJaXlsF1HJ9BZ1ZX1QgFws2NzZBnoWgbdFtLW35eAYvJSkxI3NjYOD09y8vN/yHiIy5kIj6ZRO7uusnH16g1M9MzFBLFxdlldmYOIb6ryw8Qn0lnxkbHHuxdLywCIDcn1xZnixBfKpEODQ55eXox6IzwsIjsrOziouKw0DAk2mgivqODk4O940D/AFJboVBYXlb+6JdHsTGxx0fHSMmry6tPg5+aiN/T3ePk6ESwJQT4BcTHxcfGxMbGxMbHxifEJxTmFy4tLmnvXVf8J4gvlUj7PvShURh/P/+iwiIXJ5fgoKeTk1MAAA6HkxCfYGFukZOdEx4WbseyK8wv5FxybhPfFmubnJS8s3M3V6ejvfPbmVskV2fxy6LxTeVrj0Di+O5u7l3vu644VwvzCwnxCShr1MsXL9dW15CG387VmZudM051/qZHQAZof2//echztA26+313clKyt5d3fW19Z8fbJ17ez0OfDw8OM+jMZ0+fbW5swjB8OzvTlI8vEUuKi0oIeGJSQpJMIhMJxUEBQTgMzsPN42Xky7jYuNiY2LjYuIT4hLiYuK73XQKBYG93LykxiUahFRcVm6xoe2s7PCwcb0twd/OIjopGLoyNiUtMSExMSPrUPyD6vv0LhcL2tnY8Du/r48c+Z381Uw2AXC4fGhjCorHeXt5rq+umxFMIgs5OzpwcnSzMLfp6+6RSKUJ8OpXe1tJmqtjM9Iy/X4CLs0vX+y65XD48OGxtae3k4LS7s2uaceTxeA11DbezM03Er6upMz6WHkD88/Pz4qJilA0qMSFRp9GZ2qtQKD70fGAxWa4urgf7h0bis+xCQ0Ln5uaNRWm07W0dOMwfJj5iuxAsEomGBof8fP1srFFFr4qEQiG4zsenUWiF+YXGadKvPxcXF7k5ub/+69eS4hKBQHCH4ybihzwNuT8780eIX1jw6m525o8TP9A/cGd799tCTLk6+Xn5SHbm8dFxfm4+lUINCgwyrZz62PfR3dWdSWdWllcaZxGuSzDoDasrqwlxCUQ8MS4mDjkq4BmJX1VZLRKKEItBozD+vv6ODk6ODo5tre1iseT09PSG+N9fgWWM6ri69XT13BnjEwnElqYWZGIKAKBQKDraO7BorK+37/LSCmSAxsfGf5T4MVExNxPUAOTm3hD/5PgkKzPL3Mw8Oip6Znr27PTs6PDodclrKpn6POT5PcS/HuOXvyl/9MujmOiY7xF/aHDIzdWNSWeWvynf2d7ZNH02Nvd29kRCEdLwP0F81B3ia7XajfUNJ0cnGoXm7uZOIpBMCyPFYnFzUzPKBuXm4kan0V2cXDraOtQqo33+NvE72+/Jx0eIv7S4bFrVdWNC18Q3ZWeqlKqZ6RknRycCnlBZUcm+YIPrFVgI8RfmFoxR79/zCC6XW/r6jYWZRVxsnLOTS2jI88mJyYX5LxHhkXZMu5SkFCwa+6rw1fn5ObhegXWH+GKxuLiomIAnJiYkyaQyhVz5IuIFFoNNiE8cGxnb3to2ddT66jr7gq3VaE3ELykqMbXx5PgkJiqGQqYkJiTNTM9sbW0hV21tbm2sb3AuOXdy529bpkwq6/3QSyKSHewdV1fWjAkt10dVKtXM9AyJQHKwc5gYm7i93nVtZY1CphLwhPGxcaVCaSJ+a0urqWLXxHftet+lVCo/T33GYXAMOmNuds44kALg4vyiIK/A3OyeqM4d4tMQ4vPuJz73iltdVY1GoZ8GPeXzbtJGBXxBQ30jmUQO8AvgXnGvozq3iA+ABiE+1jbqRdQDiA/fxPHLSsvOTs+4XC6bzd7d2evu6gkLDcPj8EGBwWtr64g2D/YP0lLTKGRKRnoG55LD4/F4XB6Xy+Xz+AqFAoJghPiPfnmUm5O7t7fH4xpPEPAFSoXSlJ0Z6B84PjaOXI6IUCi8WYnwAOJbmltmZmSdnpyabsHnCxRyxR8g/vbm9re+cSs7Mw8hPmSApiangoOCiQRidla2RCKBIfj05DQ1JZWIJ/o88Xnb+fb8/FwsFiOJHNtb24UFhSwmy93N4/27LmRNzR3iazSa1ZVVF2dXlDXK0twyMjxyaXEZhuAHEn91ZTUwINDJwam1uVUqlirkCp1Oz7nkBPgH4DC4tJS05aVlmVQmk8l2dnaio6KtLKxSk1MPDw6vZ25dfiiqc4f4ebl5JuLvbO+8iHhhZWlVUVbB5XIVCsXa6hqSuWEa4+9u7yLE/9T/6Svi/3o/8UeGRzUazfraeuizUBqFVvyqmH3BViqUKpVKIpYc7h9y2Jw/HNIBN/n4d4kPw8ZpOjQKbW1lTSKS62rrkGgygmk6jY62QVuaWwYFBk1OTJoqYFyBhcUZiX9Lh0bi3zfGZ9CZoyOjnEvOjS8IhEiIFiG+p4fX4MAgUo5CriwtKcXb4r08n4wMj6hUKuOaWyrdxtpmaGDo/PzC5FZCoVCj0dzbdrlcMTI8irZBU8hUDBqbmZG1t7t3dHiUn1eAQWNpFBoeh+/90Ivs8GEkPuk+4tsSEuITpVKZXq8vLirG2+LDnodPjE+IxWKVSiWTyTiXnJ2tHZVChaTnJiUmUSnU28SXSCQF+YV0Kj0yInJ+bl4qlapVarlMfnF+cXx0LJPI7qn/tcK1Wu3C/IKHu6eNNaqqsuro8EgulyvkCh6Xx7nkyGXyo8Mjby9vLAZb/Kp4a3NLJpXJ5fLjo+O6mjprS+sA/4DtrW2dTncv8WenZ43E7+rWaXU727vOTi4YNLaivOJg/0AuV4hEosnJyQC/APPH5qbszJWV1Zcm4kMAACCVSNNS0qgUWm5O7uHhoUKuUKvVCPFNM7cKueJjXz+DzqBRaJ8+frriXCkUSqlUujC/kBCXQCQQMzMykSff94hv+6PEtzC3CA0JrayorKqsLswvDH8ezmSwCLaEoICg0ZEx0wBkf38/PS0dyRaoKK+oramtqaqprqxuqGtYXlzWqDXn5xc52bmPf30cGBD4pvSNcRO0iqrW5taV5RW1Wo3E3exZ9pnpmbU1xt2jaqtr33a+VciVpsz0S/ZlRXkFFoMNCw27h/gxseaPzf19/asqq037rLU0tXxZWETA+vvEV6pbmlpYDFaAX8B3iZ+TZ/bILDcn1xhXAYDL5dXXNZBJZCaDOfBpANmwYnxs4nnIc1usrYO9Q3Zmdvf77v6+/qbGpojwCAqZwmKwSopKuBwuUoKAL4iJiqHT6FUVVQhEBAJBTlaOtaU1BoVB8uUBAKenp3k5eRbmFokJSb8R1TncP4wIi6CQKPFx8R/7+menZ2VSOZKPj7JB0an0jLSMgU8DgwOD2ZnZtlhbUwgY2VfH2cmZQWf8zr46CPHflDNojDvEz8nOwWFxaalphweHR0dH6WnpFuYWT4OfDg4Mjo+OZ2dmsxgslA0q7PlNVAfZ8uUO8X/55y8xUTFHR0cm4gcHBeOwuOGhEY1GI5VIy0rLmAymo4Pjq8JXkxOTczNzPV09L19EdXa8/TP7xnwvqgNgIJPKaqpqcBicuZm5i7PL4KdBpMIGg4F9wfb18UXZoKwsrNJS07a3b4wHIT4WjU1KTNrZ3gHwV5M6He0dDDojMCDw9i4LSPp5WkpaVWVVTXVNTVVNTVVNZ8dbLpcLQdDk5KSbq5unh6eJ+AaDAcmCxWKwqcmpmxubOq1ucWGRRqVZWVqnJKeaPKK6srrrXdfJ1+v7TKLX6Q/2Dlxd3KytrDEoTEtTi0goEgqFbzve4nF488fmLk4uG2sbSCo6n8dvqG+4s8uCWCwuflWMx+ET4hOlEhkEQZ+nPnt5eBHxxOiX0d3vu+dm5oYGhkpLSmOjY0+PTw16g5H4ZOrtqA4AoP9jPxK4j4mO+fTx08LcwvDQSE52TnFRyfbWtvGk73Qi+4JdVFhkY23DpDNfF78eHhoZGxmrramtq6k7PztXKpWVFVUkIglJiBj4NDA6MlpRVuHk6IzFYOvrGkQiEQDgy8KX5yHPaRRaa/Mt4s/M+vn6OTs5d73vAjAQiyQ5WTkYFMbRwbHsTdnoyOj7d++jo6KxGKylueUN8ZdXXka+ZNKZpplbjVpTVFhEo9KCAoOam5o/T34+2D9AcnVsrG1ys3OPjo5gCN7b3UtMSETZoDzcPJoamibHJ/s/9qckpzDozCde3qPXy32Qldshz0LmZo1RHY1G09bajkVjHxbVuU59efTLIysLK0tzS3Mzi8e/PrY0t3SwdyjIL9jY2LjR+DXxrSytLM0tTWL2yAyHxVVXVkvEkvPz86zM7F//9auVhZW5mYWFmYWlueXjXx/TqfT62npTrs7ty83NLCwtLJ2dnJHFQciN2Gx2eVk5ygYV+iz0DvG3t7djomOQCpubWSCFPP71MZlELn1ditjo7xJfpVQ1NzbTaXQ/H797iX96epqbnfvrv37Nzb4hPgBga2srOir68aPHvt6+56fnBr3BoDfMTM9GvYzCoDFmj82sLK1trFGW5pZmj80cHRxrqmouzi9MChTyhdFR0RQytbK8EiG+Wq2enZ4lEohPPJ8szC8g8dzTk9Oc7Byzx2YJcQmIUd7bCp1GV/6mnEahWZhb4G0JkREvrjhcLofr7+ePRWOJBCIBT8SgMRg0xtLcEovBVZZX8vl8cLOTmhONSttY3/gd4mu0ZaVlNAot6kWUcX0yDAAAWVlZGDQmJTnlYP9AKpUO9A9QKdTHjx7jsLZI9i2VTMXj8KEhoeen5zAMb2/t2LHsWAyWaeZWIBC+KS375//5Z9SLKON8OAxWllaQ7NLhoWHkzXJvdy8zIxOHxVmYW9jibIl4opWFFcoG1drSejdy+BcRX6PRzM3O06j0x78+Dg8LX1q62UpTqVSmJKegrFE4DK6ups6UfYEQv6SoBG2DTohPvHkSXH/aWttoVJq/nz+y39/1zC0B8TtELMwsLMwtnRydN9Y39Hr95MSki7OLm6vbQP/A7aI62zvpNAaJSG6ob5CIJUtflihkisndEJ8ye2zu4e4xMTbxPeORiCRJCUkW5pZODk6TE1M6nV6r1c7NzDk5Ov/yr1+iXkZzOBzkdjwer662Dm+LDwsNk4gkppnbVwWvcBhcfGw88iqg1+lbW1pdnFwszS2RzH0MGmNhZvHsaQj7nA1B0O7ObkJcAolIevXq1U2tABCJRE2NTQ72DuZmFmgUhkQgYVAYczPztNT0m/Xw3+lEvV5/cnQSHxuPOB0Wg8OgsWgUJupF1MXZBQRBCKnJJIqlhRUGjcFisFaWVgRbQm52roAvRNqysPAl5FkomWhMqENqNT094+Pt42jv+P7te6R1h/uHwYHBNtY21pbWWDQWh8GRiWQHOwdLC8sw005qy8uREZF0Kr2mugZcb0owMDDo6eFlYW5hY22DxOi0Wm1cbJyVhVV2ZjZi+Rq1ZnV59VnwMwtzC2sra1ucLdoGbW1l7enh+f7de9M2nO1tHXQq/WnQ09mZ2Rvit7ShbdARYRHra+u/T3wejz84MPSm9E1FeUV5WXlleWVTY/PgwNDO1o5ULDWO7q/7RigQjo+OV5ZXlr8pN0lZaVlNdc2XhS9qtVoikUyMTbwuKb19wpvSssaGpuXFZb1ev7G+UVdbV1FeUVFWYbz8TXl5WXl7W7sxuQoGAACpRDo3O1dZUdX7oe/OuqrrCpdVVlSWl93Uob6uYW52zrj3w+8RX6/Vr66sNjU2db3vMk2n3BaJWDI1MfWm9M3kxOTN5nMAKBSK1eXVyoqq6srq/b0DZPZMp9NdnF8MDQ69KiyKjYmLjopOS01rbmpeW1mTiCW3o1VKhepT/0BDXcOX+S9qpRoAAEOwXCZvb+sYHho27qkEgFgsnhyfLC0pHRocQvbd/l5b2Bfs9+/ep6WkpSanvn/7XqVQKeTKd53vaqprBwcG3719l56WERsdm59XMDY6jozFkJseHhy1NrfW19Zfca5M++3c+zEYoPm5+caGxk/9n5AHBlLJyYnJ6qrq0ZFRoUAIw7BUIp2amMrOyomJisnOyvnY1z/4abChvqGnu0cskiArdJqbmpubmvd29iAIBgAolcq52fnXJa/7P35CJooADC7Zl91d3dVV1Qf7B4j5GQyG87OLvg992ZnZyOTeq4JXI8MjfC7/DwfxbxP/5YuXR0dHt8uBIEgkFLW3tZeXlY+PjiM7ZJgQs/hlqaaqprGhcXtr+84IY3Z6trK8cnhwmMfjfVUxAEz7LZ8cnyA2c3Z6VltThzhCWWkZ4gtlb8rbWtuvLq8gCDo+Om5rbeto69jf3TcSHwYAAD6P39PVU1FeOTgwxOVwL9mchvrG2x6HSGd75+Hh0ff0o9VoF+a/VFZU9fb0ctgco3Nd8brfd5e+Lp2ZnjXmcQCgUCiWF5dra2p7P/Rq1MbdmdRq9cz0TE117dDgsCmurVSovsx/qSyvTIhLiImKyUjLaGlu2d87QDYAEPAEQ4PDdbX1pjwT45MSgsUi8ezM3JvSstiYuOiX0RnpGW873x4eHJpK/u4HBnq9ns/l937ozc7KjomOSYxPrKqsXlpcRnwThmChQDQ6MlpcVBwXGxcfG1/8qnh8bML4sgIDAMDF+cWHnt76unpjOgkMAACnJ2dvO9+1NLdsbmwi9TToDUeHR40NjclJyXExcaWvS0eGRyYnJt+UlvV+6JNJZYj19n/sb2xo/LLwxfSQVsgV46Pj+XkF8XHxlRVVJ8cnBoNhaHC4orxicnxSJBQhStBoNKfHp50db9NT02OiYpKTkuvr6ldX1m5WJACwsbbR1ND0oefD+dk5gAGAgEFv2FjbqKqo+tj30fjKC8DJycmLiBf3E1+v08tkMgFfYPqIxWK5XKHVar/d1MKgN8jlcsE3H6FQiGyCYTAY5HI5n//1Yb5AJDLuq6VWq0VC0bcliMXi2z8hYjAYlAqlQCCUSqXw17/AgOyohew0dLsEkVCkVCjhh3k7DMEqlUokEkkkkq+Sum61VKFQCASC27sUISxQq9XIrdVqjVFFwKgZHo/PZl+y2ewrzpVYLNZoNHd0CEGQTCoTCUVKpfJm8yMIQlaOmNIJDHqDQq7g8/kymey7W0pBAACg1+ulEimHw+FwOBKxBIJgCIIkYolQKJTL5RKJ5IpzxWazeVyeQqG8rUmtRisWiUVCkVar5XF5M9Mz46Pj42O3ZHR8dGRsbXVNIVcoFUqRSCSTyYy6ggCAgUKuQO6CVBsyQEqlknvFZbPZV1dcmUwml8tFIpFUIkWSKPR6vUgkEolEpj28kEv4fL5MKjPtl6DT6aQSKRKDNlUY6XSkcDabzePxFArFn/wpCYT4GBQm0D9wbHT84uzi9jyQwWAw7vUm/+pGMAwjG36JRKLbNUREqVAiK9S+NSq1So3YG7LREAzBOq1OKBTe6wvIrk3IfnOIId1GpMFgkEqlAoFAKpXpdDqdTi8S3e9T381XhgAMwSqlSigQSqVS047oep1eKpHy+fyv7PN6jzOp9CaFGlkDKBQKZTL5bSNXq9QCgfDy8pLNZl9dXYnFYtOPqOj1eplMLhSKFAqFyYpMLqBSqQR8AZt9yb5gX11dSSQSnVan0WiOj44nJ6bGvjbOsdHxqcmpg72D6x2JIZlMhsxBXl5eCgVCtUpt6hoIghQKBZ/Hv2RfXrIv+Ty+0ReuVarT6qRSKbI33I2DaLUSiUQsEt+eK9LpdCKRiMPhsNlsPp+vUCiUCiWyqxripzqdTiaViUSi23mPiK54XN7l5aVAINBqtTAMy2Ryo3VdpxjBMKzX600+y+FwEBu77e9qtVokEkmlUmSmB7lKrVKb+lEuU5ydnI2NjgUGBN1P/P9K+aPDur+jgN9Rl8FgWFleiYuJCw4Mvi1BAUH+fv4lxSXG7MPfK+fhd/yzbfmLCkd2S8aisWQSxdfbt7io2LiA5U/W8H++i/8Xyp/pJnDzRSaV9XR/eB4aFhQQdNs4A/0Dw56HdbR3KhW/s/HO/7rWfdvMv6Q+11/W19bz8wr8fPwoZCoWg5sYn1D81xP/p1P9pQJB0NHhUUN9w5vXb+5ISVFJ34c+sVD8H6/kv0M0as362npqcmpCfGJsdGx1VfXu7u6fsq6flvnnBXz1XaVQzc3OV5ZXlpaU3rbM1yWvqyqqPk9N3/8rb39bAWB7a7vsTXlcbFxSQlJqStrW5tbtfK3/TuL/lL9aNGoNn8e/4lzdEc4lRywS3xv1+v9ADAaDRCzZ3NzcWN9YW107PDxEQrF/XL6m1U8S/XmBDJBcJudecb81Tt4VT/51QOm/TH7wJ6wfKFKJdH//YG11bWN9Y3NzyxRuQuR/E/H/qvb/Z93sd1vx7+nmP6uc3/78qJ5/tAv+gzp5SEv/3QL9p63iR2v7P1ba9a/C/rBx/rfLn1Ty91X0v4n4P+Wn/JSf8lP+nfKT+D/lp/yUn/J3kf8HMC28DbDJxJ4AAAAASUVORK5CYII=" alt="" width="415" height="17" />,如果省略where条件,将删除数据表中的全部记录

注意:当删除id号以后,即使id号不连续,新增记录的id号仍是已有的最大id号加1,并不是去补充删除了的id号

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhcAAAG7CAIAAAD/jSAXAAAgAElEQVR4nO3dW68cuXHA8fkKuSNIgARwst67dIQACbK29yJpk4fkIQEC2I7tvX3R/mh5kDXhabKKVUWym+z5/x6MORw2WaxuslbWmdHtk6+/vwEAEPPJV9+dHQIAYFkff/mHA2bZEnl74zhbSXXSvL80hdK5C0v8yip2LdKPUxmXTABH++hXvztsruKpYT9K8pNdGkTq5uqfnub5j31JS6u+zhu35xWoe6jtlPsIYD0f/vJ/D5vLeKZbLterSKxdH9N13nkPynwuZRwpsK3EGPBZ8iBXiRzAH/38F79Vjh7pNJTOqbRRercYRuCold6S4q/212PwHm2uo9wSv5TYXfuOfdJ8TOkOSp3t4xRjyEcDsIAPvvh1egTcQv8viv76Tj8dLGeHdMRsz1XHLPZvD684uOVY1OPX47z/mL6wBCyN6X2dx5AHkAdjSQuABXzwr+4qcjMUiWoH+1uWzruppZ7SWiwxeI+8LWHsvIvnlp3OxUiKfSwBW8aUVlTsXw1VjwHAkmJVpNhSPT6kI8N4lHhPPddaqmO6zjvXSar0KY4jBeYNuDEhlvgDF27vKZEDmIheRW7Jri6eOJbXu6EsjUXK+PmPrvCMfcYdbdLg1fhbAm65p5a5AuPcW8alGkBnH3zxG++JcEu2unQEKP31Q0RnHHx7/v/RG9uNU9ijbVnULTtPpZB2LdKP+tS30uGuhGRMjmscV+QAZvHzX/y22iewqzkIEMOTAyxG+byI/h+MivCFAIDFfPSr358dAgBgWcd8jxYA4Jo+/ooqAgCI4s8iAIC4Dw/8Tl8AwNV88MVvzg4BALCsn/3L/5wdAgBgWX//T/91f33WJzz4ZImO/ADtZttHs8Ujqcf5ty//w9F7jFWyeRbyA7SbbR/NFo+kHudff/Jvt+efNr9fkzf2bT9r3lXayQ/ttLe3z7aPZotHapfiLPjLD1/fX2v9Rjpr3lWQH6DdbPtotngk9Tj//IOvHL3HWCWbZyE/QLvZ9tFs8Ujqcf7pP3x5UCwAgOv5k5/98uwQAADLoooAAOKoIgCAOKoIACCOKgIAiKOKAADiqCIAgDiqCAAgLq0i3s9SSv0rX7piHgfvXDU/3ucEaDHbwzZbPJJ6nCOqiHeoVbJ5lgvn58JLw2xme9hmi0cytoo0TRzt/IAunJ8LLw2zme1hmy0eyagqsiWk9u5VJO22u8QST95YHDMwjv5WdV1V3vzY4wmst/ijngTp2o4pAqrsD1t1X9wMz/+R8Rj3aUx9hJa/XVfCHXE6SON7X9+EA9cSf7HP7vLReVBUpx6XQ0uf0/MDuDTukVNiuAl7c6COfy8SzqaxsyVref9U/tbNcxruxkkvzMcpzhtjH0Ragp4H44z6eosXevMMjOPdR7v9Ytxc9ufZG48e5K6DN5imOK9RRarxWGa0PzG715t8SnYRe9qK8VjyJrVb1mu5BdV4gBGMD1v4HBgUj9Rfv3x7LxCYPm/BBapI4E67Trfq6/v/7l7Yl6azDyKF1z1vI/IMDGV82KrP8121/9B4vPs0rD5I+9+u54vxLiAw762UxHycYrveuRhScd5iH32KmEB+LPErcVZTZEmpkgQpHmCcwD6SrrI/6n3jsexT/ceA+gh8dv1KOJGBQdLNxUZ7hipyGbH/IAJgxBYro4oAAOKoIgCAOKoIACCOKgIAiKOKAADiqCIAgDiqCAAgbtC/L+LC71/ryA/QbrZ9NFs8Et9n16kicyI/QLvZ9tFs8UisVWTLFBv7tp817yrt5Id22tvbZ9tHs8UjtUtxFvBnkfmRH6DdbPtotngk9TipIvMjP0C72fbRbPFIfFUEAAAfqggAII4qAgCIo4oAAOKoIgCAOKoIACCOKgIAiKOKAADiqCIAgLgRn133DmKc1/qlLpfjXWzeWUraAyYTD6v9OS/ul/C5dPy+GxVn9yoSGMReRdLOj3PwNd7ytMXyGrikxoe8+945eNMVi1/gwoKOVSRQ5QLzPuB5Z6+yxfxbnvgHzCoeTceHfPUq4jqoD60i4UHaq0jxAN0yrqjm0bHKUkXwsKgiW/ZV8K4LRd3/dn10avLxpTuaZu2AwCahLLP41uolFjhSvl+2506LrGbgeXiBP4tcvoo05scyyLrJAYw6PuSxXTYuHvt06alonL3ekyoyv/ZHszrCuskBjKgi0lFpuVDrQRWZ3+j8eKcAVtT4kHffR6dUkcDsh1aRLeO60DtFtT2ctdkYI5fyr9yXwM0CFtX+nLvOnwPi8ZLOActVWo8/5bPrAICwP/vHL88OAQCwrL/4+ddnhwAAWNZfffTm7BAAAMv6m8/+/ewQAADL+rtX/3l2CACAZf3sn//77BAAAMv68Itf31+P+31qy1WjZ8kvD1x7Cnu04d9nXyshQEDjQ76VtExxnc+LfPLl7xy9zZONzmbHUOdnjFbKf/W+eJ8qYEV9D418tP6nc1fV+I0XFnz+zXeBcauTUUU6aqwi+lBbojVQYGJDq0hgH51YRVyh1nu+fP2Do7fZwVVEuoV6e3j2g7XnR2q//zh/EoBGfR/y4hmyRBWRTsXqhaKntz+2x+eeddgUUnl4qNOzuKj8uVHyA0BhPGemkh56t76hPn37Uz5Ni8AgxkuqVWF3UCrD5p1n5opT75znp5g64Hp6PeH64WOf5eAdtwuvZ5yvulaR2AjGq6QKYXktDbXE0dnxfksdlsgD0KLLQ64P4prirCrinf3QKhIL0d65pYrspgiHeopB+QlMAayLKiKdga4LC7pXkZTrQu8UxfZb6dAspq96sM7DGKGSf/2mBG4ZsJwuT7gyiHcfHb/jpPPBcpXWI60iAAD4UEUAAHFUEQBAHFUEABBHFQEAxFFFAABxVBEAQNyIz657x3F9HsJ7Vfu8p/P+BrryYRHl3eo4sZCASXR5aGP7ZVw8LtIhYLlK67HcZ9e3519LGQnUOe/pXPnRX+tvuToskTrgbtCJMfrc60U5B1wXFvT9s0hsKG8VSTXEuIxBVUQaVt8Vj5Z8XEbjQxvbL+Pi8crjNM5e73mNKlI82pS7q/Sf8IgMxKNccn9L6lPNWywk4FyND63l8hHnXi+7zWufvd6z+9+ujzuF0yzchLVJJ2C1s6X/Kiwl5KZWzeJbl8kPEKDsl7TD0WGZWc7PoOX+LFL8MXbqVQc0xj9ar2R611vsX0w1ML/GJ1bfL4HBD95Bu21rn73e8wJVRLq7sVMyEP9oXe63/txb8hMLCZhE40Or7JfYyAdvou097+z1nsv9jlb+Y/XuSuMrj8JUp2QgP/kleoulfyAkYB6DzrfR514vynHnurDgGp8XSSe1JGvLFAe0L2EoV36kW1DNQ7G9OpF5EcDJ2p/Y4pOv77uh8XiNipPPrgMA4qgiAIA4qggAII4qAgCIo4oAAOKoIgCAOKoIACDuAp9d727073F7x7f3r37+w9gOXE/7c27ZR4/+eZFeqxqUzXTYoWff6LvrHd+Vn/bXwCU1PuTGvWOf5eBNNzDO7lVkS7gucY3snWJpg6pIYApgXR0fcn1/zV9FOsc54htQvEO1VxGprhTblR9d4+jjV9+qrlcK2NKtuChlKG9IwHI6PuTFvebd3QdvuoFxdvzbdekU6z6+ciDqJ2lxKH2QwPjVOMc9PdtzxXbpkhHxABcjba6bei7NYGCc3b/TVzrIqhd6u+UH925S6fXuEks8rvGrd8ub58b+aTz2JQMX0/Ehlw4f1ywHb7qBcV7gd7SKJ7jyOm2xHKne8dPAlKmr6+3VX89DbApgOYPOt91JYp/l4E03MM7HrCLFa6sTeV9LU3jz3JjMQH6A62l8yL1ny+h4vAbGOfQ3fftmU8lCOl2xXUmf1P/I8V0Lr/bMO0szeiMB1tX+nFv2kX2K4/fdqDj57DoAII4qAgCIo4oAAOKoIgCAOKoIACCOKgIAiKOKAADihn4DiuvC2ET+MNcTWGl6iX5f8sa8vzRUdEHACTo+tPqWOT4e14z94+xeRY658KFOMe9ii0e/feTiDlHagSX0emL1/WWf5eAdNDBOqsj8XIvdEvrlxvZiFdlNAcyvyxOr7y/XvjixinSO8xpVpHhTt+cCgU0icL+lpzwwbD7mNbKKR9P+xOr7y7svDt5BA+Ps/u+LHHO+7KZQbmqx/yVJ65Xui+V+SYm9PUZKgTt9f92m3xcD41z0O32LB+LutdJ/La786LWhuhOUeXfDLp1SPKDGJ1baX+F9cfAOGhgnVWR+geClS6Sc5P2llmukFA9o0PkW3hcH76CBcQ76exHXUMbOllPPfkouJBC8JQ+WfCotS6cUD6jjE6vsnZ6nc1cD4+z7Z5H8KLdf1WV8+ym5kFg+8+VLhaE4vtIYuMXA6Xo9tPr+sk9x/CYaFeeVPrvO0QYAR7tAFeG/jgHgNBeoIgCA01BFAABxVBEAQBxVBAAQRxUBAMR1/+x64NelYv2rV13mF7faVyFlrJrJ3VvF/soIxd9P3zJ94/HGqcRz72BZlzRLbL32+L150Octrreo17qUeWPx6wHb+0sj6PHYp2iPx2tUnCM+dXjAVcZLjr9PIzSuIr3c8np3oaW/cnn+o7ScXvE0xll9VxnTNb43Tsv4jflRpjYGo4+vDK5HYo8/EHDg8tga+8bjNTDOa3wzfPeQpnLA0y/t4Zadk/ffGqqIPZ6WOPUZ29dlWa/U3xJ/ewzK7OExLf31eQO5sgccoMfTmMBBBsZ5jSoiPYj3loNvWF/e+y0l5yY/ScVLiv2LIW3PFQdx3YvGePRxpDgtkQTW5V2v0r8Yv2Uue3uxZ3HSjutyvWvJeWAKl+K69FszNB7XdP3jvMC/L6I8qeEHbnVSHrbSkVHsXB2nekn6Im9XnpP2eIqd9TgDgxjXFVtvsb+SimJLOpqr3TJpx3VJwUtx6vMOlc97/3F7/jzMZmCc1/hOX8tzPO3drbJHXtyo6dNjby8OJcWjD7vJT619cFc8lsYu8eTrVQZ3jV981/iWZV5vPFLyu6zLFf8u4cpV1SDD8nh2UR0cj326IXFeo4pIjeGQptKYH+/r6tTGPKePrHGo6koD8VTj9A4lrSuQz2oMSn/LdPpEyuos1yp9vOuqzhJeuH0KlzyGQEgd47FPNyTOC1QRZd5wSFMZlB9LcvL2Ys/iUNK9GB2P93nQ5622hNcVyIMr/sD41ZZB6+oyb5Wrs365EoN9lsZ4vAbGeY1/X6TYvms5+J51FMjPrfSgG/OmvKsMUnx3e06fd8u0xCN1rsZpice1rsbxd415/N5xesXTd13t81Z5+0sj6PHYp2iPx2tUnHx2HQAQRxUBAMRRRQAAcVQRAEAcVQQAEEcVAQDEUUUAAHHdP3UY+JVkY8/Y4BfgzaT999kfMJl4WO3PuXd/jY7Ha1Sc477T13v2eXs+ztlnXKmUHOm+PGYy8bA6nm+W/TU6Hq+BcVJF5teximzvKX2ASzqgiqT7a3Q8XgPj7P4v5gZGa68iW2LX2ZWvOQXiLyZqlw0pmcAldXzILfvryHhc0/WPc9Dfrg9KULEweF9f3m6x6dNzk6vv4+QHaGHfX1MZGOeIP4t4x4lVxTQpruqyHFfweeddZqQOHQIFJtblOQ/sr6Hx2A2Ms3sVCQwSW081HQ9YRYo900en2Gfp5ABG7c95bH+Ni8dlYJwXqyKW18sxBm9cu/4jcFWNj3psf42Lx2tgnAtVkS1TfKs47NJnZd/8FNu7xwzMpvFRD+yvofEEjIqTz64DAOKoIgCAOKoIACCOKgIAiKOKAADiqCIAgDiqCAAgjioCAIijigAA4sZ9M7wdH5/WkR+g3Wz7aLZ4JL7PrlNF5kR+gHaz7aPZ4pFYq0jxK2Lyxr7tZ827Sjv5oZ329vbZ9tFs8UjtUpwF/FlkfuQHaDfbPpotHkk9TqrI/MgP0G62fTRbPBJfFQEAwIcqAgCIo4oAAOKoIgCAOKoIACCOKgIAiKOKAADiqCIAgDiqCAAg7tW3PynfozKn+SO824XqTbLU/6ybtVDmARzkXkXuLfOfFKdEGJhRT2x1FVL/c+/X/I8HgEOtWEWOF8hJfknaYvljhNTfO053PCEA/l/+9yLG003572L7f4MX+1umliZtGcc4vmWKYrdd0qpDSf2943jXaxnZmAcA17erIt5Tsni6Ka/za13z6gMax7HEqUwRiHDXmC9fH2QrFY/AOI2vqwsE8IieQt8Mv713M1QF5dSLHUa7qwIDFrttGb1/y/iWMaX+3nEs8XhzGLtxAC7o6e0fq4jrXFBOJeW1dOo1ntHeE9Ayjt4zMPgtObWNY0r9A4d+sad0oTEwy4wAru/p7Y/vXrScv3mjdGBJfXqd/pZxLDFY4m+JU/rR0l/vpofR8to4HYDH8vKNu4psCeNb+gkYm7o4pnEoPU59aZY4d1dJ8VfHl/or4yhh2Nert1enA/BAXrz+4ewQAADL+pwqAgAI++yb788OAQCwrE+//v7sEAAAy/qEKgIACPv4a/5eBAAQ9fFXVBEAQNRHVBEAQBhVBAAQ9+FXP54dAgBgWVQRAEAcVQQAEEcVAQDEUUUAAHFUEQBAHFUEABDH50UAAHEf8T1aAIAwvo0RABD3yTdUEQBA1KdUEQBA2Oev+R0tAEDUizdUEQBA1MtDqsiWyNsDg6RXbSXVSfX+6VVSf2Oc1fF3V0nJqc57ImNm0s75j3nO88Et+ZT6ewPLV2ccYeY7BfT39Panw+Yq7i7XliueOMUf9cGL/XcjW8avxul9nTduz09Mfd5TSIuy9L+pa1cu0af23q9q8N51TXuzgP5OryJKu97TsmkDMxbf8h4KrlNPP1V37DGcwnva3kJVpNhueR7CvOvK+69yBwG3p7c/KUeVvkv1rSK9WwzDuMEsp0bg9KlGovS3xKnHL+U8uy2VFEkJuRnuV7GzfZxiDJY48/XqfW6GfCr99ZD0/Eh5KC5ZGaoaDLCYexW5Zf+XjvTauHUtW8v+rmU6abdL4xQ3thK5/SDQ49m1SzGnL5S1FCNveZ3HkAcg5c2enHxdWyYfvLHdGFj+Y8s4wMU9vf1R2tXG13euDva3LFPsXkvDVvtbIg/EmbcruSr2kQJTJq1eu2Xyt/Rh9RiqfXbjG+P35qoajxR8NR4ldcYZgSt4+eYHaVcrr4st1eNG2mD2jWePLdbfG7klzmo8Uhq9x5M3/94ktF+YdzPeoI731xJVeMBqZgJRAbN78fr7dEvf1P/sSlvsr3dDWRolxdOn+KMrPGWoan89TqW9+FoPUp+35R5Z5gqMUw01Fk9gOdWQ9Ekt69L7b+9ZIgFW8vk333lPkFuyJaStovT3bs7A4FtyQtnbpXUp/atxFtuLa5fmlX7Up76VDjUlJGm93qVVI9ytRUqIFHy+wPwSqX81nrx/Pl1gkHzVwKV89vUfqn0CTz8bBkixI3BZn331e+kt+3/K9boQALCYT+UqAgBABVUEABCn/D9aAABUWP52HQCAss+/+e7sEAAAy3rx+vt3L2b7rao8nuLv8jdO0XL5MfQPH5yyhMDU0q00jlPtfHAqptopwMlevvnhJn8m/CxSPB2ryCQr1VXzcFYpdc2r3ETLUNWbbq9GHS3x/ABHSL+N8Z3Tt4elcrQEuSWaAh1PCrJX8OFx7BfmPfMb2lJFTrybSzxCwHDpN8O/Uzypi32kRql/caic5dr2Dew9B5V1KQEbJ5KOQulavV0aRwnesq78En1RUpy7ZBqHKg64G8p4uTE/lghdwQPX9PStu4pIr/NrLZfkpDFvoXPHOIuxczq7NyfeqLbndn2kdvtrKbbAOJbl5I15Gl2jeePxrssyvj144LJePa8i6dmk76jUfTT75UpIlsOiffe6Riiuq7pAe6h6Po3BS/dFCSA8jjF71fFbhsrjNOZZice7RmPwwJWlVUTZ3sbdJb3l2py7DsVr23evawTl9NGDtEykJMeSz1jnxnHs2ct7bu/Zh/I+M67RAnkLTApc1qtvf7oJ/y3sfZ3/mMrHV9y7KeMX3wofJYHOljxYZgnk0xWPN87AOPYFGn+UOrgSovRpX68rA8CVvasid8qWzjeV1FnZXfa9p4xfDdU4svESpaf0VjFplinya6XBA/Hol7jGsS8tvbA4vjJFsbN91VIYgfUW2/W5gEfxlFQR+26MWXFkAIDm6e1P9U5tRhcnAMBpnt7+eHYIAIBlvfsGFAAAIl6+pooAAKLu3+kLAIAbVQQAEEcVAQDEUUUAAHH87ToAIO7lGz4vAgCI4lOHAIC4A74BBQBwWU/fUkUAAFGvqCIAgDCqCAAgjioCAIijigAA4qgiAIA4qggAII4qAgCIo4oAAOKoIgCAuGOqyJbI2xvH2Uqqk+b9pSmUzl1Y4ldWsWuRfpzKuGQCONqRfxYpnhr2oyQ/2aVBpG6u/ulpnv/Yl7S06uu8cXtegbqH2k65jwDWc3oVUdqVbnoVibXrY7rOO+9Bmc+ljCMFtpUYAz5LHuQqkQP4o1ff/qQcPdJpKJ1TaaP0bjGMwFErvSXFX+2vx+A92lxHuSV+KbG79h37pPmY0h2UOtvHKcaQjwZgAfcqcsv+rxvpdbXDTThz9dPBcnZIR8z2XHXMYv/28IqDW45FPX49zvuP6QtLwNKY3td5DHkAeTCWtABYQKCK3AxFotrB/pal825qqae0FksM3iNvSxg77+K5ZadzMZJiH0vAljGlFRX7V0PVYwCwpFgVKbZUjw/pyDAeJd5Tz7WW6piu8851kip9iuNIgXkDbkyIJf7Ahdt7SuQAJqJXkVuyq4snjuX1bihLY5Eyfv6jKzxjn3FHmzR4Nf6WgFvuqWWuwDj3lnGpBtBZWkXeqZ4It2SrS0eA0l8/RHTGwbfn/x+9sd04hT3alkXdsvNUCmnXIv2oT30rHe5KSMbkuMZxRQ5gFpbf9A3sag4CxPDkAItRqoj+H4yK8IUAgMXwPVoAgDiqCAAgjioCAIijigAA4qgiAIA4qggAII4qAgCIS6vIWZ/w4JMlOvIDtJttH80Wj6QeJ1VkfuQHaDfbPpotHom1imyZYmPf9rPmXaWd/NBOe3v7bPtotnikdinOAv4sMj/yA7SbbR/NFo+kHidVZH7kB2g32z6aLR6Jr4oAAOBDFQEAxFFFAABxVBEAQBxVBAAQRxUBAMRRRQAAcVQRAEAcVQQAENfy2XWpf+VLV8zj4J2r5sf7nAAtZnvYZotHMvYbUJT+VJGOLpyfCy8Ns5ntYZstHslp36NFFenowvm58NIwm9kettnikYyqIltCau9eRdJuu0ss8eSNxTED4+hvVddV5c2PPZ7Aeos/6kmQru2YIqDK/rBV98XN8PwfGY9xn8bUR2j523Ul3BGngzS+9/VNOHAt8Rf77C4fnQdFdepxObT0OT0/gEvjHjklhpuwNwfq+Pci4WwaO1uylvdP5W/dPKfhbpz0wnyc4rwx9kGkJeh5MM6or7d4oTfPwDjefbTbL8bNZX+evfHoQe46eINpivMaVaQaj2VG+xOze73Jp2QXsaetGI8lb1K7Zb2WW1CNBxjB+LCFz4FB8Uj99cu39wKB6fMWXKCKBO6063Srvr7/7+6FfWk6+yBSeN3zNiLPwFDGh636PN9V+w+Nx7tPw+qDtP/ter4Y7wIC895KSczHKbbrnYshFect9tGniAnkxxK/Emc1RZaUKkmQ4gHGCewj6Sr7o943Hss+1X8MqI/AZ9evhBMZGCTdXGy0Z6gilxH7DyIARmyxMqoIACCOKgIAiKOKAADinqgiAICwp7dUEQBAFFUEABD39PbHs0MAACzr5Zsf7q/P+j1ofv9aR36AdrPto9nikdTjfPmaKjI78gO0m20fzRaPpB7ni9c/3J5/JvN+Td7Yt/2seVdpJz+0097ePts+mi0eqV2Ks+AFfxaZHvkB2s22j2aLR1KPk/9Ha37kB2g32z6aLR6JoYokf7sOAIDP0xt+0xcAEMXnRQAAcXx2HQAQx7cxAgDi+GZ4AEAcVQQAEEcVAQDEUUUAAHFpFen1WUrvIMZ5rV/qcjnexeadpaQ9YDLxsNqf8+J+CZ9Lx++7UXF2ryKBQexVJO38OAdf4y1PWyyvgUtqfMi7752DN12x+AUuLHjqV0UCVS4w7wOed/YqW8y/5Yl/wKzi0XR8yFevIq6D2lBF3i7zZxGlc/EA3TKuqObRscpSRfCwqCJb9lXwrgtF3T+7Pjo1+fjSHU2zdkBgk1CWWXxr9RILHCnfL9tzp0VWM/A8TL9Hq8u4gUFclzxgFWnMj2WQdZMDGHV8yGO7bFw89unSU9E4e73nyzdUkdm1P5rVEdZNDmBEFZGOSsuFWo/03xehisxpdH68UwAranzIu++jU6pIYHZDFen3bx1uGdeF3imq7eGszcYYuZR/5b4EbhawqPbn3HX+HBCPl3QOWK7SeqRVBAAAH6oIACCOf3cdABDHv7sOAIjjX8wFAMRRRQAAcfy76wCAuL7fDD/096aLn3XwRhiY93T2OKsfClHerY4TCwmYRJeHNrZfxsXjIh0Clqu0Hh2rSHp55yiTbtvzr6WMBOqc93Su/Oiv9bdcHZZIHXA36MQYfe71opwDrgsLRvxbh96hvFUk1RDjMgZVEWlYfVc8WvJxGY0PbWy/jIvHK4/TOHu95zWqSPFoU+6u0n/CIzIQj3LJ/S2pTzVvsZCAczU+tJbLR5x7vew2r332es9Xvf92fdwpnGbhJqxNOgGrnS39V2EpITe1ahbfukx+gABlv6Qdjg7LzHJ+Bi33Z5Hij7FTrzqgMf7ReiXTu95i/2Kqgfk1PrH6fgkMfvAO2m1b++z1nheoItLdjZ2SgfhH63K/9efekp9YSMAkGh9aZb/ERj54E23veWev91zud7TyH6t3VxpfeRSmOiUD+ckv0Vss/QMhAfMYdL6NPvd6UY4714UF1/i8SDqpJVlbpjigfQlDufIj3YJqHort1YnMiwBO1s27N0IAAAfwSURBVP7EFp98fd8NjcdrVJzd/3YdAPBAqCIAgDiqCAAgjioCAIijigAA4qgiAIA4qggAIO4Cn13vbvTvcXvHt/evfv7D2A5cT/tzbtlHj/55kV6rGpTNdNihZ9/ou+sd35Wf9tfAJTU+5Ma9Y5/l4E03MM7uVWRLuC5xjeydYmmDqkhgCmBdHR9yfX/NX0U6xzniG1C8Q7VXEamuFNuVH13j6ONX36quVwrY0q24KGUob0jAcjo+5MW95t3dB2+6gXF2/Nt16RTrPr5yIOonaXEofZDA+NU4xz0923PFdumSEfEAFyNtrpt6Ls1gYJzdv9NXOsiqF3q75Qf3blLp9e4SSzyu8at3y5vnxv5pPPYlAxfT8SGXDh/XLAdvuoFxXuB3tIonuPI6bbEcqd7x08CUqavr7dVfz0NsCmA5g8633Ulin+XgTTcwzsesIsVrqxN5X0tTePPcmMxAfoDraXzIvWfL6Hi8BsY59Dd9+2ZTyUI6XbFdSZ/U/8jxXQuv9sw7SzN6IwHW1f6cW/aRfYrj992oOPnsOgAgjioCAIijigAA4qgiAIA4qggAII4qAgCIo4oAAOKGfgOK68LYRP4w1xNYaXqJfl/yxry/NFR0QcAJOj60+pY5Ph7XjP3j7F5FjrnwoU4x72KLR7995OIOUdqBJfR6YvX9ZZ/l4B00ME6qyPxci90S+uXG9mIV2U0BzK/LE6vvL9e+OLGKdI7zGlWkeFO35wKBTSJwv6WnPDBsPuY1sopH0/7E6vvLuy8O3kED4+z+74scc77splBuarH/JUnrle6L5X5Jib09RkqBO31/3abfFwPjXPQ7fYsH4u610n8trvzotaG6E5R5d8MunVI8oMYnVtpf4X1x8A4aGCdVZH6B4KVLpJzk/aWWa6QUD2jQ+RbeFwfvoIFxDvp7EddQxs6WU89+Si4kELwlD5Z8Ki1LpxQPqOMTq+ydnqdzVwPj7Ptnkfwot1/VZXz7KbmQWD7z5UuFoTi+0hi4xcDpej20+v6yT3H8JhoV55U+u87RBgBHu0AV4b+OAeA0T+tXEQDAaZ7eUkUAAFFPb388OwQAwLJevvnh7BAAAMt68ZoqAgCI+vyb7+6vu/yaU+DXpWL9q1dd5he32lchZayayd1bxf7KCMXfT98yfePxxqnEc+9gWZc0S2y99vi9edDnLa63qNe6lHlj8esB2/tLI+jx2Kdoj8drVJyff/0HR+/2+TpdZbzk+Ps0QuMq0sstr3cXWvorl+c/SsvpFU9jnNV3lTFd43vjtIzfmB9lamMw+vjK4Hok9vgDAQcuj62xbzxeA+P87KvfB8YNTtbvQuMlB9+nQQ54+qU93LJz8v5bQxWxx9MSpz5j+7os65X6W+Jvj0GZPTympb8+byBX9oAD9HgaEzjIwDg/vUQVkR7Ee8vBN6wv7/2WknOTn6TiJcX+xZC254qDuO5FYzz6OFKclkgC6/KuV+lfjN8yl7292LM4acd1ud615DwwhUtxXfqtGRqPa7r+caZVpNH2XK9hlbn017eGB251Uh620pFR7Fwdp3pJ+iJvV56T9niKnfU4A4MY1xVbb7G/kopiSzqaq90yacd1ScFLcerzDpXPe/9xe/48zGZgnIP+Hy3XUMbOyviW53jau1tlj7y4UdOnx95eHEqKRx92k59a++CueCyNXeLJ16sM7hq/+K7xLcu83nik5HdZlyv+XcKVq6pBhuXx7KI6OB77dEPi/Kzf367rT4nxwpbxvQ/uKhrz431dndqY5/SRNQ5VXWkgnmqc3qGkdQXyWY1B6W+ZTp9IWZ3lWqWPd13VWcILt0/hkscQCKljPPbphsTZ8Td9R99dy5OkPM0H37OOBuXHkpy8vdizOJR0L0bH430e9HmrLeF1BfLgij8wfrVl0Lq6zFvl6qxfrsRgn6UxHq+Bcb54/X1gXH0+7zje9UgPXDFNsQduKoH83EoPujFvyrvKIMV3t+f0ebdMSzxS52qclnhc62ocf9eYx+8dp1c8fdfVPm+Vt780gh6PfYr2eLxGxck3oAAA4vg2RgBAHN8MDwCI41+pAgDEXeBfzAUAnIYqAgCIo4oAAOLSKtL4+8v5730bRzP2jA1+Ad5M2n+f/QGTiYfV/px799foeLxGxfnUu4oERov1fJyzz7hSKTnSfXnMZOJhdTzfLPtrdDxeA+NMf9OXKjKnjlVke0/pA1zSAVUk3V+j4/EaGGf6qcO+qzqyimyJXWdXvuYUiL+YqF02pGQCl9TxIbfsryPjcU3XP86nN0M+uz4oQcXC4H19ebvFpk/PTa6+j5MfoIV9f01lYJzp92j1Gtc7TqwqpklxVZfluILPO+8yI3XoECgwsS7PeWB/DY3HbmCcL193riKBQWLrqabjAatIsWf66BT7LJ0cwKj9OY/tr3HxuAyM88W1qojl9XKMwRvXrv8IXFXjox7bX+Pi8RoY50JVZMsU3yoOu/RZ2Tc/xfbuMQOzaXzUA/traDwBo+JM/x8tAAB8+FeqAABxg37TFwDwEPi3DgEAcfxbhwCAOP6tQwBAHP++CAAgjioCAIijigAA4jr+W4dhfHxaR36AdrPto9nikdTjpIrMj/wA7WbbR7PFI7FWkeJXxOSNfdvPmneVdvJDO+3t7bPto9nikdqlOAv4s8j8yA/QbrZ9NFs8knqcVJH5kR+g3Wz7aLZ4JL4qAgCAD1UEABD2f5fqp2OUFNS8AAAAAElFTkSuQmCC" alt="" width="437" height="346" />   <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhwAAAIOCAIAAAB8gkO7AAAgAElEQVR4nO2d6brsto2udSt9knbiIfZeftJTRsfb9t9zOj0lcQYPN6pLOz/cu6IlEiAAghKlet8fflQUCHyASGIvr6pay8/efrcAAACk8NHn354tAQAA7gJNBQAA0vjwd9+cLQEAAO7Ch5/97WwJAABwFz747V8PiLJuKMc7/SgvFfsd1XHJ3i74YFwiyxylu7pzyY9UZ4tORdvueelxLfp1An76Q2QZS/beEgVKGkhqN2WtYfTWIwZ6ef83fz4sVv/iq9pX1+JiO5geL8vxrZ/y5YQo+XrtpW3cfIKWOjd1Np14n29zXMGisDOKy77fuVS3rGuvTqNPo8PERw9Bfvrrrw+LlfK8peVbrsXAAu1f05NgURs4LKpuE+2VkfTna6SZwsF4Q+sVHnHt1Wn02XS4bmgGKmdZpIKJn/zqT2vB467+vKWVtBZ7vvSwI7YEq2IUAVJe0rh0y66w6qSZwm7Q7selVtLpLYLRXrJpyt4lW62JRace2q6nOa6LKWWX3vTxfv26GGWiVHNj/XsEG33qZkqpHSpB571f/mG7khbDurEsrOpz8j5vo9laY3er6qS8K43b5S3++ih1e7zcSlLslZT7dVbDWexLSZJIZbB05dWpjHvR/UgPRZqoeMsSbHRefVhG+36dKXXwPhrI571fuJvK4j9clMHmrablbscqBpJUyVW/wt0spSxV8duRZnm9aiWHTT3bl/Z8pcSbsncVsBSkqlMZ96L7UbKoRpTqoEzpRyl+Na6iJEVkln/deFw94e/Emkp1RDeWBpXxKrqM7X5Q9FiUGKe4nHg9h3eIRa3lQVsesbdoen30kfUdAZ3N0Ha8KeyUK94SRSp4n4suo1+k4sHr3OtKeS4QRG8qy6borl3aXLX6oEJpL20A+yaxpGDX2VMrS9Bw/SWpSlDLLW+dmzqbTlxxXaW2FK2ZgjLizdcryWLsLY43Wa/OmH8pX93e7gfivPfLPyrPWBpcN5Rm0ropb4VXpCK49N8Us242fFWblG9Tp9FPU6elDgGdS2sbS+KrtVL0W+wtGhRJzbiKnqV4+s2KNfPaxW3qr46X05uqAvqrt1z2zaDKFMX/Iqcf0KlLsqcADX7yqz81bQJF5znBhbj6cr2K/iydiflepXRXQvmcivRvhybhiQAAcG3e/81fzpYAAAB34YPPjvjuLwAAeAr4lmIAAEiDv6cCAABp8JcfAQAgjUdTme39Wsr70LcvO0P0TD8G6bmc+LwCoaVH6fKjFOHgOky1UwDm4meff7u0PvF7PJKexKYySaY6zTqc1Vm9zUB6iHZXpVniYghwifUDcAIfv/02tsnHYWkkPSLXDV1CxyOJzBIf9mOfaGkGuivpeZ3bVM4KCjA7SlNRNm11n29HJJ/lrRLL3P797D0WlbwUwcZAVT/KXH1c8qOIt+RVTtGTknTuihl2tZ3rcmKsj0WhMS7AExFoKtJ1OdcypUTyuTiPIR2Xk2pe3pp4Va2v2dlI4/ZrSVvAjyWdcrAsY8xVwEPPdVMVwFPzyeumst2i+gar7mf7dEVS1efuun8zuzxU82omaJeq19MoXnouioCwH2P1mv57XO08pOjx5miMC/BEvPni701F2e3GzSbdcu3VnUF1bv9mdnlQDiNdpCWQUhxLPWPGnX7s1Sst13e4XEl+vHpK40DdAkEBnoU3X/z93V/Kbrdcly+3lP4VHmaK/+qt8MkSMLbUwRIlUE+XHq/OgB97gsaXenYxPT056tEB4O+8+eK77Utlh5d7TDJWNpt9Kyr+m1KNno1TFEvpVrVolhDlXMl5QI8+xeXHntp2YtW/EqJqLN2yywjkWx23RAR4Ol42TcW7Rb1c0TMAADh4ef2TyghG9yoAAJiFA5oKAAA8CzQVAABIg6YCAABp/PCWYgAAgARoKgAAkAZNBQAA0vjkLU0FAACS+OTtN2dLAACAu/Dx5387WwIAANwFmgoAAKRBUwEAgDQ+fvvN2RIAAOAu8It6AABIg8+pAABAGi9f8t1fAACQxMuX358tAQAA7sLLVzQVAABIgqYCAABpfEpTAQCALGgqAACQBk0FAADSOKaprBvK8U4/a41m0NJeCqEYp2DRr2SxG5FeTsW4YgLAyRz5k0r1ELGfLOVBLzmRzFz228O9fJmLlFrzuhxcXzekdKn9KM8RAC7P6U1FGVfM9KYSG9d9uo4/77lZxlL8SMLWGkbBZ1GKvIpyAKjz6VffKyeRdDhKx9Z2ULpblRE4eaVbkv6mva7Be9K5TnaLfqmwu/Ed9qClT+kJSsZ2P1UNpTcAuB4v75rKUvx/Hum6abAIR7B+WFiOEunEWV/T9Fm175dXdW45JXX9us7Hy+2FRbDk03tdaigFlGIsZQGA6xFoKouhZzQN7LcsxrvQkqWUi0WD9wRcNxiNd3qW4rCuKqnaWARbfEoZVe2bUnUNAHAHXr6MNJXqSPM0kU4Q48niPQRduTR9uo4/18Gq2FT9SMK8gjsLYtEfmLi+Q1EOAPPy8uV321NpMfxvce/1zpVlsIriv3zpkme0GXfSSc6b+nsE9zxTS6yAn8fIuFIDwFjefPGt94BYNjtfOhEUe/1M0TE6X1///33juDGEXW1PUktxvEqSdiPSSz30UjvrFUnG4rj8uJQDwKRY/vJjYJNzLkAMVg7AtVH+Rr3+z0mF8EQAALg2H3/+t7MlAADAXaCpAABAGjQVAABIw/KLegAAABOfvP32bAkAAHAX3nxBUwEAgCRoKgAAkMa2qZz1yRI+0aJDfQD6mW0fzaZHwq3z5Yvv4pOTuEpxz4L6APQz2z6aTY9EsKmsBdXB3PGz4l5lnPowznj/+Gz7aDY90riksw0/qcwP9QHoZ7Z9NJseCbdOmsr8UB+AfmbbR7PpkehqKgAAAF3QVAAAIA2aCgAApEFTAQCANGgqAACQBk0FAADSoKkAAEAaNBUAAEiDpgIAAGn0fKJesvd9Ucx1Pll6Fnetj3edAPQw22KbTY/EoV/TotjTVBK5cX1unBrMxmyLbTY9Em6db8Z89xdNJZEb1+fGqcFszLbYZtMjEWgqkT/StW6QxtObytZsN8Wipxys+gz40W8182rirY9dTyDf6ku9CNLcxBIBNLEvtua+WAzr/0g9xn0aw+2h588JK+pHHBaSf+/1Ipy/Fv1Vm9300XVQaIYeV0OLzen1AXDRuUdO0bAIe/M4ev6csJSJ15XR2FLE0n5LeWvxHI47P9uJpZ9q3Bh2J1IKeh2MEfV8qxO9dQYYh3cf7faLcXPZ17NXjy5yZ+AVk6Lzf7lHU2nqsUS0L6Dd9SofminEFl9Vj6Vu0rglX8sjaOoBGIFxsYXPgUF6JHt9+vqOgDA9bps3by/fVAIP3nXYNa8f/91d2FPTsTuR5KXXbUSdAYZiXGzN9fygaT9Uj3efhnE7+STUVNaC3XjAmyvuUqtp6ac6rhtXJVXjVm30EDEC9bHoV3Q2S2QpqVIESQ/AOAL7SJplX+q5eiz7VH8ZwO3hk7ff9MSDqeCABhjEdnOx0TRoKrch9s8lADDCFjNBUwEAgDRoKgAAkAZNBQAA0vj487+dLQEAAO7Cx7/769kSAADgLnz02Z/PlgAAAHfhw998fbYEAAC4C+//6g+P67Pef837vnWoD0A/s+2j2fRIuHX+5Bf/HZ+cxFWKexbUB6Cf2fbRbHok3Drf+9f/XF5/UvThohzMHT8r7lXGqQ/jjPePz7aPZtMjjUs62/z4X/7jce2YlspZca8C9QHoZ7Z9NJseCbfOH/3z7+OTk7hKcc+C+gD0M9s+mk2PRKCp/PsoLQAA8GzQVAAAIA2aCgAApPHjze9UAAAAuvjHzbu/AAAAunjv3/7rbAkAAHAXfvqL/zlbAgAA3IX3f/3HsyUAAMBd+PC3fEsxAAAk8bPP/vK4zvqEp9eJMW7wi2iujzfZ0lgq2hMWE56W/nVe3S/hc+n4fXeQzu1ffkxJMuDE3lS2xs9zDnaugO2I5RrglnQu8vS9c/Cmq/bCwMQ2279Rn1L0cU0lYHwP7E23Wn/LBnjCqsKzkbjIr95UXAe1W+cnb7+JT05RkNFUqufpWuBSNQ+JTZemAk8LTWUtvuveNdHKtqmkMLpSpX/pAW+LeICwSVDSrN66escFOJJyv6yvOU1Zi+POwzdvvy2j9hBw4pryhE2lsz4WJ9ctDoCRxEUe22Xj9NjDbU9FY3S3TprK/PSv1KaH6xYHwAhNRToqLRMdkd58QVOZndH18YYAuCKdizx9H53SVALRz2wqa4FrojdEczxcxNkwKpfqrzyXwMMCuCj969x1/hygx4t0DlhmOcK8fPmdXxsAAEANmgoAAKTx8uX3Z0sAAIC78PIVTQUAAJL4lKYCAABZ0FQAACANmgoAAKSxbSrj3sdtmeU1y1Lb4+EY7DqbH0ZR7jb9xCQBTELKoo3tl3F6XEiHgGWWI0xiU9lOHyF6W4vAIwzHPR1XffRr/ZbL4BKlA3gw6MQYfe5loZwDroltcn9SibnyNpUtHRovw6CmIrnVN8mzFR9uQ+eije2XcXq8lDqN0d0679FUqied8rAV+wlPzIAeZcrjlmTTrFtMEsC5dC5ay/QR514Wu81rj+7Wmf6L+nGH8rYoi5CqdCA2jS32V8HSURa1iVZv3aY+AAGU/bI1OFqWGcv5mcPlflKpvowdgk2HRv2jySqmN9+qfbXUAPPTuWL1/RJwfvAO2m1be3S3zhs0Felhxw7NgP7RpDx+fRtY6hOTBDAJnYtW2S8xzwdvovUd3uhunS9Xe/dX+bL5sCX/ysqY6tAM1Kecoo9Y7AOSAOZh0Pk2+tzLQjnuXBPbbL9Qsj9J/RDXZ3nNyme51n6sqzpfC6oO7SkMxVUf6RE061AdbwYyJwFwMv0rtrry9X03VI+Xg3Ty1fcAAJAGTQUAANLY/jlhAACALmgqAACQxpu3NBUAAEiCpgIAAGnQVAAAII1tU0l83/SI90FX3x4e0Jal5zD/dvvm506M4wD3o3+dW/YRn1MZ0lQGid66HXoUjn7YXv+u+vRfA9ySzkVu3Dv2KAdvuuN0pjeVdYNrisuzN8SlGdRUAiEArkviItf31/xNZazO3Kby8HBwU5HaTHVceenyo/tv3mrmKwm2mFWTUlx5JQFcjsRFXt1r3t198KY7TmfiL+qlQy3dv3I+6gdr1ZXuJOC/qXPcYlpfUx2XpozQA3AzpM21qOfSDBynM/EnlbWGfaLXrDzHd0Gl690Uix6X/+bD89a5036rx54ywM1IXOTS4eOKcvCmO07nDd79VT3QlevtiOWE9frfClNCN/PNstfrEAsBcDkGnW+7k8Qe5eBNd5zO52wq1bnNQN5rKYS3zp3FDNQH4H50LnLv2TJaj5fjdA59S3GuaKUo23DVcaWakv2R/l2JNy1LYymiVwnAdelf55Z9ZA9x/L47SCefqAcAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABp0FQAACCNoV/T4poYC+SXeT0CmW6n6M+lHCztJVfRhABOIHHR6lvmeD2uiMN1pjeVYyY+1aHmTbbaCeyeqxtGGQe4BFkrVt9f9igH76DjdNJU5seV7LpBn24crzaVXQiA+UlZsfr+cu2LE5vKWJ33aCrVZ7y+JiBsEgKPX1r0Abelz3tUFZ6N/hWr7y/vvjh4Bx2nM/3vqRxz3OxCKM+4an9LpHyl52J5XlJhl+coKcADfX8t0++L43Re9FuKq+fj7lqxvxau+uitorkxlLg7t5cuKTwhnStW2l/hfXHwDjpOJ01lfgLipSlSTUp7aeQeJYUnZND5Ft4XB++g43QO+p2Ky5XR2HII2g/NCxEQb6mDpZ7KyKVLCk9I4opV9s7Aw7qP43Tm/qRSnuz2WSn+7YfmhYjVs0xf6hNV/8pg4BEDnE7WotX3lz3E8ZvoIJ1vvrjPJ+o56QAATuYGTYV/OwMAzMLLl9+dLQEAAO4CTQUAANJ4+fL7syUAAMBdePmKpgIAAEnQVAAAII1tU0l5A1XgjVgx++as27wlrD8LqWLNSu5uVe0VD9X3xa8FuXq8OhU9DwNLXlKUWL52/d466HGr+VbJykuJG9OvC7bbSx50PfYQ/Xq8HKRz+zuVrKIfMMs45fjHNoLOLLbTLde7iRZ7ZXr5UkonS0+nzuZdxafLv1enxX9nfZTQRjG6f8W5rsSuPyA4MD2WY64eL8fp3L77K7Hooycapxz82AZxwGaQtnTPRirt146mYtfTo1OP2J+XJV/J3qK/X4MSPezTYq/HDdTKLjiArqezgIM4Tuf2w4+dSYanBybupkjr8jFy8PPLxfv4peIs8sKqTqnaVyWtr6k6cT2LTj26H0mnRUkgL2++in1VvyWWfbxqWQ2amJfrrqXmgRAuqnnpj2aoHle44To/efuNW50a2yW3M5Z+vXSsv6sj1WGtnSBV46af5pTtRTmurJN+PVVjXWfAiTGvWL5Ve6UU1ZGtN9e4JWhiXpJ4Sacedyhl3MfL9fV6mI3jdH78+d/KqDGkxeeaGPNvWdbTPuwmduXVfbtdTPbxqitJj+52lRex3blLj2UwRU+Zr+Lc5b9613jLEterRyp+Sl4u/buCK7OaIsOUenaqDtZjD3eEzp999pf4ZDn2iIfd9O9dx1ehsz7e62ZoY523K9joqplpQE9Tp9eVlFegnk0Nir0lnB5Iyc4yV7Hx5tWMEk7cHsJFqSEgKVGPPdwROj/87dfxyXLsEQ/bsrCUxX3wI0xkUH0sxSnHq5ZVV9KzGK3Hux70uM2RcF6BOrj0B/w3RwbllRK3ictYn65osEfp1OPlOJ0f/PpP8clCeK8fb3rS+qtWLbb+piJQn6W27o11U+4qTqp319focdeCHj2ScVOnRY8rr07/u8FSv9dPlp7cvPrjNvHaSx50PfYQ/Xq8HKTzg1//0a8NAACgxvs0FQAAyGL7v78AAAC6+PA3X7eNAAAALHz02z+fLQEAAO7Cz37317MlAADAXdh+oh4AAKCLN2+Tv1Ay8FZoo2XM+Q3wVtL+PvonLCY8Lf3r3Lu/RuvxcpDOly9GffW99yj0Wj7PUWjMVCqO9Fyes5jwtCSeb5b9NVqPl+N0jvt7KjSVLBKbyvoOxQbglhzQVLb7a7QeL8fpTP9zwgFv/U1l3bAzdpVvTgL6q4XaVUMqJsAtSVzklv11pB5XuOE6t00lkUH1qvYJ7/Xt2SW7XUyL3Iyfpz4APdj311Qcp/PTAT+peP3Eeua2Rq5mczlc4kvjXWUkgwShABOTss4D+2uoHjvH6UxvKgEnsfSa1XnCplK13K6kqs2liwNgpH+dx/bXOD0ujtN5s6Ziub4cRvHG3PWXAHelc6nH9tc4PV6O03mhprIWVG9V3V766MytT3U8XTPAbHQu9cD+GqonwEE6Px3zi3oAAHhGaCoAAJAGTQUAANKgqQAAQBqDPvwIAADPCE0FAADS2H6hJAAAQBdvvkj7eyqL8HkR46x+54Pino5dp1SirHGA6zLofFtrHKMnhjeoW+f2Lz92Jrmd7nKV9Ri8+q9yaBp1SvXPuga4NIPOt53byZtKIKh7ykef/aUnnhT7lKZyV2gqAP08eVNZNwQmOiZ88Juv45NrsVf1Sx6ViT2W1XopL6X6hus+lM51YHkupX04NMCcJC5mxVX/aTaUzsPExE9/+QdXAEv4ccXSPUtNQpqYsjImxNssdfvr1gFgBJc+N45Q+N6//VdWvN0JbndlN95ZSi2kHLz0YdpZTP25XHqHANhJWc+J++WU/RUI6p7y43/5j554UuwDmorxfLQ3lbD+0cTqUx1UUu6JCzA//es5saOk6AlwhM4f/dPve+JJsSdpKo+R5mnbdH4iRjGSfu+1KyjAVRh6vh1xWGdwhM5/+Pn/64lXDe/14zo0d0i3SrdN++24XdUBhOtTveWyT8sB4Gw6l7SyX2LOD95iuv7mREekf/j5//XLAwAAqEFTAQCANLb/+wsAAKCL//Pzfz9bAgAA3IUf/fPv20YAAAAW/vFf//NsCQAAcBd+8ov/OVsCAADchfd//aezJQAAwF346LM/ny0BAADuQuIf6QrDh7d1qA9AP7Pto9n0SLh1fvI2888Jx7hKcc+C+gD0M9s+mk2PhFvny5ffLep3Z40bPyvuVcapD+OM94/Pto9m0yONSzrbvHz5/ePaMS2Vs+JeBeoD0M9s+2g2PRJunZ9+RVOZHeoD0M9s+2g2PRJdTQUAAKALmgoAAKRBUwEAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABp0FQAACCNT7/6XvnulzmZX+GDnVRvkSX7sx7WhSoPAOfwaCqPkfkPjlMUBiLqhW1mIdmf+7zmXx4AcCZXbCrHE6hJOWU7YvkhQ7L3+kmHFQIAIi/F71SMh53yr2b7v9Cr9pbQUtAeP0b/lhBVs13Rmq4ke68fb74Wz8Y6AMDTsWsq3kOzetgp1+VcV1zdodGPRacSIqBwN1imrztZa70k4KfzupkgAMCrpmI/KdZ3LIYmoRyCsbNpNyvgsGq2Fuj2Pf4tPiV7rx+LHm8NYw8OAO7Po6m4jgnlkFKupUOw88j2HogWP7plwPmyOcSNPiX7QA+oWkoTjcIsEQHg6TigqSzFgdi0d0X3+rFosOjv0Sm9tNjrZrqMnmtjOAB4agJNZd1gvKUfiLHQVZ9GV7pOPTWLzt0sSX/Tv2Sv+FFk2PPVx5vhAOB5Kd/9BQAAEISmAgAAadBUAAAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASIOmAgAAadBUAAAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASIOmAgAAadBUAAAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANI4pqmsG8rxgJPtrLVGM6huv50l2Rt1Nv3vZknFacY9EWNltsbly7LmpXNLPSX7Z4MiwDkc+ZNKdWW7lnv1AKq+1J1X7XeeLf6bOr3X1cNxdz0bUlIW+8XQVKov9dDe53VLlPUMMJDTm4oyrltazrJAxOot74HuOgT1Q3aHXcMpWETq+eo2iivLenhCskpxlRUI5/Py1ffKyaVv2nKRbQelu1UZxvVqOUQCh1FTiWJv0anrl2pePJZGiaSCLIbnVTW2+6lqsOgs89VtFkM9FfumnhF1W19j96PfkvxUp1RTtsfdZQeg8WgqS/HzsnTdNFjUpSwpsSxZPZxxRyn2unL7vtL17MYlzdsLJZeq8p7rUkMpQKqbvThlXmtB6bxzXNfTeV3NRbfXNay1+uh+dM/GXMpwAA4CTWURFpzLwH7LEmJ3Lblt2luUB3SW40qtqjaSMCVoc+5aUN7S3eoamjY7/0b93lrZ9eh+doP2ujX97/zo9dHjSrcs+UpxAXzEmkp1RDeWBpVx3bIZLmDvVW7R2dQjlVEpbzOoJQtvEfonlmbGB5T4fO1OpOje9C0iq9e7ErmSUiR5427vBgTA06E3lWWzmGIbY4t9UELaYOVLlzzFVdNe16mMV691kXrcnmdkiRXw05Qa0xNIxyKm87p82elzV6JAnauW3rjbu8ag8NRsm8oPNDfGsllh1fVa3loLlFgSdufbXWEfl/JS7Js6q+PV3KW40ks99FI7LxRJUr7e1JoKd7lIBZHElwmWUyT7ph5JkjFf3bi8luJWbfQQzbzs+qWX1RGACpa3FAcWE+sP4E6wo8GK0lS8/yzqnwgAANeG7/4CAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASKP6hZKr8H7/H6ZI47u75Yj3LWGlZUDP1sYYV7FXUpN09o/bZVcpa2Wx7497IoHFlhtaEtMvKeAhfRVZLKdaP1Oth/vzw08qu8yrZ5DrunToOteqZpLPpkPvepKMd35GX+ti7KQU/4qckkX1CS6vl2uu/xFTOp3MuX4mWQ/3p9pUHrjOwZ0T+7lZDaofr1sD3aHkTbe3+Bl9rUuyJ+Uqvstsck7JQl8/4/yPxhV3zvUz1Xq4M2VT2ZbAdQ7uyuc6N0tKs10gKa4yJRDU6MeboMWPPr6tgD1WeV31U53StN+NSy8VP3oKxrhNAXodLPXRddpvKXVTblmU2P3b/eiD1fIqoctBo31Tp2RfjjeLbNSjj1uU34ptU1Get2W8+WyU512iPKH19frTRUrejEEtfiSpUkTpVmCKBUm/5dl55/b4TNSvC5Cud/K8Ou1ZxPRkhc7Kq+nWXs+dTaz+TXvFSfNZBK6fF+NPKvoi2A2WLyU/CqXlukFyVQbd4Q3a9KO4bSq0jFvu6kjPSLpeilLH/Dyu19fPS4nb1G/JS5o4Wqc3C6+erNBZeSk6pXR27FxV61+1t6RpMaj6V+pTDeHVeX8m/J2KZKY8e2WWK2jT0r7I7PbeoNtBbyWND6X6TMPXO1dK3KZ+S17SxNE6vVl49WSFzspL0SmlI8WyPD67HqNBU7BRWP8Duhs3e/eX5Nz14BXjcEEC15aMvJU0xq3e6vFjzzdFvz2pnUiL5hilB6+erNCJeVVrJYVQ4jYfn0Vn095Yh6zr58XyOZUfLJvj25fKSLPuVTHVW9Vx3aGhJKJIqT5GPZJ9049RczMdxXlVz+6WZC/5t8w1Jqj718el1KrajPl6cenXX4bjjsur6rMaQsm3qkS5pejR6yxJdY0r/i06bw6fqAcAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABp0FQAACCNY5qK/v7ugBPpfe7lG8wtb1ov7aU3p1veje71v5slFacZ90SMldkaly/LmpfOLfWU7J8TZaWlFOfJywsVjvxJpbr+XIuyegBVX+rOq/Y7zxb/TZ3e63JwfX2A6nFPQUrKYr+ouStT9NDe53VjyieirPMU//DsnN5UlHHd0nKWBSJWb3l3jusQ1A/ZHXYNp2ARqeer2yiuLOvhCQlsgRkFiCgAABORSURBVET/PIVnpPo1LY+7+qYtF812ULpblWFcf5ZDJHAYNZUo9hadun6p5sVjaZRIKshieF5VY7ufqgaLzjJf3WYx1FOxb+oZUbf1NXY/+i3Jj5KOlHWnHsW/dBfuzKOpLMXPxdJ102BRl6ykxLIE9XD2RS/Z68rt+0TXsxuXNG8vlFyqynuuSw2lAKlu9uKUea0FpfPOcV1P53U1F91e17DW6qP7sVN6aOZYygCoEGgqi7CwXAb2W5YQu2vJbdPeojygsxxXalW1kYQpQZtz14Lylu5W19C02fk36vfWyq5H97MbtNet6X/nR6+PHre8Zclar4OkB6BOrKlUR3RjaVAZ1y2b4QL2XuUWnU09UhmV8jaDWrLwFqF/YmlmfECJz9fuRIruTd8isnq9K5ErqSalN68ei/9EwXAZ9KaybBZHbGNssQ9KSBusfOmSp7hq2us6lfHqtS5Sj9vzjCyxAn6aUmN6AulYxHRely87fe5KFKizQunBq8fiv1MkXJJtU/mB5sZYNiumui7LW2uBEkvC7ny7+u3jUl6KfVNndbyauxRXeqmHXmrngiJJytebWlPhLhepIJL4MsFyimTf1CNJMuarG5fXUtyqjR7CSyAv6WUzSo9OuCSWtxQHFgfrCeCZ4QR4XpSmEv5nUda/pwAA4GLw3V8AAJAGTQUAANKgqQAAQBo0FQAASIOmAgAAaTyaymzv15LeL78Kb/mPheiZfgzScznxeQVCS4/S5UeyPL4IU+0UgLn4oak8Nskku0XSk9hUJslUp1mHszqrtxlID9HuSjI7t7MeHxdgdoyfqD8SSyPpEblu6BI6ntEnadiPfWJpWT5Q3ZX0vE5/jpdYQgBHozSV6mm+fSkNSvZVVyWWuf372XssKnkpgo2BpPNRmquPS34U8Za8yil6UpLOXTF7XCnjihNjfSwKXdEBnoJAU5Guy7mWKSWSz8V5DOkEDqPldV7emnhVra/Z2Ujj9mtJW8CPJZ1ysCyj15V9+uLPy5KvPTrAs7BrKtujSt9gWx7e7NMVSVWfu+v+zezyUM2rmaBdql5Po3jpuSgCwn6M1Wv673Rln27U483RFR3gKdh99b2023sOKfv0qkF1bv9mzjqMdJGWQEpxLPWMGXf6sVevtFzf4XIVyM7oKuw5EBrg/mzf/aXsdst1+XJL6V/hYab4r96yb/J+Y0sdLFEC9XTp8eoM+LEnaHypZ2cZ1y3783VVAOCJ2H34Udnh5R6TjJXN5j0ClOPGeBgpno1TFEvpVrVolhDlXMl5QI8+xeXHntp2YtW/EqJqvNYWoVGMtz76eDMcwDOybSqu/Rngip4BAMDBAV/TMrpXAQDALPDdXwAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABp0FQAACANmgoAAKRBUwEAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABp0FQAACANmgoAAKRBUwEAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABIg6YCAABpHNNU1g3leKeftUYzaGkvhVCMU7DoV7LYjUgvp2JcMQHgZI78SaV6iNhPlvKgl5xIZi777eFevsxFSq15XQ6urxtSutR+lOcIAJfn9KaijCtmelOJjes+Xcef99wsYyl+JGFrDaPgsyhFXkU5ANR5+ep75SSSDkfp2NoOSnerMgInr3RL0t+01zV4TzrXyW7RLxV2N77DHrT0KT1Bydjup6qh9AYA1+PRVJbi//NI102DRTiC9cPCcpRIJ876mqbPqn2/vKpzyymp69d1Pl5uLyyCJZ/e61JDKaAUYykLAFyPQFNZDD2jaWC/ZTHehZYspVwsGrwn4LrBaLzTsxSHdVVJ1cYi2OJTyqhq35SqawCAOxBrKtWR5mkinSDGk8V7CLpyafp0HX+ug1WxqfqRhHkFdxbEoj8wcX2HohwA5kVvKstmk1cPIMv1zpVlsIriv3zpkme0GXfSSc6b+nsE9zxTS6yAn8fIuFIDwFi2TeUHmgfEstn50omg2Otnio7R+fr6/+8bx40h7Gp7klqK41WStBuRXuqhl9pZr0gyFsflx6UcACbF8pbiwCbnXIAYrByAa6M0Ff2fkwrhiQAAcG347i8AAEiDpgIAAGnQVAAAIA2aCgAApEFTAQCANGgqAACQBk0FAADS2DaVsz5ZwidadKgPQD+z7aPZ9Ei4ddJU5of6APQz2z6aTY9EsKmsBdXB3PGz4l5lnPowznj/+Gz7aDY90riksw0/qcwP9QHoZ7Z9NJseCbdOmsr8UB+AfmbbR7PpkehqKgAAAF3QVAAAIA2aCgAApEFTAQCANGgqAACQBk0FAADSoKkAAEAaNBUAAEiDpgIAAGn0fKJesvd9Ucx1Pll6Fnetj3edAPQw22KbTY/EoV/TotjTVBK5cX1unBrMxmyLbTY9ErN89xdNJZEb1+fGqcFszLbYZtMjcVBTWTdI4+lNZWu2m2LRUw5WfQb86LeaeTXx1seuJ5Bv9aVeBGluYokAmtgXW3NfLIb1f6Qe4z6N4fbQ84t6Rf2Iw0Ly771ehPPXor9qs5s+ug4KzdDjamixOb0+AC4698gpGhZhbx5H4u9UwsU1GluKWNpvKW8tnsNx52c7sfRTjRvD7kRKQa+DMaKeb3Wit84A4/Duo91+MW4u+3r26tFF7gy8YlJ0/i/3aCpNPZaI9gW0u17lQzOF2OKr6rHUTRq35Gt5BE09ACMwLrbwOTBIj2SvT1/fERCmx21zg6YSePCuw655/fjv7sKemo7diSQvvW4j6gwwFONia67nB037oXq8+zSM20n/L+rL3Lz5BOIutZqWfqrjunFVUjVu1UYPESNQH4t+RWezRJaSKkWQ9ACMI7CPpFn2pZ6rx7JP9ZcB3B74RP2d4IAGGMR2c7HRNGgqtyH2zyUAMMIWM0FTAQCANGgqAACQBk0FAADSoKkAAEAaNBUAAEiDpgIAAGnQVAAAII1Bf0/FBe/71qE+AP3Mto9m0yPR9Yl6msqcUB+AfmbbR7PpkQg2lbWgOpg7flbcq4xTH8YZ7x+fbR/Npkcal3S24SeV+aE+AP3Mto9m0yPh1klTmR/qA9DPbPtoNj0SXU0FAACgC5oKAACkQVMBAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASIOmAgAAadBUAAAgjdxP1Lu/JcYTd2eWpbbHwzHYdVbrX3x/T/1u009MEsAkpCza2H4Zp8eFdAhYZjnCJDaV7fQRore1CDzCcNzTcdVHv9ZvuQwuUTqAB4NOjNHnXhbKOeCa2GbQd38NbSpbOjRehkFNRXKrb5JnKz7chs5FG9sv4/R4KXUao7t13qOpVE865WEr9hOemAE9ypTHLcmmWbeYJIBz6Vy0lukjzr0sdpvXHt2tM/0X9eMO5W1RFiFV6UBsGlvsr4KloyxqE63euk19AAIo+2VrcLQsM5bzM4fL/aRSfRk7BJsOjfpHk1VMb75V+2qpAeanc8Xq+yXg/OAdtNu29uhunTdoKtLDjh2aAf2jSXn8+jaw1CcmCWASOhetsl9ing/eROs7vNHdOi/37q/yZfNhS/6VlTHVoRmoTzlFH7HYByQBzMOg8230uZeFcty5Jra5x+dUtkEttVsLqg7tKQzFVR/pETTrUB1vBjInAXAy/Su2uvL1fTdUj5eDdPKJegAASIOmAgAAadBUAAAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANK4wSfq0xn9/nGvf7t983MnxnGA+9G/zi37iM+pDGkqg0Rv3Q49Ckc/bK9/V336rwFuSeciN+4de5SDN91xOtObyrrBNcXl2Rvi0gxqKoEQANclcZHr+2v+pjJW54ivafG66m8qUpupjisvXX50/81bzXwlwRazalKKK68kgMuRuMire827uw/edMfpTPxFvXSopftXzkf9YK260p0E/Dd1jltM62uq49KUEXoAboa0uRb1XJqB43Smf0uxdK41J3rNynN8F1S63k2x6HH5bz48b5077bd67CkD3IzERS4dPq4oB2+643Te4N1f1QNdud6OWE5Yr/+tMCV0M98se70OsRAAl2PQ+bY7SexRDt50x+l8zqZSndsM5L2WQnjr3FnMQH0A7kfnIveeLaP1eDlO59C3FOeKVoqyDVcdV6op2R/p35V407I0liJ6lQBcl/51btlH9hDH77uDdPKJegAASIOmAgAAadBUAAAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANIY+jUtromxQH6Z1yOQ6XaK/lzKwdJechVNCOAEEhetvmWO1+OKOFxnelM5ZuJTHWreZKudwO65umGUcYBLkLVi9f1lj3LwDjpOJ01lflzJrhv06cbxalPZhQCYn5QVq+8v1744samM1XmPplJ9xutrAsImIfD4pUUfcFv6vEdV4dnoX7H6/vLui4N30HE60/+eyjHHzS6E8oyr9rdEyld6LpbnJRV2eY6SAjzQ99cy/b44TudFv6W4ej7urhX7a+Gqj94qmhtDibtze+mSwhPSuWKl/RXeFwfvoON00lTmJyBemiLVpLSXRu5RUnhCBp1v4X1x8A46Tueg36m4XBmNLYeg/dC8EAHxljpY6qmMXLqk8IQkrlhl7ww8rPs4TmfuTyrlyW6fleLffmheiFg9y/SlPlH1rwwGHjHA6WQtWn1/2UMcv4kO0nmnT9Rz0gEAnMwNmgr/dgYAmIUbNBUAAJgFmgoAAKRBUwEAgDRoKgAAkAZNBQAA0kj/RH3gjVgx++as27wlrD8LqWLNSu5uVe0VD9X3xa8FuXq8OhU9DwNLXlKUWL52/d466HGr+VbJykuJG9OvC7bbSx50PfYQ/Xq8HKRzxIcfD5hlnHL8YxtBZxbb6Zbr3USLvTK9fCmlk6WnU2fzruLT5d+r0+K/sz5KaKMY3b/iXFdi1x8QHJgeyzFXj5fjdN7jq+/TJU3FAZtB2tI9G6m0Xzuail1Pj049Yn9elnwle4v+fg1K9LBPi70eN1Aru+AAup7OAg7iOJ33aCrSunyMHPz8cvE+fqk4i7ywqlOq9lVJ62uqTlzPolOP7kfSaVESyMubr2Jf1W+JZR+vWlaDJublumupeSCEi2pe+qMZqscVbrjOG/w9FWXhhtff1ZHqsNZOkKpx009zyvaiHFfWSb+eqrGuM+DEmFcs36q9UorqyNaba9wSNDEvSbykU487lDLu4+X6ej3MxnE67/EtxZZlPe3DbmJXXt2328VkH6+6kvTobld5Edudu/RYBlP0lPkqzl3+q3eNtyxxvXqk4qfk5dK/K7gyqykyTKlnp+pgPfZwR+i8R1ORBsOSpqKzPt7rZmhjnbcr2OiqmWlAT1On15WUV6CeTQ2KvSWcHkjJzjJXsfHm1YwSTtwewkWpISApUY893BE6b9BUlLhhSVMxqD6W4pTjVcuqK+lZjNbjXQ963OZIOK9AHVz6A/6bI4PySonbxGWsT1c02KN06vFynM57/D2V6vhu5OBHmEigPktt3RvrptxVnFTvrq/R464FPXok46ZOix5XXp3+d4Olfq+fLD25efXHbeK1lzzoeuwh+vV4OUgnn6gHAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASIOmAgAAadBUAAAgjfQPPwbeCm20jDm/Ad5K2t9H/4TFhKelf51799doPV4O0jnuW4q9R6HX8nmOQmOmUnGk5/KcxYSnJfF8s+yv0Xq8HKeTpjI/iU1lfYdiA3BLDmgq2/01Wo+X43Sm/znhgLf+prJu2Bm7yjcnAf3VQu2qIRUT4JYkLnLL/jpSjyvccJ2DflE/qF7VPuG9vj27ZLeLaZGb8fPUB6AH+/6aiuN0jvhJxesn1jO3NXI1m8vhEl8a7yojGSQIBZiYlHUe2F9D9dg5Tmd6Uwk4iaXXrM4TNpWq5XYlVW0uXRwAI/3rPLa/xulxcZzOmzUVy/XlMIo35q6/BLgrnUs9tr/G6fFynM4LNZW1oHqr6vbSR2dufarj6ZoBZqNzqQf211A9AQ7SySfqAQAgDZoKAACkQVMBAIA0aCoAAJAGTQUAANKgqQAAQBo0FQAASCP3cyqBN0Hb4zadD4p7OnadUomyxgGuy6Dzba1xjJ4Y3qBunYO++t7lKusxePVf5dA06pTqn3UNcGkGnW87t5M3lUDQp24qd4WmAtDPkzeVdUNgomPCiD8n7HXV/xiq9VJeSvUN130onevA8lxK+3BogDlJXMyKq/7TbCidh4mJ3F/Ujz6Udc9Sk5AmpqyMCfE2S93+unUAGMGlz40jFI7431/ew8huvLOUWkg5eOnDtLOY+nO59A4BsJOynhP3yyn7KxDUPeW6v1Mxno/2phLWP5pYfaqDSso9cQHmp389J3aUFD0BaCq+EMpI87RtOj8RoxhJv/faFRTgKgw93444rDM4QudFP6eyi1Id37lt2m/H7aoOIFyf6i2XfVoOAGfTuaSV/RJzfvAW0/U3Jzoi8Yl6AABIg6YCAABp0FQAACANmgoAAKRBUwEAgDRoKgAAkAZNBQAA0qCpAABAGjQVAABII/cT9TH48LYO9QHoZ7Z9NJseia5P1NNU5oT6APQz2z6aTY9EsKlUvxamHMwdPyvuVcapD+OM94/Pto9m0yONSzrb8JPK/FAfgH5m20ez6ZFw66SpzA/1Aehntn00mx6JrqYCAADQBU0FAACy+P/rZpxYfsz+hAAAAABJRU5ErkJggg==" alt="" width="451" height="349" />

4.查询表达式解析

MySQL基础(三)(操作数据表中的记录)   MySQL基础(三)(操作数据表中的记录)

曾经有人这样经过,针对数据表的操作,SELETE语句的使用会占到80%以上的使用率;这样说也不为过,因为更多的时候是对数据表中的记录进行查找;

查询表达式的顺序会影响到查询结果的顺序;使用tbl_name.*是为了区分不同数据表中存在相同字段的情况;赋予别名的时候,强烈建议要加上【AS】;

5.where语句进行条件查询

MySQL基础(三)(操作数据表中的记录)

6.group by语句对查询结果分组

命令:SELECT col_name FROM tbl_name GROUP BY {col_name|position} [ASC|DESC],…;  其中ASC(升序)是默认的,DESC(降序)

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhIAAACqCAIAAAB3WTHZAAAOnklEQVR4nO3cUZLjrA6GYe9/VV7aXE3KbZCQhOSA8z4Xp9IYwwcGPP+pdB8HAAAAAOzqvGjLJ9s5e4adtvWlLpTKKSz5lVHcSqQfl1I3mQBepXtM2M+O9iiXGpGquepfj+/2x1zS0Iaf28Lz7ysnPeo85TkCwB/GQ9xyu/7aiJXrbboOOO/J2PaltCMFO3uMgb+lDblLcuCnKWeNdPxJB9O1ULqqZLDkHF6S8g/r6xm8Z5nr7Lbklyb2Vn5j77RtU3qCUmV7O90MbWsAFnXd84d8mnSPBsvntiM9xjCq1LJ0ointDDO74nUbt5yDen495+fH6wdLYKlN7+c2QxugDWOZFgCLUo4b46kRqGC/ZKl861qqKY3FksF7xp0Xxsq3PEdzHHeTdOtYAlvalEbUrT+MqmcAsI3rhj/kbd/ucOWsUc4dJYAxp9615RZLPGMX3qjD+sN2pGDewJMTYskfuPH8T0kO4Muu584hHBbSEWP53HY0LNRzSiGvP7riGevUnWVS48P8M4Fnnqmlr0A7n5K6qQaQwHsEHJe9Le15pb5+aliiDhs///7/7MZyYxf2tDODOpoDVIp0K5F+1Ls+eqe5Esk4Oa52XMkBLC2wjdn5iGHlABvT/0lYcSMAAAAAAAAAAAAAAAAAAAAAAMBLfes3LfgNDx3zA8xbbR+tlkcyyMlrY03MDzBvtX20Wh6JmPNsdAtzy7/V7y7lzA/llM+Xr7aPVssjlUs578QLxb7V7y6YH2DeavtotTySQU5eG2tifoB5q+2j1fJIdskJAAAAAAAAAAAAAAAAAAAAAAAAAMDv8v42oFRf+wMmGf3+mrfOj3edADNWW2yr5ZEk/3ERpT6vjUQvnp8XDw2rWW2xrZZH8tzfpOK1kejF8/PioWE1qy221fJI0l4b54VUnv7auFa73WLJ0xZ22wy0o18ajmvIOz/2PIHxdn/UJ0G6N3GKgCH7Yhvui8Ow/p/MY9ynMcmbVMlXcRxI7Xs/H8IJa8nfrXO7vXoeFMOu6+bQUufr8wO4TO6Rr2Q4hL1ZxduHlNXblLGyZZra+lftpcNz/N3aud7YttPtN8beiDQEfR6MPerj7d7onWegjncf3faLcXPZ17M3jx7yVsEbJp7T2033jAg0Zaw8bF/JY+nRvkRun0/5WEwRW17dPJZ5k8ot47U8gmEeoIJxsYXPgaI8Un399vO/QDC9X+flUf3wVD7wOGeOs+Hnz//ePtiHprM3IsVLn7eKeQZKGRfbcD1/DOuX5vHu07BBI/Y+zsatPNCaq9+jN2ttO91yvXI3Urffbh29i5jA/FjyKzmHU2SZUmUSpDxAncA+ku6yL/XcPJZ9qv8YwA59OR4wUOS6udhoeInYP3kAGLHFAAAAAAAAAAAAAAAAAAAAAMz51veR+R60jvkB5q22j1bLIxnk5LWxJuYHmLfaPlotj0TMeTa6hbnl3+p3l3Lmh3LK58tX20er5ZHKpZx34oVi3+p3F8wPMG+1fbRaHskgJ6+NNTE/wLzV9tFqeSS75AQAAAAAAAAAAAAAAAAAAAAAAAAA4HfN/zbg4K+XzPV7q5aVdqaFZ9hzdue/+bsy/avDdmKRgEWkLNrYfqnL4yIdApa7opc9rWfG+lvt/PvntyJBnf1+nWt+9M/6JVeFLaYO+Cg6MarPvSzKOeC60XnZo/S1cTWRcRtFrw2pWX0b/Nrk4zUmF21sv9Tl8WpzGnsf1EwcRsX09d4aZ3up22z3klK41JkYyKPc8rkk1RnOWywS8F2Ti9Zye8W5l+W2ee29P5Gz7ti9DvsQBiMdecPKlvq7sLwzDvU12b30mvkBApT9cq3wdCwzy/k51e7DTRkrD0957zE3bNCYv1rWZHrH263fnWpgfZMrVt8vgcYf3kG3bWvvfVAzcRhZJ51SrTt+y+dhg9781VIesL7QLfMTiwQsYnLRKvsl1vLDm+j8z9v7oGbdtE7FEqp9fhw+Tql95dkvdSwG5qe9RS+x1A9EAtZRdL5Vn3tZlOPOdaPzsrkDbzuBY/HoPa2z9x9f3cbPRrdB+xBKueZHegTDeeiWDzsyDwL4svkV2135+r4rzeO1S04AAAAAAAAAAAAAAAAAAADgvRK/n1vxveDu16UD2bLyPNa+vf7w9zCM5cD7zK9zyz5a+fchSnJmDaNo+q7Nlh521Y/T275rfuY/A680uciNe8fey8ObripnyjDOC9ctrpa9XWyt6LUR6ALYV+Ii1/fX+q+NzJzzw/i08PBrQ3qRdMuVH13t6O0PLw3HKwW2VOsOSmnKGwnYTuIi7+417+5+eNMtmlM6ttLbV05A/ejsNqU3Emh/mLPuMZx/dculWyryAC8jba5DPZdWUJVzsqGzJ7Ff6Wm1XUsVumkteVztDx+Pd54n61/z2IcMvEziIpcOH1cvD2+6qpxF05pVWT8N2zrS52uJ5Qz1tn8NpnQ9HG9WfX0eYl0A2yk6324nib2XhzddVc6iac2qLJ2GrqNcuXfYkfez1IV3nicnMzA/wPtMLnLv2VKdx6sqZ9YwzouEWEK19sm1x3Q3iaWd213V7bsGPqzZVpZ69CYB9jW/zi37yN7F8/tul5wAAAAAAAAAAAAAAAAAAADAe01+Pzf2SwmBfn/ttw0CI73eoj+XtrCtLzUVHRDwBYmLVt8yz+dx9Zicc3IY4dsnj8XX8w62e9bbW+5uCaUc2ELWitX3l72Xh3dQVU5eG2tyDfa80G83lndfG7cugPWlrFh9f7n2xRdfG5k5931tdJ/i+Vcg2CICD1ha1oFm2zbfMav4NfMrVt9f3n3x8A5aNOeTx/StC+Upduu/kjRe6blYnpc0scdvTCnwoe+vY/l9UZUzccCupoyVldeA9BSl+ntxzY/+MhgufaXfW7NbTyl+0OSKlfZXeF88vIOqciYOw9WUsbJyzHUvKfX3Eggv3SLNSVtfKnnHlOIHFZ1v4X3x8A6qyjk5jPCZYqxsOebsx+JGAuEt82CZT6Vk6ynFD0pcscreSTuOs1XlnB9Ge3YnxPK0bz8WNxKbz3b40pug275SGHjEwNdlLVp9f9m7eH4T7ZLzUS8fHgAgBf/+BQAAAAAAAAAAAAAAAJAo5ctIgS81xeoP73rN16vmRyHN2HAmb5e69ZUWut8TPxu5ebw5lTyfCpZxSb3ExmvP750Hvd/ueLuyxqX0G8uvB7bXl1rQ89i7mM/jVZIza1ofuMt4y/MPpsLkKK63Wz7fbrTUV25vf5SGk5VnMufwqtKmq31vTkv7k/OjdG0Mo7evNK4nsecPBA7cHhtjbh6vqpyJ01p9o/GWhx9MkQeWu7RpZ7ZKW/+ceG3Y88zk1HucH5dlvFJ9S/75DErv4TYt9fV+A3NlDxyg55mcwCJVOSeHEb49cOPtFmnlfUoefkK5vA9YmpxDXjrdW7r1u5HOv7qNuJ7FZB69HSmnJUlgXN7xKvW7+S192cu7NbudJo7LddUy54EuXLrj0h9NaR5Xd2vlPP+q6ubSl/75mFhhu5Pm4eydEd3Kw3aGt1w/tOXKOpnP062s5ww0YhxXbLzd+spUdEuurbnKLZ0mjksKL+XU+y3V9vv58fy7HlZTlXOyIWl5ZfWrtG9ZuMs+ziF78u7OvC4Xe3m3KSmP3uwpL1N74648lsKUPO14lcZd7XevGi9Z+vXmkSY/ZVyu/LcJV+4ahgxr89xSPZzH3l1+zslh6MsiHsvcvnel7mJyfryfh10b5/m6Ro1NDUcayDPM6W1KGldgPocZlPqW7vSOlNFZ7lXqeMc17CU8cHsXLm2GQKTEPPbu8nNODqP6cVqWjrJ8H35IiYrmxzI5bXm3Zrcp6VlU5/GuB73fYUl4XIF5cOUPtD8sKRpXSr9Drsr67UoGey+Tebyqcs4P47zw3jXTfrf8VvLwQ0oUmJ+jt7KN86ZcVRrpXj3/0vs9GzN5pMrDnJY8rnFNtn8rbPN728nKkzuu+X6HvPWlFvQ89i7m83jtkhMAAAAAAAAAAAAAAAAAAAB4r8nv57bfvza2ZqwZa/wFvDNp/175D04mftb8Ovfur+o8XiU5J4fRPZISYgk1f+ewM45UmhzpufzmZOJnJZ5vlv1VncerKievjTUlvjbO/5Q6wCs98Nq47q/qPF5VOXOH8eRr47y4VXZN0JoC+bsTdZsNaTKBV0pc5Jb99WQeV3fr5izqqfsm8H5+vdtgr8vlkF+3vzM/wAz7/lpKVc6shrztxN5711lwvU624wrfVr7NjFQhISiwsJR1HthfpXnsqnIWTWviLd03gXT7D742ujWva6VbZ+vJAYzm13lsf9XlcanK+YLXhuXzdozhjWPXfwTeanKpx/ZXXR6vqpyLvzbORvdSt9mtD8fc+emWp2cGVjO51AP7qzRPwC45AQAAAAAAAAAAAAAAAAAAgPea/35u4EvB9n6HjRf1+3X2nNIUZZUD+yo6386eZ/LEeDsd5JwcxvV2V1NZE+3Nv8uxaMwpzX/WZ2BrRefbrdnFXxuBTl/+2ngrXhvAvB9/bZwXgRujl82xvE3NT3R3RpQfpRkMz2ypySdteS5t/XDXwJoSF7PS1PxpVmryMClRfezqLUuvAenGlGe/IO/rUK+/7zwAFbY+N/ITTrZ4O6PtTdkr32pKL4m2cOvjcnIy9eey9R4A7FLWc+J++cr+CnQ6uCXrteFtKvbaMJ6A9tdGOH+12Px0C5Uhz/QLrG9+PSe+M1LyBPDaGL82PiXD83TY+BcZw0j5vZ9dnQK7KD3f8o/jGvk554dxXqTF6jV+66Vbfmt2WP9abk/1gPD8dC+56qeNAfi2ySWt7JdY4w9vMT3/8MbCZAAAAAAAAAAAAAAAAAAAAAAAAAAAYNK3fhuQ30LUMT/AvNX20Wp5JIOcvDbWxPwA81bbR6vlkYg5u3+upC3MLf9Wv7uUMz+UUz5fvto+Wi2PVC7lvBMvFPtWv7tgfoB5q+2j1fJIBjl5bayJ+QHmrbaPVssj2SUnAGBd/wD9NpVn94JLSgAAAABJRU5ErkJggg==" alt="" width="360" height="170" />  <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVkAAAD9CAIAAACZapPAAAAKVklEQVR4nO3dUZrjphIG0FpRsohZSXbqpd0Hvp7rMVAqkLplJ+c8tWkMBbL+aGy5E3//+icAZAEQIQuA5mey4PGkbz85zmPkcNK+/2yKpPMtKutNVv3SMnv4VjY2f/U45vtTHyevJB+zuLTv8pPXBcMF13ch2bv+YT54pf/vnx9PZ9pz5xtVXlKztTy613SMzoT3sXHOXLg/w3lXS1qa6za3Z0HSnnRLjs32jPmYb3G0vvS19e3D11zf/uIHij9j9cSLxfN/1l4cs1JSZfwfMDjif//6J3lB5PvYL+C5cfbbpLJK9Ye/mtV/2D+vYeloHe5PUuTqVhwer9n4j5H6pP2YS+tNaksqWd2cyhLy/UnWu1dSZfx8nKV9zh/+Mc7vLIjuYnh1DYdryxdc39PZyIfbkfc/X17fs7g/w709nGK23nxd/VzFqVfXVa+hL6Avpl9spc7hr1b3Z9ZntaS+/8Yg9Z9na5nayILZ0Esd6r+qdH6ZetZztpZKDScrjO4FMVxCcYrD9SbHYthnVnMy6eFzk/U+tyTD5jXU6+zHX92f1b06LGlvqNV9jqXX1V4WDFvyzrPGpD3pVtzQ+loOx1w6ZhsjLByzxfXOylhd4MkNrNR/8omHZWzvz+peJSWdHGp1hMeX4/Y8C56fk29o8nNedH0v6hu6Wl6xz8k6K4MXZ5l1O5zuzAJX17U618Y4l5d6pv6NepaGOrPP/SyPL/9ves6CpLhhn2SCpH9S+qHi4M/rr7cXp9iuMx989nBj8GTYM/O+DNLPtbTe4XRL4xRLfSm4vj8b9VcquWqoYp2zh4OWymeKS8dg+ynAjxmcoUkWrIbW+ScCt/F9BCBCFgCNLAAiZAHQyAIgQhYAjSwAIv7Mgk+5I+BT6oRPIguAiK8sGN4y3Tfe2z6rE7iA6wIgQhYAjc8RgAhZADSyAIiQBUAjC4AIWQA0sgCIkAVAIwuACPcdAo0sACJkAdDsZcHsW8PD9vzhBlkA19t477D/gwL5z88Pncbwps5cFwwbDy8ZztW7VidQdeb9gqWLf1kAb20jC27/N4IsgOt57xCIcN8h0MgCIEIWAI0sACJkAdDIAiBCFgCNLAAiZAHQ+PsFQIQsAJqWBY/OsPHe9lmdwAVcFwARsgBofI4ARMgCoJEFQIQsABpZAETIAqCRBUCELAAaWQBE3H3f4d6XC9x3CNe7MQtepqvPLgvgem+SBUuXBrIArvcOWbD6zwRZANe78b3D5ywIZzjc6/brgperg/oTv7M0+O95hyxYnV0WwPVuz4KN2WUBXM/9BUCE+w6BRhYAERF/yQIgZAHQyAIgQhYAjSwAIv7Mgrs+t1+d1P0FcL3bs2BjUlkA17sxCzbuOHx+4rfUBP9ZrguAiDd479CJDW/BdQEQIQuARhYAEW/zOcLS1LIArnf7e4fAW5AFQIQsABpZAETIAqCRBUCELAAaWQBEyAKguf0e5A2fUid8ElkARHxlwfCrAX3jve2zOoELuC4AImQB0PgcAYiQBUAjC4AIWQA0sgCIkAVAIwuACFkANLIAiBh9H+Huio59Sp3Rlbr0ZYrkexnPv/2OsvOSfnJGfs5fv/7pv/xzZ0EFtxS5MePw7J09XHr6jYfpI14h7PjELPh5G9vSP6Xf570suP0Y3V4A3+Ll/YLKYX5+HQ9fr/X/Hg77V6aeTXpmnOL4lSmG3V42rV7t8On1JyYzrrb3xfDvsfc9xf5lHaOTfDjsYf/67IdzHT59tea9Cl8a++UvDfj408Zz936ejcm/xO8s2HhpvrymD19Pebe65ETdOD1eGoen2Wqdh+MvjfnD662MuXfgeGvPnyPUn5W8tpKfZ+fAydk3zo3DcfKeG4PH07m3NGa+Xd+x3sMxBcG/0957h0tZEH/GwbDPVa/pyjiVGir1n6lz9jDf1cM6D8s483N9Rj7S7yx4lj8l6Tn71excqk/a9x+OWRwqrzNfWqXOl2fN6q+Mv7TPeRn19ebtlRn5PO47BCJkAdDIAiBCFgCNLAAiZAHQyAIgQhYAjSwAImQB0MgCIEIWAI0sACJkAdDIAiBCFgCNLAAiZAHQyAIgQhYAjSwAImQB0MgCIOKnsuCqv7c/HOcxcjhp3382RdL5FpX1Jqt+aZk9fCsbm796HPP9qY+TV5KPWV9aseean7wuGC64vgvJ3vUP88Er/X///Hg60+L7jsSKyktqtpZH95qO0ZnwPjbOmQv3ZzjvaklLc9WHutjtWZC0J92SY7M9Yz7mNx6DdX1tffvwNde3v/iB4s9YPfFi8fyftRfHrJRUGT8ZZNbzgiOY/z/U8n3s535unP12WMbqhia/mtV/2D+vYWmjD/cnKXJ1Kw6P12z8x0h90n7MpfUmtSWVrG5OZQn5/iTr3SupMn5xqL69OMjY8/9bNS/xcA2Ha8trre/pbOT+t4cbVz8ee0eruD/DvT2cYrbefF39XMWpV9dVr6EvoC+mX2ylzuGvVvdn1me1pL7/0iCHqztrIwtmBS11qP+q0vll6lnP2VoqNZw/YI/O8Ler4w/XmxyLYZ9Zzcmkh89N1vvckgyb11Cvsx9/dX9W9+qwpEuGutheFgxbDg/qbBnF5W1saH0th2NuHIOlER5fNkYetj8f1mEZqws8uYGV+k8+8bCM7f1Z3aukpAuH6tuXhnqVZ8HzHPmGJj/ny6gvoL6hq+UV+5ysszJ4cZZZt8PpzixwdV2rc22Mc3mpZ+rfqOfkUH370lCvnrMgmWzYp+/5+NOsfbYvh4qDP56Oa729OMV2nfngs4cbgyfDnpn3ZZB+rqX1DqdbGqdY6kvB9f3ZqL9SyfZQyTjDFS2rfKa4McfZsoAVF5xxSRas5t/5JwK38X0EIEIWAI0sACJkAdD8LQuAkAVAIwuAiD+z4FPuCPiUOuGTyAIg4isLhrc69433ts/qBC7gugCIkAVA43MEIEIWAI0sACJkAdDIAiBCFgCNLAAiZAHQyAIgwn2HQCMLgAhZADR7WTD71vCwPX+4QRbA9TbeO+z/oED+8/NDpzG8qTPXBcPGw0uGc/Wu1QlUnXm/YOniXxbAW9vIgtv/jSAL4HreOwQi3HcINLIAiJAFQCMLgAhZADSyAIiQBUAjC4AIWQA0/n4BECELgKZlwaMzbLy3fVYncAHXBUCELAAanyMAEbIAaGQBECELgEYWABGyAGhkARAhC4BGFgARd993uPflAvcdwvVuzIKX6eqzywK43ptkwdKlgSyA671DFqz+M0EWwPVufO/wOQvCGQ73uv264OXqoP7E7ywN/nveIQtWZ5cFcL3bs2BjdlkA13N/ARDhvkOgkQVAhCwAGlkARMgCoJEFQIQsAJp3+P8mrU7q/gK43u1ZsDGpLIDr3X4PsiyAt+C6AIh4g/cOndjwFlwXABGyAGhkARDxNp8jLE0tC+B6t793CLwFWQBEyAKgkQVAhCwAGlkARMgCoJEFQIQsAJrb70He8Cl1wieRBUDEVxYMvxrQN97bPqsTuIDrAiBCFgCNzxGACFkANLIAiIj/AZmTHTY9Py2MAAAAAElFTkSuQmCC" alt="" width="296" height="171" /> MySQL基础(三)(操作数据表中的记录)

‘1’表示SELECT后面的第一个字段;注意:尽量去指定字段的名称,不要去指定字段的位置,因为位置需要人为的数一数得到,比较麻烦;

7.having语句设置分组条件

命令: SELECT col_name FROM tbl_name GROUP BY {col_name|position} [HAVING where_condition] [ASC|DESC],…;其中分组条件“where_condition”要保证以下条件中的至少一个:1.是聚合函数的形式;2.“where_condition”中的字段同时写在“SELECT col_name ”后;常见的聚合函数有:count()求个数,sum()求和, avg()求平均数,min()最小值,max()最大值;所谓聚合函数,就是计算结果永远指向一个特定值。

8.order by语句对查询结果排序

命令: SELECT col_name FROM tbl_name ORDER BY {col_name|expr|position} [ASC|DESC],…];

MySQL基础(三)(操作数据表中的记录)     MySQL基础(三)(操作数据表中的记录)

上图中SELECT * FROM users3 ORDER BY age,id DESC;命令的执行过程:先按照age做升序排列,在此基础上再做id的降序排列;

9.limit语句限制查询数量

命令: SELECT col_name FROM tbl_name LIMIT {[offset,] row_count|row_count OFFSET offset};

MySQL基础(三)(操作数据表中的记录)  MySQL基础(三)(操作数据表中的记录)

从上图中可以得出结论:1.表中的记录是从“0”开始排序的,所以要返回第3、4条记录,应该写成“LIMIT 2,2;”   2.记录编号与结果集中id号的排列顺序没有关系;

MySQL基础(三)(操作数据表中的记录)   MySQL基础(三)(操作数据表中的记录)

从上图中可以得出结论:INSERT…SELECT…FROM语句可以把一张表中的结果写入到另一张表里;

MySQL基础(三)(操作数据表中的记录)   MySQL基础(三)(操作数据表中的记录)

MySQL基础(三)(操作数据表中的记录)      MySQL基础(三)(操作数据表中的记录)

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,023
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,513
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,360
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,143
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,774
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,852