mariadb 视图 事务 索引 外键

时间:2024-05-02 03:06:52
视图
对于复杂的查询,在多个地方被使用,如果需求发生了改变,需要更改sql语句,则需要在多个地方进行修改,维护起来非常麻烦
假如因为某种需求,需要将user拆房表usera和表userb,该两张表的结构如下:
          测试表:usera有id,name,age字段
          测试表:userb有id,name,sex字段
       这时如果php端使用sql语句:select * from user;那就会提示该表不存在,这时该如何解决呢。解决方案:创建视图。以下sql语句创建视图:
          ucreate view ser as select a.name,a.age,b.sex from usera as a, userb as b where a.name=b.name;
视图本质就是对查询的封装
定义视图,建议以v_开头
 create view 视图名称 as select语句;
查看视图:查看表会将所有的视图也列出来
    show tables;
删除视图
    drop view 视图名称;
    例:
    drop view v_stu_score_course;
使用:视图的用途就是查询
    select * from v_stu_score_course;
例:
学生表
mariadb 视图 事务 索引 外键aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfAAAAFMCAYAAAA0pO7oAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAE+mSURBVHhe7Z2LmayqEoVvOPvEM9F0MJNKp9KhzK3FQxEBAbVEe/3n8+zptnkUFLVERf/3RwghhJDbQQEnhBBCbggFnBBCCLkhigL++fv9+ff3eruPV/J+/f33339mG6I+Sd5/r3//TB1/fj/uO30+vz9TW/37+ZVevDfenn//fv4ubNZzEf9+Ql8RQsosBdwJ2yxqVkT+XaFygchi+3n9/r19RIr2IRi/pp0VFAIcAvzRgpnLMxTHXJln1KeLE0Rhj23v10u8sxX4c086XXb3+YF9NYz/EUJWJAV8Emz5/PPzc5mAh0Hog88++MYB6oPA3DCjitMHnBGwtvIs7R8mgBbarJd22z5/vxBuSWIF/GP+rc7i8/v3QwFvYhj/I4SsWAn4v5/X30s2BLn3S0TxV75zAv5+2VO6RuRXAQKnyGUmLL//cad+/W8QBHy6+Fggm2ciCOG3Jphk9lUfZ6QCnHzn6zHVZxHsIR7z6ddXENQ+C5sDQdnM01IKkvE+U5YY+kn/vEi2noa8fYZUmxlK6aJ9/ixJZbuksaINO37gp+sKJYBvzn5mywsP+LA/7bvSaDIe7Hc4C+S/w4Htj3xv2tHZWCt0Xf5iygzaP+4Pc3Ai9UE7S/ss+yrTRy7PcF9VXYSyLxFCNEgI+O/fW0Tj9ZZZLYIAvksoI4Rl+b0NkukgD+z+ksgu8owDlDDtXwWv82fg9uABcz4B5XlbTOAMApjs+/WB3pHL01Pav94nAuaCpwmctZcONuqZtc+TabNSusU++f97+tuy1S5pegTc4dogNMuS813vs/gW5cIe+XvKx+433xV8akGvvyBdmP+ivHU9w7pk+8jUxafDx/XZtmxdNmyY83afCSGHkxTwjwkWbuDiu9QoXAWsLYHe2i+Eea7yF3xd5N/lzAB1bYgUqbwdpYAVljD9zuyTg4eCkiTzDCjtL6Y1gVOCrrE/n7+hVM+SfZ5Um222S0osZ7baZY34EE6dS5JjT6FnfDP+vfc/fO/aAuJo0gXfFTF5dvhLnH/YH6l65vYJ2T5K9HG2Lhs22N9QwAk5k7SAy39TQPNBSwhPm9lTZ+FgR5rSLDgdJLN5ZoKJF/B12W4mVEMib08+YM11nOrq2+WN06ySTn6zOA3pSOYZUNpfTNsi4EK2nhv2GVJtVkqHfZk29my1Swkr4I2Y+qbSZXw3tsG3QfB9s4ALXf6Sqwv+3tpX20eJPs710ZYNhJDzyQh4AL7zg12C3zRQV7/tEPBSnom6TKcwS/WsIZXeURU8C+CAJM57S6hK+9f7cCq64xR6xKKeNfal2qyUzvVtqUe22uVwsnUqCHj4e+9jgd09Ah5S7S9x/mF/pOoZ7svVq5Sno6aPUjYQQs6nWcCtXqyvs+G7XgFP5rmoy8cGCR+kVvWUvL2415Cy04GA9S++nidMBw8O3BtgztqLDa/g2q5NHxqZz9NTCpLxPrRD101sG/XM2ufxfeU+ekrp7D5fJg485vLBVrscTsYG1C3tu95nscP6p7EV+Tj/wXemGYPvimz0A0i3S3ifRzz+1vUM/XuqtyP03RoBX9WlwgaTtxxkxl8TQo6jXsDNn8Hdqquj7lwQROBZn8LzAzubp5Qb/r60DtzuX4pDkZSdE/YmH+S5vDMaBwm2rnF5RlSdjZgVT/WcyOSZsCMOeAiOYfDdQ7meefs8c1/VtUu4D/3rb5aaybX1SRhRSZWT810BYuXquLwL3f7dLOBCr7/AF3xbrsafE0zTzq/E2Ez1UVzn5LjI1WXDBuSl0aeEfDFLAf8WAuGMBXMcJHC6AHmUgBOiRTzrJ4Qcz3cKOCGEEHJzKOCEEELIDaGAE0IIITeEAk4IIYTcEAo4IYQQckMo4IQQQsgNoYATQgghNyQj4IUHW6gzUl1Imif00Tf7GW2n7WQ/+u1JAScH8IQ++mY/o+20nexHvz0p4OQAntBH3+xntJ22k/3ot+dCwP2zluNtfj4yKuifixxX9Nh9I9XFwn3xvif00Tf7GW2n7eHG2Ara95Xa82w4AycH8IQ++mY/o+20nexHvz0p4OQAntBH3+xntJ22k/3otycFnBzAE/rom/2MttN2sh/99swIOCGEEEJGhgJOCCGE3BAKOCGEEHJDKOCEEELIDaGAE0IIITckI+C9d9Mh3b+/19t9TPF+BQ8MqIF3So7PE/qo0YbP79/Pph9XjIeQqjzPYMD+a44TvRxne/hAj+PrXuFLarG10a9bqLTh3LbuRX8cHSzgFVDAH8gT+qjRhjPElgI+c0MBn1Cre8QTYmurDZ1tjQOAn8MN129PCjg5gCf0UaMNFPBzURPBE2xXq3vEE2Jrqw2dbU0BjwhPaaxOrSAw/ftnnh/7ep3sZC4I/r5sfeLn2b5f9lm2i1MvJo106I/U8ec1pV12sNQjyPOl2UvD0+4vyX7wFP3lrH441s+6xsNGnufR3n9dfbRlX0+eBlv/1+/LpDe/WaQt0WF7XJd3lDgjKp9F/STOVJY5TGwVSnXpta9sQ6nfhayAZ9LJ7339/fbv3+tvNmWjvCLt7bkXhWvg/jtk9jGB+1Qnc87gBxUc7t/K6y3TPpMGnWjraoQ7cgzU++cXvxA+77/XWdeAbkmvv1iWfVT2l/P64Qw/87a4j4aCfQ2+eyyt/dfZR0X7OvM02LTh7+tptT2qi/z/Pf3tSImKizFTOWLD76ulvr593EdDuc22abfdkqhLt31lG8r9LmQEfCsdfC81A98sr0hve/ZzvoC7jp2+yh4x5WisS0t5fh/SuN+gA039g+9WeQo5B/hOdjpu2Eel/ju1H87ws8bxUJXnGRxoe6mPem0v5Wk/rdu5mp22p0j1m0kn5biDl3YafamKRtsncnXpsK9kQ6KtV+M929bldMm4UVNekd727EdHwMMGPtvJNsoLT/OY0yTYF6TJC/icZkrbFzEeSLu/JPvB7sj336n9cKyfWRrHQ1WeZ3Cg7aU+6rW9lKeh3f9mdtqeItNvn/evzOhEEMQWnJ5tq2+jL1XR226Jughd9u3qdyFlc0W6vIDviS97/LCPZ87Aiw4RnObx+4I0WQEP8yQRHX2U6gf87fYl/eXUfjjQzyYax0NVnmfQ13/NfVSyrzdPQ2P9F+y0PUVFv+EAtq1vG32pit52S9Qlotq+Xf0upGyuSJcV8Jo6Z9njh3088xp4mH/sEHAW+2GuS5AmKeACvl+cgpF8fwsO/F109FGqH+zOor+c1w8H+tmEt8V9NBTsq8rzDBptN7/v6KOifZ15GlrrH9Ke1talcA3c+7f7aJDvXsHvICD1Mzvg28d9NJTbbJvedkvUpdu+sg3lfhdSbS1spbP1W7fVZnlFetuzn4ME/P33Spx6mPrPNLJ0DO7qO/tOSZQV5r8IEvg432H4648SgzToQFPvOB/Uw6XF9iM/qq3S82l33GQ/uH1lfzmrH470s87xUMzzTNr7r6uPtuzrydPQUf+JnrRzXUxdjfgsmf17Fpf4Lu1EsgQDxdaNuvTZJ3T3uyXV1tvp7A1q7elKtLbnfg6egZ/BSHUhaU7sIwT5KVqdyUV+pmZfiZ22D2FDL98cXxhbj0W/PSng5ACO7SMcydu87Cm18JTWeej52TX2lWi3fTwbevnm+MLYeiz67ZkRcEKuBAPBnt76aVorexeeYN/T+0iL9Glpv932xMbE0+27Fgo4IYQQckMo4IQQQsgNoYATQgghN4QCTgghhNwQCjghhBByQzICPtLygpHqQtI8oY++2c9oO20n+9FvTwo4OYAn9NE3+xltp+1kP/rtSQEnB/CEPvpmP6PttJ3sR789FwKOB7ynFtvPz6ZFBe2ifDy3dlnRY/eNVBcL98X7ntBH3+xntJ22hxtjK2jfV2rPs+EMnBzAE/rom/2MttN2sh/99qSAkwN4Qh99s5/RdtpO9qPfnhRwcgBP6KNv9jPaTtvJfvTbMyPghBBCCBkZCjghhBByQyjghBBCyA2hgBNCCCE3hAJOCCGE3JCMgI90d+JBdXn//r1ev39v93EPnw9v21zyhLtZv/mO3GNs//y+/n5+jxhhmrDfv9P2M9BvTxUBD59U89Oc6UF1eSO4bGTy+f37fb3mJ+n8exnBf7/s03fC7XW3OHUqeo5b9CXpv5d7UpLZ39RJ7Tb010XKetm0eKLT611baCldb57giP47Io8ruGu9LUPEVuLQb0/VGTicbXQBnwPtW2bs9m/MLMKkbxF56neIvuOufQl1+BcIl//sPm7Sb0NrXXBAiJmq2QuhXz2yMU0pXW+eln7bJxZj504cYPsAXBpbiUO/PR8u4O+/X59wEvDgu5isgM9HuXaGQwFfou+4a1+S/or6pc3f+m1oq0tvPc/I09NqO34/n10wM343+/cbho4/cxU+N3o89H33DNr62/MM28dBvz2fLeAi2lPwCGbg+XogEAaBaRJwzsDL6Dvuug9RhxvMwHGQOL00wgE/3apoKV1vnhP9tluQfjkmIN71bX8le20fAwr4COi354MFHOmCoBIIOEBd5rfveETAp6gz//2W2UVYPgU8Rt9xk770kT4LZoZtN1T129BUFy+2+Dc4uKwW8FS63jwndvZfNLbkC7E9Hlujou+7Z0ABHwH99nysgMeiuw4y+OrfMsghAE6fQwGfAzE2nkKP0XfctS9Jf0G8wlmvuS5cW6l+G5rq4sXW7TG0CLj7aIgF3H1tUBNwpF2Oh75xfhV7bB8HCvgI6LfnIwU8efouIeCrwIfPq1PoKD8+PUgBX6LvuCtfulDE2uoCce8RvFK63jw9e/rvI2XZlRv2jJbUJbZ9aPR99wza+tvzDNvHQb89HyjgElBSv00JeA2JdBTwGH3HXfmSOfiSOkSz3ssEvFAXHGAW7xg36dcHoaV0m3kWOaj/XL3ng987oO+7Z0ABHwH99tQRcBFBP6v1W/343lmX969N2yPg06xpCQU8RtFxS74kff0TXneWHfVV6rChuy5SVmnNdkbAy+k28iyyt/+QXg5Qwpm3a5v1fSajsdf2iyn54CY3t3049NtTdQbex966IL0El5YZiQugS/G2+dwjKGkzkr/08gQbemm3PbwvpDS2VveiDAf7/TttPwP99vwCASfn84Q++mY/o+20nexHvz0zAk4IIYSQkaGAE0IIITeEAk4IIYTckO+5Bn7g60RJzBOupX3z9cBjbOfrRO/GN9t+BvrtqSLgZmD79aF4KEpTvgfV5d2wjCxYzxpvxaew9aa7PXqOi/Wuvk1X/Snt7x9fapZSNVWo3Ybaupj98YqGriVfpXS9eYIj+u+IPK7grvW2DBFbiUO/Pc8XcASyYA0sgl7bMqyD6tIq4KnFlLnvPb3pbo++464fXIGnkWHttPvu826sU78N67ogr6Au02f7qfehK0M/yOW2Pq7vu4eBfpY291W/LLYSh357XnAKff3YxzJ76tL4OlEPglFuJl0KUr3pbo++465EE20fB6+Wg7YdNqQPJpY+Pv+m97GnZ+TpabUdv5/93Mz43ezfb3B3v1Yc++vz1kbfd89DM7aSNfrtqS/gElTVjhJRlg8eQTDfDG652UTue09vutuj77irPswIeP2BU78Na39CXpkZeG89S+kutN2C9EvhgHhXF38pe20fCPS5VmwlCfTbU1nAcYTYOrB764J0QVAR5w6DLIJu1tklICavnyJQlirfm+726DvuWjS9b7nvzCn0i56FDvg60fTYGg593z0HzdhK0ui3p6KAI09cp2vNtK8uXa8T9chvfeCNt2JQ7E13e/QdNy2acgDlRBM39Pz+6ohY+mBC8gpn4OYatXz2Yuv2GGrEtpSuN8+JPf2HtHtO31+Nvu8eD2zQi60kh357Kgl4r4OB9rokT99JQFuVnwp8AgJQMvbh94Wg2Jvu/ug7bo1ItAlJvw2rcoqCCnHvEbxSut48PXv6j68TvRbUXy+2khL67akg4DavPgcDrXXZ+zpRlLcMhhNFIe5N9wSO9Jc6UgL1/v2dltF80N9KN/QkBTwxA/cz4s07xk369UFoKd1mnkUO6j9X73udcdL33eOwddeLraSMfnueL+ASSP1pZL+1rYneWZfG14kiGMex5+OPCBCgMoGpN90zUHTchD9NTQvhCk+hN9Wnw4ZSXfg6UVuX4Wfje22/kKtjK4nQb0/lm9h62FsXpJfgsjkjwWnIzKmoYKCsg2pvuifxhEDwBBt6abcdM37v26WxxdeJjsw3234G+u35BQJOzucJffTNfkbbaTvZj357ZgScEEIIISNDASeEEEJuCAWcEEIIuSEPvwa+Xh97Jh/39C9/c094k8/P605rY1t5wrW0b74e2Gv7++/9mm/UxNKx8Oa2n59X493wV8B+/07bz0C/PVUE/IN3cfvlPVji0pTxnroED5V4v1bLXJJ3zyaWZsRbbo1r/o7buz3cohU9xy2+PjFYRoatbeleuw1YOjiVFSfM1gXlzN9j214h4ZG0Qy0jE78O21jGTvgRfaXhE/votX0E9vgSuLPtI6LfngoCLrNSmX1O8cTNUutja2Nd3Bra0KmNY6NAKdvUA+JdWYHU+u4c4ewj3sZfD7sHJceFKEpnTK4kfTO3K+oAv5r2nutnAajHUsBLdekvZ7wHudgllCl/x9YmJlfR3x/Xs7fud7Z9RPTb85JT6OuAV6KjLhkRR5kIdC1PiaKA13BVIAgvkYR/W073M8e6nFJdessp5XmV7VJuODg4A1dmb93vbPuI6LenvoC7tzTVa2hHXT4f8yjNSTwxE5DZiflvKhf5hmJuP4eiW9q2nnjUFkDvjr7jGnAm5ZYz8NnPqk9346A0Pgj0Z5JK+6rotR0HDssx8wqviXMGfjKdvjRxZ9tHRL89lQR8djTjZE0Z99QlmhmkPq+CS/oZ6gjO23FwHchyW8vs/z5cEQhsmy+aM/cKzyr6bUgerNXWBb+L7UjhRdqcXXL1jAU8ta+KXtvfcmAcJGoqcxSu8N2TqPWliQfZPgT67XnJDBxifu7pPevIPni+ZNrtbyIzp9A3Zs8hNQIe/yYZ0KUOb7G96QD5Nmg7LsqLfQh9LnUIZ73munBtpfptWPd3Y11qhK80yy7tq6LDdnOwsDxo/ZE8ws84WMfz4KurcQn9/T4kKgduJI1+e15yDfx8J8MpdNncJ4i2LS48hS6gHn7GkmFbwO0sJLz+DduQbhHMXi85iLBbreX3QdNxUVZCDK8QMcdKwFvrUlVPHBSMdg18CZaULa1AvqP7u6bvKqDk8ySFfnueL+BYQubvjjUgb4WZ0RREJbg5h57eDibU3sy2LeAhCKRWyH2a8V/mcARajmvLSfqOmRFKHaJZ72UCnqtLPB5Spz1N+vXMFT471l3oASIc636Zx964HGD7VdT4UpEb2z4k+u2pMAMXCQ3X7kpgWb5acYu+uiCohjNgbAgw/vstJ/ez9jYBn1nMyJuC6R1RclwRCd+mc9sGM7ziKzy36LAhUZ/JV7J1wXiQMRCMh9WNRxkBN3Ucah24BWNkPlAKRDsp6qOh5LunUOFLRe5s+4jot+c1p9CbaKyLC35h4AjFvCWgmFn65vVy1G8O1H5bBl/7m/rZ4N0YyV96eYINvbTbHh6grsaUO7C5x9JJ9vt32n4G+u35PAEnF/CEPvpmP6PttJ3sR789MwJOCCGEkJGhgBNCCCE3hAJOCCGE3JBHXwNfr0uNwA1viRttUku//F3pZcK6ftP1pSfY+k39FdNr+9uMMX8zG27SXNzcxteJDs43234G+u2pLOB2nWLb0pI9dUF5BRHHetk4Y4j6SqmlDsH7vJfLZmaWS85Q77Ds1jWad0LLcVHO8o7/xRI99Ge0dKuedhuyqxsSy8uwWZ/ZsKGIpB1qGVmwZAyI3eFHvszkfIqv193k3raPh357qgo4ZrYv2c4V8OUzzd/+0WsSXOyyFuTnDiJiAQ9n5FEQ/pGZhh8oNu38pDcD0i4CMcqxAl63HO3OaDluqRzbr7Nw+c/u4yb9NkDIyz4d5t1fDvxorAe52IPScJyEW/2ByZX098floJ/FwX3VzcSiaenejW0fEv321BNwEUTzMIvNYBfTWhf8fg4q/u1IRkDNs8ix34kpBsCUsXzvZtlmILi6+nzCbRWYIN44XbiYcc/1qBeRu9LaR72UylmfbWnztX4bNsuZDh5Bbzkl+66ynTPwsVj7QZkn2T4C+u2pJODIzzpWW2ABHXURQZXJyATKnAPLXBf8rnQK3Qcg/6+9ph6kN8igmWb28n0wc0/NuqczAo+io4+6QDnzwdnyVLHdN94MPK5HyYYC5iAxml3hwAAZl/ZV0Ws7BGM5A+frRC9kcaBYw4NsHwL99lQR8DDAqQi4YE5bG2f2AutBfjkBtwEprGsYnObAtBbmRb4GfF4GN5v2iQPmWH+pJn72Mz4HbZ59hWeSfhuKPg1xLc2Kap9f7UXa5OfqGQt4al8VvbbzdaLjUOlHC55i+yjot6eCgCOozgFMS8ANJqDFTo38UgKOASDfSxBC4F/OkmQGHon5Wogl3+hGtzY774y+405MooH+kzqEM3BzXbi2Uv02lPraXpveyLRG+LxIu48Gn660r4oO293YCscEXyd6FbChxdc9T7B9JPTb83wBl0ASDuppcMcBJ8uOukjZcGoE0TmIIL+EgPub0lyaJSIOuSiUCGSljTPwg7lSxBxZATe+UZh9e6rq6Q4w3Scwl1vaV8Mx/cfXiV4B6t8j3uDuto+Gfnvq3cTmaJ+ZdtZlERStk9uP8refKYcC7pkE3L47fBL/IL+aWRXs3IzJj0HJcUuvTzRiKXWIZuBXCji+X5XP14kOhpLvnoKte1s8Dbmz7SOi356PFHAEs3XgXi4vM2QF3J5CRxbxQ10+our4+P4tn0GggJ/BxusTR3qdKMQrKaJ8nehYaPnuCST8r2256o1tHxL99lQX8Hba6lIlnC5AwuFXv42DTjFI56GA341vDmbttuMg2Y+HlUi7MdN2R/RVsN+/0/Yz0G/Pxwk4uYIn9NE3+xltp+1kP/rtmRFwQgghhIwMBZwQQgi5IRRwQggh5IY8/xr4e7nGtvYu+OWdtUKUDwl5wrW0b74eeIzt5s1Yv3cbI+z377T9DPTbU0HAkdd8x6q5OzW5vCZHR12Cu8y3tlmT7XrceD/EPrzj1m9tyzWezrGOi4Mn387rgy0pK7dcCssCo2Vk9bTbsFXPcLnYsi4FG4qU0vXmCdptX3NEHldw13pbPniugPN50+9Nhtzb9vHQb08lAd+T18700bKw6jckSTrE3Gk5mPtMUpzjuKmzJfkHlqAOWDvtf+8/u4+b9NuQqie+C5dRIdD6n/Q+dKWUrjdPywH9J2W2HTCNwjm+q8NbDtp+53eAf+bnV9RxZ9tHRL89Hyfg4ayodgsd3s+2EZD93ziy/XVPzDJHuTLTuccaVy3Ocdy1MKIPco8MLe2rod+GmnrO9NZzJNvx+/lMhx8T/jM2jKnl+HFJh+Mc370KLZ8nKfTbU/0UuhnsKqf3PmbWkzuV/vpdvnIUwPn9de7pb/OMdGuDHRjyd5zw6znSX2ZWwQizvOzzzm0fDTEDd/X0p7SxTU+FK9pQoJSuN8+Jvf2H9MsDCIh3fdtfyV7bBwKTDCWfJyn021P/JrbUs5+L9NYFzhwEtegU+PrFCx6UF4i1/O1n20bUh55NXMU5/pIVcPzr+yEUKhfAJtFsOtDqtyFZT+Pj/rvAp7ZsyFFK15vnxM7+k7IW9sdjb2jO8V09rG/B383kqMmQu9s+GvrtqS/gQCW42AMFH8zjLX0TGtL4soK/TWB0vxeRaDqB8BWc4y9tM3DXX6FomuvCtZXqt6GpnkUbCpyR58Se/kPaPafvr+Yc370EiU3z5KOGB9k+BPrt+WwBD4OalBkWmZ+BY1+r8H875/jLWggg0hmxuFDEkvXM1qVgQ5FSut48PXv67yNlhc8+T9g+NCfHOm3UDtzIGv32PF/Aa16fWKS3LracSXilwFCY10I8/x51S77b2LyG1P6Op9JDznHclAihD5N3W0PAEzPwawQc9Qzv9UDe88woa4PH2LIeI6V0m3kWOaj/XL39eLsH5/iuCnFsNbbMfrbNjW0fEv32VLmJbfP1iUV21AVHo4lAhmC3dRd5XsDJmoMdV/rNH2j5bdYD9ENmvTNuWnTXA7Fd/jrRbF0KNoCMgJfTbeRZpMP2BUgfjSnXNuOv1thr+5Ugtr4WsfV0nycF9NvzmlPoTbTWBb+vmAVkgySY8wi38YPRVYzkL708wYZe2m3HQfA0LkQ4cmnj9+mPB/v9O20/A/32fKCAE32e0Eff7Ge0nbaT/ei3Z0bACSGEEDIyFHBCCCHkhlDACSGEkBvCa+ArUF7LMjfyjGtpT7Chlx2242bQXTd3StmXru5gv3+n7b2M1WZKAr5cStb21qLOuiSW+IRb/s5ZLP8JA8pyPbnfKPAhVzi17Zf0mtfSvhztNmD9t/eHZVnIa+kzS3+T/V1LvkrpevME7bZ7cDe6GQvBGvBwKz1vwewX8Q7b6kfqYf7Fuwp6KtRMv+0jYN7B7trzH56I12THvW2/hrHaTEXAEejCJVjhqxW36ayLCHg+gEsQySnwKp38diHoqE8clL4dfac2D0qRLdXHpX15+m1YP8ilnFfvQ1dK6XrztPTaHowjlBlnAFGPxhnaavGVjLfw8+dj87B9+KswzvR99zDQ5tJ4vupxnN3mxrZfxlhtpiDgOOLeI3iddXFCHK5X9dvrnRBwN2M3sxcJHv5v8xpRCvgGyk6NvkXgWgmnUNpXpN+GNgFfj4e6upbS9ebp6bN9UUaVgMt4DKaISG+fkGjLxli1Y+4jQu5+dDrKvnsqaz8o8yTbtRirzc4XcAxiEUB/eg+bCbBu9zaddXEC7oNE+J1x9EVg8UhZ0/U4/xsMiuVBAJ+HHqPp1CjLtv9apEr7tui3IV2P4DQxDgq9cLnxsChG/HLz0aOldL15TnTYjrEkaSa7UYfUKfRUHdwZOJz+NcldWv9TM2Zje06jv9+HA33e1G4Psl2NsdpMR8DN4PSZIe+W65OddUGA8YnkbxNMJucWUU45utR1mkVIGhtQ4t+iPhTwJXpOHYplLJylfdv027BZVvj8fy+2Zly48hB4t8S2lK43z4lG21EO8pYyUnbHjyF+v4NPqJc7ADbXbyUWhKIz/TaT9/Ho+e65BD5WzVNs12SsNlObgS+yOjO4eKSMuQibB4KFDQppAQ8f+zgHIQr4NlpOjb6Y234pnKV9NfTbUFWW9/ne8VBKd+EYw3X3+Ia9eHvJWDJVQT2DWbq/YS3c7Cl0m70OWr57JrChZVLkeYLt2ozVZjrXwC8ILrMYS/lBUPA3+6RFGL+Vo9hfCTRT/ex3yyBDAV+i5NTiN2E/TP0B/yrtc8nL9NvQJODGn5b+U3ewUUrXm6en03Yj4GEiqYe09685+JUxVpkh6lofD45GyXdPA/XvEW9wd9uvYKw2UxBwjPPgGmCzw/XUxQcS3BSTFlsEDRtPEWpCUJ7MGJDWB9yFCNj9V4WbMTnWX2opiVSbgIF+G1ZlbbxCd/OOcTdTjTWtlG4zzyKdti8EfB4X/uzVNMZicDATjKnpWrgDtiTTncI1vnsMtu5tfh5yZ9uvYqw2UxFwGZIigsGpMxmd9Vm318UGhK07WRFU5Xcy255jRVSWudmGAr7NNU59uYAnZv1WeLZeoStluZs61/uEjICX023kWaSz/yYBx1ia04fXwCHGc7s4opn7WsA1fanT9hFI+F/b2cEb234ZY7WZkoDvobEumH1U/9iKuI25CJphOSh3eeo83vqPfJ/GEwLBE2zopdN2I8SY7S9FY/0u/SW43PGS8uZxtLyOrnsdnP3+nbb3MlabPU/AyQU8oY++2c9oO20ndYzVZhkBJ4QQQsjIUMAJIYSQG0IBJ4QQQm4Ir4FHbN2AU+Zbryk9we5v7TtwjO3myWq//aPnGtjv32l7L2O12fkCnljqYO40rV7o2VGXRJm4Y9wvaQm3dTWWS2KwHClOs3o4CO5gd9+ZAwC3DGgz3WPQcmqUs2zX8I5lIyB+6RaW+jXVp92G0DcWKxI2fV7K6lryVUrXmydot33NEXlcwV3rbcn6YBX3tv0axmqzC2bgrXkfUxc4evmY4WNecwoBgNAiGKLMeI0qgvN6oIjou8wXM3i/pA2CXn3Acke0nLpQDtpa2tjvQn+3HTD124CyysFzmXfvQ1dK6XrztBzQf7f1cS3fPZdtH0zxDNt1GavN9AVcBFArsIbUCPj0JrIgGFUJePD7+BQ8AutzZ94eLaduKSdY419Fvw2bwXPh8+t61QXfUrrePD2ttuP3y3Xb/hW8fsNw8Ge8wrMk46Hlu+fS1t+eZ9iuy1htpizgduC3HagfUxc4eF25KG8OhkgXBiZsq4EyCbhPa+3Eb+3Xsj94KtfzBswxfbTN3K6+LbOnihUPFMvB09Z58j34Qlwv1HXLOUvpevOc2Nt/SL88gIB4Vxd/KXttHwMKuBZjtZmugBshWw70bfrq4o/+S1sqwNkZswwGt6/uFDqQesosxAt1+HQpk1+z3XfiIqeOnjE+k/u+RL8NxeAZ+7wXW/O9K69FwFPpevOc2Nl/qzEh7R8fUAzLRb57MBRwLcZqM1UBhzhe5WRw8K14ZmYN/k1kLijVCzh2zYHa3FDl78hFYK0OpnfkQqdeCRXqoutnpeC58nkvtu6joUZsS+l685zY039Iuzw47ROTq7jQdw+EAq7FWG2mJ+BmdtAzCz2mLlsCPu2PxBbfh7N2O7tOV2Yp4EF5UZ7P40KnXggV6tEj3qDfhmzwTPp87/XqUrrePD17+s8e5NozTTiIuNPsG1zouwfS1t+eZ9iuy1htpibgcLD6GUHIMXVB+VXFrwS8ZwYeBTEK+DEUX9Np69AexDz9NuSCZ87n7ay8cMe4Ef71JYBSus08ixzUf67eRsxv4+9KvnsyFHAtxmozJQFHoO3Nr7EuQRCp2VY3lSF9EHzSAv6e71hfMduKoOrL6ReWO6Dl1IXXdEq/+Lb22+mvVkyUObtOyeelrNKabefDaw0spdvIs8je/kP6aLWFa5vxV2Dstf1iij64xc1tv4Sx2kz3JrYulOviBBxHtBgMRqzdzWjYMLMwoo53hZuBgvoF+zOiYWZjTYJyJ54QCJ5gQy/ttocHp6uD4ADdd3v3wH7/Ttt7GavNKODkAJ7QR9/sZ7SdtpM6xmqzjIATQgghZGQo4IQQQsgNoYATQgghN+Sx18A/n60Eki+WfW38DDesLZYuFVgtGzI3xP1KXdznx/KEa2lPsKGXXtvff1g6Od3MJr6/WHnxI2On6W74K2C/f6ftZ6DfnjoCLkL2Cu7UblsT3VmXxPKKcMOds0Zc3c+zSD51S8DW9YSgv6SMquRSTrjkBoGwqZkuRc9x8cY470tmuVSyULs+vG3pnpINzi8XfYu+xxeRDxjCfTmHKO2rotd2aeewXKlH+HG1BHNI9Hz3XAb2+a9Bvz0VBBx5QYx8Zv6z+7hJZ12iYGIOIhaZSL4LAbf1CkW+tK0Cplt+NoHPJhjH5WSQ+oaDb/zlNyGdfdSMXX8/u5Jd4hd3BdoOb8caWcDjNdO3FfDCMxdKy8vGQct3z2Von/8a9NtTQcAxyJfrn9ueGtRZFwlqiGl+PfcysKA+ku+GsJp6Stk/vzKL3qiAmTHLb+yvUOfA5knMC0h9KeDtrHwJ7Sgd3+ZjQMkGiC1OLYcHHl6Azb6bCXhYrtQj/MgZuBLS7kP7/Neg357PnoFLIvuGpvUsofw0NSnVDwYMDuRTGhymLD8Dz9TX1SM7K3HleCjgFeBRqgtfQj3sgdPYAi5+5//138GI8DtPuC83aEr7qui1fT0Df4XXxDkDV+AGPv816Len0jVwG2j9wIZ41tNZFwlqrzfKTYv0B6dfkwKO8oJrSZKP/xsDxASpsPo+eJpT6DJTd3XFjHweTBU2mPq6vwUKeA7bP14gwssiYQAbXsDD8rwPTfsCwn0Lxwso7aui13YZQ2Gi3fW4Ak3fPZ5b+PzXoN+eSqfQJa9wBr4Qty366gJntrFkPUuwQQb1WAZLiO5q1iBBKa5r8ndGwOfg5QU4+dsE8elGCngF7hq47R8crM2XLcYXcPc3fCb89y4CnjizhctN4Wf4/c/iDMmIXOS7h3ATn/8a9NvzfAHHQM8FpSr66rJ4M1hYlpRtnVzyDQVcvt8XA2MBt8GtLk/YOA9EEAv49rK4K9F33AnvS/JvKB5+WwliFiUbUN+pTu7gVg7eJpG+i4AnCF+na1n79Xhc6Lt7kX6/hc9/DfrtqSPgCFLRDLw+4PTUJRRtBMlopmAyQz0Sjo6XlJjd/mUl+Ps93fkMYU5WfSXgiTq/JR/35wIZiPGRc5z+LWnHRclx49eJmnLTZ3NuMQMXUE8TdI3vOEGf6gAfdfaNLuAJHzb27KqXBkr9rgBn4Fej354618Al8OJU2iSgMqjrs26vy/J0tIjmIobgxjb771rAUdY8Y5hFFN/Pwg0RXw2UCgH//P6uBTwTfJfpl/Uaj/Y+6gOvExWhcAdk5hRtxpfuIuDyhTnAnHxA/Chc5z6941vS+fETbiZdaV8V+2xHW89lBaKdFPXR0PLd86GAX41+e+oI+C4a64IAuPFjf3o7dvZYmEPB/chRwLRHAtMqNkYCbj5HM/9lmVHgjonSY+nRdBJjOJ4QCL45mLXb7sfQ0qcd7oCi/lTulbDfv9P2M9Bvz+cJOLmAJ/TRN/sZbaftZD/67ZkRcEIIIYSMDAWcEEIIuSEUcEIIIeSGPP8aeOudsJ/fv99XYrkXbiq7xU05V/CEa2nffD2w13a8PnS+Ax43ZC5ubvvBzZ6jNyj7/TttPwP99tQRcBG/7VdA5mitC34f3L0tQcU8BKV2qQ2EOnVnOGygp2e4IhDYu/jTB2elfTnabfBruLGtygp83uwPfKqYrojU8eXWjWMcLcSxtG+L3v4LloyBaHUGX2aiiY7PkxL67akg4NaxpoBiHn/ZkndvXZAuWDudmIkjkK60eiHgn783Hh4SLOcyARIzi6bnuT8dfcfFOvnc6xNL+/L027Bef4u8Ap+fPruPjtZ1u3aZo1vOiAMEEWqfvLRvm17b7dgOx0a44UCiPU9t9H33DLR9nqTQb8/zBRyCGJ96bjqt3VgXN9M2D8GYZv0i5JkZ+KzVy3XX2OxrH91BAIKir0Q00yDKjgv/kQ5ICmBpX5F+G9ZlQdiWD95J1aetjqU868rL02u7lBsOhGhccAauxAU+T1Lot+dlAp59gMmKHcElDGpw8iiTxcNZPKjvVDeUTQHfRtNx5z5ZB6zSvi36bUjX4+AZeGkcXTrGlge9fJ2oNqi/vs+TFPrtedEp9LOfhS5IAJuDyDrQ+M3Mzl0Sw0rA0+mqq/8V6DluGKTigFXat02/Dcmy4HOB76ReodtURy/S+NcLYyzgqX1V9NrO14lezVU+T1Lot6f+TWxytDi9famKnrpIGpkJ2NPfCKTh7CT+HIEgONUNZTuBhw2+EhKobhenTkXLcdF38wHXMmCV9tXQb8O6LKkLhDScgUeP6QVNdfQi7T4aYgF3XxvOFnCUGR0U83Wi2lzn8ySFfnvqCHhEm6N11MW8UQzpls4dBpcpyMTRJQhM/16SD2fgFSg5rohSqi/MM7dL+1zyMv02rPy5UlDbxgEOCmZ/BnP60r4ajuk/vk5UmQt9nqTQb08VAX/jpSAuLwTan/i0dZHGuiB4mkCJdKlycNSacHAn3Fnnl/1cRpbjmkBQEqk2AQP9NqzKMr4keUUz8GoBd74YHySOdxd6AMb1KgMZa8Mf6V7ju2eg6fMkhX57XnMKvSnfxrrIzNv+FOkaBHwL2EBPz3BNILhcwBMzoEmvSq/QLaUDGQE3dXyNtA7cgraeD04C0U6K+mhc47tnQAG/Gv32vOQUehu9dUE6K+Dh06HMTWsuQPrv1oEyAdJU/fAbeUIgeIINvbTbHo6plWi4AxS+TnR0vtn2M9BvzwcLONHjCX30zX5G22k72Y9+e2YEnBBCCCEjQwEnhBBCbggFnBBCCLkhX3MN/P3eewMa6jH6Qymu4gnX0p5gQy/H2I5nn6eeODc27PfvtP0M9NvzMAHHEobsXanIT3GJS1gXv73wUJZiHngYhlsH7u+iXag1bLjDXbVXoOW4KGe++9n00bTeubSvhn1+lvL5N5b1uNUOyxUMpX0l4IO5cVTat0W77WuOyOMK7lpvizlocn6EJbpN3X5z28dDvz0Pn4Gn1iJe95AJpA3XgluRhrP7LfkktuC7cLnMIl3Tw2iejpbjlsrZW4f+9Cmfx3fhMqqPeTqg+7uwr0RpHF03xhy3XWap5bsngH6WNvdVj/1qmxvbPiT67akg4BDNpdilAl6e9rp40Y0fhYoAt5hFpx40sRJwX3epx5S282Ewj0XLcUvl7K1Df/oan58p7StRGkfaYwy/n8eVmfG72b/fMISmcdh0MKHNXr8ZiVbfepLtI6DfnucLOAQxFjsRztXMN8uORkE5C4eWvCoFHMEnDELxdo+HVGih5bgoJxKO6ZxhaV8N/TbkfN6f0sYGnzK/KO0rURpHV44xA9IvhcOPn/HZa/tAoM+b4tKDbB8C/fbUE3D864/EVYKLTecfZ2mLk++yAo7fzwJg4uLnIz/xgSlMK0e6TQPl6fT20U7ca2KTrlTal6TfhqTPm7L9d9a3zG9K+0qUxlFpXxU7+28xjsCdxsdFvns4rf4OnmL7KOi352Nn4KgHgmT4OFXzmafQT6DfX3ZT8iUlEWvy+d7xcEaeE3v6D2mXs+9VewzNhb57GLCh4iBwxRNsHwn99nzkNXAEL5s/0oZly+dmAecp9G30HXeiJFRKIpb0+ayglvaVKI2jC8bYxEfKCp99nrBvaC703UNA/XvEG9zd9tHQb08FAUd8UrxDdiHASBsGNgS6pSCvHB/p3W+WQVXyCsWfBCg57lt8x/sRCE+Tl/ZVcbTPr6/P+9+U9hmcD8Z1L40j1TGWIzt2RkbJd0/B1n0Vw6q5s+0jot+exwm4zCJCYcQ2j2HJz920o7tGFWkjAc/NDlzwyc+sYQMFPM2ePmphuX46voktv6+GDhuKPg9fmw8WlzeqlfYJGQE3dcyOo9K+Lfb2H9JHY8e1zfhnqvbafiEJ/2tb3npj24dEvz0Pn4Efz566IG2LQ5eQvCjgGUbyl16eYEMv7baHl5ZwwJBLi7MNY7cp+/07bT8D/fZ8uIATHZ7QR9/sZ7SdtpP96LdnRsAJIYQQMjIUcEIIIeSGUMAJIYSQG/Loa+DzQ1gy4G7f0l2yWI7TWjDSSJ6+3M+vfN79KtPRecK1tG++HniM7dVrz7HuPTXu5PvVHfmnw37/TtvPQL89DxNwDF5/V2o8iEv7ttnTKFgLXBDxCoFG3ctLYVC/+Y7crW38ZTU96Dlu8fWJ5uDJ7cNSqqYKHevzyC/3ytD+V0BKHYdcRmZBe6yXviWAUAeFveXzLz5H3+ug57tngDfZafo8KaHfnofPwDGIc4OwtC9Pa10+f5/gt28/+52O+pGfe3DGQsDtgz8wEGq2/HpLyWcRrCuD2q1Rclz0VzBDQ9vOB0S2/ybh+ryb/eZIn1/WDdVxrwwt2lBm9Ae5pHwd79aXai2ZxiJA2W4sUcAbsW9XnI7VjM/rPLyIpNBvz0cKeDgjfr3cAyUguOLgb1H3KWAsBDwm+J3Qsp51tnMp5s+l31/2EZxhkb5MPQ+83t/6bVj7dVCvTWp/u/7dws+y+2rosB3tXXHAuzrQlQNqzLh/ZFz+YF8hH52nuV3lu+dwer+TAvrt+UABFyQohEf9KHeOBcjPBZWUgJuAgv3B7wQr4HKEm6hI+FALE3im2Q8Ca7TvkYKu77iGcCaHfksIeH17H+jzri7+lDa27LXd0IYSJfsusV18O8p/Oc7AcgwBc1+K1M23Fy4nTOUG3+txke+eAR4fzBn4hei35zMFXICo2sAIpw6DG/LLC/gchILfCX4GXmPDHJTisp+KvuOatjWnzN3H6bOrhDudeJmAh3UxebvLNgtiGwp4kTZ5u3rGAp7aV0WP7VL3KP957HiWYwj1NONtEurogJgC3oH1LTM5kL7Pn1FMcXfbR0O/PR8r4AYT0OIAifxyAh4GJfk7EN/wFLq93hikc+VMs+zCDLw6pt4KbcdFeQlBRH/6YCZ9/CsHUpcJeHzgthLUjA05SnlWlVeiw/bI53Nb8l4RL9Qf3K+Sz6e6bXah7bsn4g5a69vtQbYPgX57PlvAXaCA4M6xDPmlBXyx7MwHGcfiGngqYAZwBn4mKKsuSLX525E+n+j3haDW2zCDg8GlGM7llvbVcEz/ocyqY4ZobE3kvj8VTd9VYOFnWzzM9svRb8/nCngiYNqP8rd/KclCwMO719cBOH8Tm807nDkUr4FP+55Ev7+0YcvJ+dD7d74jF3c/23sZaum3IeXX8Jf0KfSyDQY3K43jcOlO89K+bY7pPwq4MvErdI0tLQeGN7Z9SPTb8zgBl8EXChW2aTCX9m3SXhdz/XtVwHJ5mWEh4A4TPOfA74U7L+Br5kCWmIk9EiXHTfjR4hQt+tMdTJlT6E31OdjnTd/PB2/TTWxbNgDjg6lr41JH8UObJjxAAKV9WxzTf4cKONpAZewo+e4p4FkDOFB1Pi/93vYgnDvbPiL67Xn4DPx42upSFURcgITTh781wr8KGig/9X0eCvgdeYINvRxje7OARwczOOhGHuZvjBsZp6s15IfDfv9O289Avz0fJ+DkCp7QR9/sZ7SdtpP96LdnRsAJIYQQMjIUcEIIIeSGUMAJIYSQG/Il18CRR+2SosTd6gHJlzN8PU+4lvYEG3o5xnbzlrXbDQ72+3fafgb67XmYgPu7R7HFS0T6X58IDmgUEd1/r1fli0XWa7fDLflkqa/nikBg+2n2NdRh2W9ta+6P9XnZuVpGNiNldS35KqXrzRO0277miDyu4K71jonHQw1PsX0U9Nvz8Bk4gtrCiRDIsDxk+lj/+kTLzkYJ15MaId+SXwp4O/qOax6UIttSwPfU4UCfN3lhHXdYt3ldd+9DV4Z+kAvGWdUB8mgcYPsArMdDDc+wfRz02/N8AV8BgWwRwR2NEoq3ByJeLF/qlz3AQF0o4GuUHVf60DywYuFre+twpM+vfXz+TWlfiTPy9LTajt/PB7lmxu9m/36DluOgwu+vz1sbZd89g+R4qOEBtg+FfnvqCzgEVGEGnn4oC4BASx39Kf1VcEEw5Ay8DU3HRVm2D5a+hu8jUVE6jbz2eVuX5Aw8d1C5NXstpevNc6LfdgvSL8cFxl918Zey1/armdueAn41+u2pLOBWHNsGdmNdEMx8Ge7vlQDjLUj21wlQXnAtSQLhPQLRleg5buhfRV/Du5GbfO1gn3fvZvZ+N93c5cXW+KYrr0XAU+l685zY2X9S1tJ+2B4dUAyLnu+eQfV4SHJv28dDvz0VBRx5tt5kAY5plNWzzFdBxyHfh4Kf2sY+JXgFWo4LYZhnepsBS0nE1vXAwYPkFc7AzTVq+ezF1u0x1NSzlK43z4k9/Ye0y9l3u5BciZbvnkHjeFhxZ9tHRL89lQQc+fWIN+ipiy0vJb5+Q3D7vN1NPx4EwjjoSSCsjoNfi5LjSl8k+zI321MSsZXPFwUV4t4jeKV0vXl69vTfR8qy/WL7AaKS6Y8hUfLdM2gdDytubPuQ6LengoDbvOqDScyORgkC+DwDz+Un35vXjCIYlq6B63bQPdjRRztY+Fr8asUrT6FDwBMz8NkXN+4YN+nXdS+l28yzyEH95+ptxkl9w1/MNb57Bm0HbeA5to+BfnseJ+CJo0EzhhPft90Itq9RvHBPAi71aYotrb//Sq4JBMuAhVcrymcvICJgp9/ElvN5sw+z8OAauOyYs5ay3F3byXpmBLycbiPPInv7D+mjm0Zd29TPBq9ir+3jQAG/Gv32PHwGfjyNdQlmATXbNKPuTUeEJwSCbw5m7bZjxl8zFlb3ngwH+/07bT8D/fZ8noCTC3hCH32zn9F22k72o9+eGQEnhBBCyMhQwAkhhJAbQgEnhBBCbsijr4Hjrszlnbx77ELa3ONZv52R/KWXJ9jQS6/t77/3a74TH0vHwpvbfn6wgmP0BmW/f6ftZ6DfnocJOMRyGrhRwg/W6LolNWaJS5OFrXXB79d3k5t1qX5py7/X329uyUViaZBN4+pQfAzrt6LnuCU/w0qC/Cs8tzjQ53M+NNVHyupa8lVK15sn6O2/9/IVvWJ3+BEPeNHwiX302j4a9rkHXEZ2JfrtefgMfL0W8S2B5Xd+B/hHPkuQrY+te+piAwhmCTI3CIJNFHhKREHJIDYMP7FQRd9x136GOsCv/Hf+s/u4yZE+H7PMu/ehK+M9yMWKhj9AibfpoHdo+vt9JLBcj68TvRr99lQQ8DU1v5lprwvyDwPJ6z0HGj/7nve5RKacfDAKt384NWie2kYs+o679iH08TWPE90sRw4C50svvfUspbvKdik3PELiDPwapN35OtER0G9PfQF3b2k6bWaUeSDL/PS3OejYmXkaO6ORQn1QQhCur/SXoe+4az9DHUacgUf1gH/G91HU+FYpXW+eE72248BhOdZe4TVxzsAVQP1tHKOAX41+eyoJOPLzM+Czr4ELErx8EPFlho+1jLdFnHMHANN3ktdkj8sXsylcb+xpn2ei77hJP8u9wrOKo33eYfwpOFD0Ymu+d+XViG0pXW+eE722v/9+w0RNZY6Cvu8eSeh7FPCr0W/PS2bgEPN6R+uoixNavy3vHM/MwE3wc3eZu7/DPKa8XMBs0obHo++4az/DbFDqEM7A/VmUKs7x+elMjseLrftoaBFw99EQC7j72nC2gCfGyI/kEX72B87V1bgEfd89DhywzjGMAn41+u15yTXw04OL5D9nL+lxvToRcLIvVZHfps4S3OOa3hXoO+7Kz64QMUfW543PxT6GA43ld3WBt5SuN0/PMf23viSFfOPvRkPfdw9D/DuMZ1Nci8dBlhvbPiT67Xm+gMeveTR5jzEDz5IQe5OPPz1JIvQdd+Vnps+kDtEM/EoBx/ep8jfvGHf+Fycd7y70ABlz6zaoGGuXo++7Z9F20AaeY/sY6LfncQKeOBq0YxeveZTB7QTRnFaTHfVZ99VljhuSfnHHeJ2AcwbegqLjZv0M+zALnw+8NPwsrAe22bUwK87lB58srNnOCHg53UaeRfb13/JAJRhfSVEfjX22jwQF/Gr02/PwGfjxdNTFC7gLsDa4IB8b3Ded3AVQ/Dbe1kGVjOUvvTzBhl7abceM34+J1Xjy4676VO6VsN+/0/Yz0G/PZwo4UeYJffTNfkbbaTvZj357ZgScEEIIISNDASeEEEJuCAWcEEIIuSHPvgb+6XvgCu7mXN6sxmtFZZ7QPt/cx8fYjlUabU+/GwH2O+PaUei352ECDtHL3pU6gaU1LWvAwb5Gwd2yVoylbNwVi3XpfrnN6yX18Q+aQDnrO8/NHez+rlr5bfY1pF+NnuMakfBLEvGQkKDM0r5tjvZ5LJ8UX3H1mV5t6nwp3urWq0sdB1xGZtHzgWO5a70B6r6MWej7elvubPuI6Lfn4TPw0lpEnVfeLZ3a6u8/I75vvAbUzBJcZhJMU3Xx6713vYb0q1ByXKzPl/b3xcDXpqVKpX1VHOvzcfk4cEznXV/u0A9ykTLb3r8+Ckq+ewp7635n20dEvz31BBxiiQCb25+lry7+sY5+Bj7NxCfRlnyjV4KibuHRbN1rSMkef9kH+sf285rSvhRH+nxD2eKPdQca6zznckv7ami1Hb+fD5LNjN/N/sPxgTHn9/e0qw5X+e4R7K37nW0fEf32VBJw5GcDTFtgAX118cHDb9Nzz72AYzYe5okZhBPrZDoESafapdeQficXBYKS+FULo+dAn4cvSdn+lDa29FPhUGbqiWsJXJ6LPGAjEpf2VbG3/5B+OSamA+bhuch3D8H6zxyrrrh0Qmb021NFwMPvNAQcZXinNo6NSCIBzQQU+deU7z+HyHeLdDIgql9D+tVcEQgw68yJRGlfjgN93h0MzsEUeSfu/TC/qzwY9CJt0rh6epEu7atiZ//5MTUh7R8fUAzLFb57EnidbpPfP8j2IdBvTwUBx2Ceg5SGgK9wwezzkUyCYINr8suqRgK+CEJihxsZnIHHaDsuysvdDFnaV+JAn/eC6j4aEoKKWWp1PUt5VpaXZ0//Ie1yPLSP8SvZY/uAqPU7WaPfnucLeCSKaXEssa9RUJ+pTMx2pD5z/WZRNsi++aOU2/oa0q9F03FR1tHiDfptWAtWYgYaB1bjVy1+hNlVTihL+2rY038fKcut0jA2J2wfGk3fVYACfiH67al3E5ujLbCA1rrg90vBXfhzLOBhsJF9YbrcDJzEaDmuLSftP6V9NfTbkPJps+KicAodabKB1h00xrvtjH3Qu9BBcLBbLyJXc5DtVxC/qpmn0C9Gvz2PE/BI/LClHOl8AV+C8hb1MAKOAGcDTbxv/izltr6G9GtRctyEj4U3J2b3VXG0z+PgcD6QXN7EhkBbKCsj4NYn7Rml9Q1LpX1b7O0/pP+3POB1bVN/pu0q9tp+JctnDfAmtqvRb8/DZ+DH01kXH0DiQCnfZw8gZJ8Jmj6t+YDy7QDpn909nScEgifY0Eu77eEqj9UYC1jdZzIc7PfvtP0M9NvzuQJOFHlCH32zn9F22k72o9+eGQEnhBBCyMhQwAkhhJAbQgEnhBBCbshjr4Gbh7YUkXzxQJaNn2GN62KpBknwhGtpT7Chl17b3394qNF0M9sLn4M7739wU+joDcp+/07bz0C/PQ8TcCzXmgbuIiHymgc1ttJdq2s6G8XdSZ7bUIef6GUmSUp3rROHnuOa18E6fzLLZoJCS/u2OdDnM743rY3GOu1gTNS/xUvqONQysmhppV/F4fBv9RsbPd89A22fJyX02/PwGfh6nfdeozrTR8HEBM24XgsBRznLA43Sdp8HVWiwt49reZs+m7TpI5+lz2xXlPbV0G/D9rMNwrytn80C6z+7jwXGe5CLfXBIanxgg6C056lNf79fz3U+T1Lot+fjBTycJc2BBQ/4kHw3ZuDGFikbD3751eyV26HvuJ6SeG4La8iRPh8hvjg/0ASi1/PY01K63jw9vbZzBj4aWj5PUui3p5KAz0fpaqf3EEwkUepZ5tgwWykJ+GSH5IN/2wbGt3FRIMCjI3MzjtK+JEf6fIj1/7ke/rP/fbw/A/w4fqoZDgyQsLSvil7bceCwHFuv8Jo4Z+C6KPo8SaHfngoCHgEnSz4mMkdnXcxsAA6dFukPTjclBRzlBc+tdgIOYJsJUtV1/xY0Hdf2jxeI1WWR7L4t+m0o+rw5gFzOjn2g9UKHg8lNvEib/Fw9YwFP7aui13YZQ2GipjJHQdN3z+Aanycp9NtTX8CBQnBBPWwR61mCLVvyjQQc1xFXs4ZAwD3J3301FwUCHISFB1shpX1JzvF5e2063Ad/lHLCGfjqNwm8SLuPhljA3deGs8eYOVhYjitcbgo/Y4zgffrV1biEi3z3DBR9nqTQb8/HCvj8zm4JmGFZkyBLvqGAy/djB5qRuTAQlHxJwc9A1ueNyMWz716xhfCPdg18yfo9+cg3/m40LvTdM1DyeZJCvz3PF/BLXnkXirYtL5wZJAXcI/W1u+Vfn4XU2U+YMKOqr/u3oOS4sS+Zct2Mo7Svin4bcmKJ71fB1Ii6lBPNwBe/c7PbOGnpTvPSvm0O6D8RjnUbhONwVA6w/Sou9HmSQr89jxNwGcChSGKzY1f/lXfLu19FfBcxBDe22X/XAo6y5hnD/CYlfD8H1PVp0W+nw1+6gC+JUAS+NL+ms7Svhg4bsj4PcOCYyU8CL04t+zSremYE3NRxqHXgluWBSiDaSVEfDS3fPYMLfJ4U0G/Pw2fgx9NYF8w+Nn4MATaBM/pdLMyf399JzD9yFDDtkcC0Dq7fzBMCwTcHs3bb/RhKjSOMDyMo8aWCIWG/f6ftZ6Dfns8TcHIBT+ijb/Yz2k7byX702zMj4IQQQggZGQo4IYQQckMo4IQQQsgNee41cHMnb7QG1X8n//7W3oSGpRqv+Wa2OlDnb1pu9oRraU+woZde2/k60XvzzbafgX57HibgWEoyDdxVwuVSsvrXJ4K+RkF9VsVAwN2XCDRVd8luLoVB/eagtbXVP2ThTmg57rqtsXRmLlfXz7I+n1hehm3qe6yUiJaR1SF15OtED6bX9jEox90t7m37eOi35+EzcDhU7Ej4LhRLvMO2Pu+euiDNHCDnIB8GHPn7EAEPMDP8tJhXx+hbouW45XL0/cyS8vklYd7WN2eB9Z/dxwJ2maNbzoiDgODgpbRvm17bsdY97e/YlgdXo9Lf7yOx7YMpnmH7OOi3p4KAY5DveZxiR12imQACWiys5pWiwRPWlgQvaZgEPHpxQ4qMgN9jPewetBy3VM4FfubYDJ7iQ7MPrOtZF3xL6Xrz9PTaLuWGA40z8Mto62/PM2wfB/32PF/AIWoSvPzpPWznPi3IBpX0gyaQVxDojOAmgj4Crp89TAKesM2TEe7U9kwx13JclDO38+JUsbqfzZSDp63zLGz+s/99vD+Ds29RCvwUCUv7qui1HQcOS7/n60SvgQI+AvrtqSPgMsjjgFXvbI11eYt42z+CU+TrQGMCjNnvH63qQXmBqAcCDmDfUoSRN+pn7TIze/P18jro63f7CXH3pd9fdhE+V1/bzwKKwdPUKzpIRL2lbt43+DrRK7nIdw+GAj4C+u2pNgNfZHVqcFmL9SSqQMq29UO+0UskhPn5547p9zPmBrhM/WG/KTPYb36fmuk/hgsDgfcldT+bKQVPe2063OcO+MIDjdVvEpTsu8J2c7CwHGd8neh1UMBHQL89da6BXxJYE+Ua8P1LtnWeCLarakldVwMjDpjymymIyW/D0/fYxg5gR3BhIJh86So/S/m8w4hcPPvuFVsI/zKvudzSvhqO6T++TvQ6KOAjoN+eCgKOgR0ua0HeGqc2XUBHcEyI7RQvpxvZ4lPpDvl9VV2DGQlsNTZKvVHOalb/OJQcN359YngKXbjGz9D16eCJ71fCbPxEyolm4IvfOV+Kk9rZ/Eh3oQckx4n0T2zEcCj57slQwEdAvz2PE3AnjOE2j12IaXDNT3bUZ93ZKC4IzoHRBnv/2Z/azN4p65cg1Qg4yjIHCa4MHzyntLDB2v/MU+lajrtc5724ic2g7GdbPp8TUfEtvk50FLR89ySKPrjFzW0fDv32PHwGfjx764L06WvQJvDkguyUrqJsf7Dgy3CDqirtIxjJX3p5gg29tNseXiZaibT3//hSwZCw37/T9jPQb88vEHByPk/oo2/2M9pO28l+9NszI+CEEEIIGRkKOCGEEHJDKOCEEELIDXnmNfAPnq8WsbojVvLFutX4h2/cRbu8QSde1528s1byj5cM9S3tuCNPuJb2BBt66bUdjyye74KG/y9ubuPrRAfnm20/A/32PEzAIVbTwA0TJpY5YIvFLk9Po9jlXGER79/1HbHrB08ACULBl7Crpqrrtd5Y0mSXPJm706elZk9Ez3HxhjG/VMwslwoLlTbue00n0PJ5lLM8IKxfrSBph1pGFiwZA2J3+JEvMzmfrA9WcW/bx0O/PQ+fgW/POlvz7qyLBHP7iGkn5iLgRkwDEV0JuFkOJkEomnGntvXz0OOgLMFrEn/sTx0sPAUtx32LSP3OZ00+8lnE0LYx6oC/p53Bvhr6bWjz+f5ySg9rKe3bprdOa78Pt3sso+zvj5HY9sEUz7B9HPTbU1/Acaq5aSbaWBd/+jwScB9UfvBSkSjozAKwLgf2LEVg/cS2eKbxkTJ8EgTWZz68JeS6QDD72/ogqS2oafl8bzkl+66yXcoNBwdn4JfR1t+eZ9g+DvrtqSzgyLdlVgQa62Jm0aFoBkEGM5Mgo/QpdHxvBR6nPGEPZnX+tKd/POoEypNZod9vfoMy3GlU+1sE2Hl/m/13QN9xDe6tXrY9vW/5SrT6Wr8NbT5vP3tfqD7dDT+LD3xxYICMS/uq6LV96dfGt8Nr4pyBq0EBHwH99tQVcCOuadHM01eXWZyXQQZ189fDlwI+/24Sf1PfpfB+ZPr9XlwkdzN+CZjebrTBFDynQPrkwaJpG8ry/STiFxba85rOiYt8PnqeexYv0iY/V89YwFP7qui1na8THQUK+Ajot6eqgNvrdDpOZsRZApp5D7cESBNYvMgi0Mnn1Qxc9hthSLytDHbZ2ASRCGY7JmjOomHSu7L8Z8xK7Gxkffr9GVwUCNw1cOtTEEKpQzgDb/K3C32+Rvi8SLuPBp+utK+KDtsTfs/XiV4HBXwE9NtTT8DNgC/MRLL01cWKM9K6MhHQJJ/iKXQ/m0ZdIxGeg5KkEeFYnfWU3852o9xlcPPb2MGsF33HnbhSxBy7fb6qnjhAWeY1l1vaV8Mx/bcaTybfCvsv5ULfPRAK+Ajot6eagOP7+mAa0lcXe/OYSxcE+bKAWxHAG6/wc5wq99fD421lixHw8K5oh3w/f3azxI52HRslx41fJ2rKdTNcI5ZSh2gGfqWAJ31+45WoBmPLeuZqZ/PpO81L+7Y5oP+M/8cZiG3V7X8VSr57MhTwEdBvz+MEXAZwLHLz2N0jXD2NgjRWnI2Q+4ogsAUZrWcMgrPDDIaF+G4gv/UHDFnRN7OkJ55G13Jc3L8gQuFO3ZpTtNJBU7Fbr+ksouXzW69EFTICburI14kejJbvnkTRB7e4ue3Dod+eh8/Aj6e3Lkg3B0Evql6Y8fdiOZsLmj4QISiFgyLeqpeG3SKI7eUJgeAJNvTSbnt4kLry79T4Ghb2+3fafgb67flgASd6PKGPvtnPaDttJ/vRb8+MgBNCCCFkZCjghBBCyA2hgBNCCCE3hAJOCCGE3BAKOCGEEHJDKOCEEELIDckI+EjLC7jUYXye0Eff7Ge0nbaT/ei3JwWcHMAT+uib/Yy203ayH/32pICTA3hCH32zn9F22k72o9+eCwHPPT50fiQiKjg/w3lZ0WP3jVQXC/fF+57QR9/sZ7SdtocbYyto31dqz7PhDJwcwBP66Jv9jLbTdrIf/fakgJMDeEIffbOf0XbaTvaj354UcHIAT+ijb/Yz2k7byX702zMj4IQQQggZGQo4IYQQckMo4IQQQsgNoYATQgght+Pv7/8wTTOMD3r59AAAAABJRU5ErkJggg==" alt="" />
班级表
mariadb 视图 事务 索引 外键aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAASQAAAClCAYAAAD1YoAlAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA8ISURBVHhe7Z3teesoEEZvOd4W0oZ7SA/qIg24jfx0I/nhUrwzfMgIAUKyhUh8zj7eGwsBAwyvAUno3x0AoBMQJADoBgQJALoBQQKAbkCQAKAbECQA6IaGgnS7X86n+3B1X4/kOtz/++8/8+nCniTX+3A6GRvPl5s71p7b5TzW1el8kVb83fjynE7n+4HVmuSv1fUWpoLkOuqjk9pOcTqi1waioZ/zcLlffQtFYepcwxhYgcTPNbg6xasFIJdm6IC5PPewZxOFOtvKM2W7DoN451rUn7fEa8wOdf1bSArSKEDy/Xw+HyZIYaPc9Lt3prjBbupoK37x4vgBLQXJUwpHkEJklK1CJFGsIN3Mv9VJ3C73M4LUNTNBOp2H+yAfbbTrIJ38IsecIF0HO4UwojWrMJ2SyUhFzj+7qYY/Rx3Px4u1LZtmolH0XOPAmbBq3Uw1uBzzdoz2TJxXO8NjuD8EveA2KXPQQRbTtKwRJJOXFPSWPr1I1k5DvnyGVJ0ZSvGiMD+KrayXNFaEtBxn9dO5QQnUNx9+ZvMLf8A0PO27UmnSH+wxHaX7Y/pDfZbjph5dGevFNVMvnkxdl/pfqW23tns53j4kBEmmRtIJhquMOrTQeizR07WjTI/bRk87rWLDS6IxSTPRKGN4HNZghGTFUH+TBc3Pl8X96o5RJOziHdeRS9NTCp+HSYd0jmKcpHaqumBntnyeTJ2V4k3C5P/X8W/LUr2k2SJIjuwIKee73mf1qOar5ZG/x3RsuDlW8KmYpXqpSUvrbuwrpbbd2u4L8QzmnMhPniQpSDfNSH8BfEWncpxV2pLgLAvSJM1Uo3hb5F9Vbf9RZddKrSaVtiPZSVzjhDmM55kwEcNCz1jqeKXwYlzjJOKYpvz59A0lO0vl86TqbLFeUp3/wVK9zBEf2mXKlvHN+Hzvf3rc1YV2aBMvOFakol6SdR0TnmPSLLXthnYvxfOYc1oIkvw3NpBvBCEcwtlhXFhpGkcKkLU/3ejZNBONopXlBWmet/ulqiGRtifZSVzFextHW329XHVYL/HknOlUwLLU8UrhxbhrBEnI2rlQPkOqzkrxNCxTx56leilhBWklxt6cICV8Ny6Dr4Pg+CZBWjov45+l/lfywa3tvuTXe5ARpAA95h1MGnM0anbuBkEqpZmwZRwyl+ysIRXfkRWkzPkx6jRx2q8VJB3ib5iyRUzs3NpJSvFc25Za5BlB2kTWpoIghed7HwvK3WyE5OKNNhZ9uDKs1mahlOYrWS1I1v/tfHp67nZBSqY5sUXGbFohviFndkraXqxqKDamjsLmYaMYOnRtzcwSpQxDsAZg40/dLZemp9Qx4zCth02L2gt2Zsvn8W3lvnpK8WyYz3O+VrJULy8nUwa1Le273mc1wPqnKaum4/xHj5lqDI4tsVQvSTv9MXNi1FckLNu2pTBhLJNjjV/rOfrDGB9+hnpBMn8+VuPN1bfJublG1QXn+bDQFyKbpuQbnl+6D8mGR41aIlXOEbuwp2nmrrLF+RmRcGXUUcto50gmzUQ54sZVRwgd5hnKdubL53m0VV29hGHavvN7xXJ1vRO+U7uvD3K+K2jHdDZOr7LZv7cIksmvWC/pui71v1Lbbm33Rb/WfvTidpsK0rsQCEEsAP3wEPJXCRLAK4lHV6/gPQUJALoEQQKAbkCQAKAbECQA6AYECQC6AUECgG5AkACgGzKCVLhRrDk92bKVv1AGgP1BkJqAIAHUgCA1AUECqGEiSPrclH+kIvw8npnRjuWebdHnaSYd7LVhPdliWR9WKgMAzGGE1IS/UAaA/UGQmoAgAdSAIDUBQQKoISNIAADtQZAAoBsQJADoBgQJALoBQQKAbsgI0tarQhpv4S0ExQ32U3CVDeBdeLEgVYAgAUAGBKkJCBJADS8TpPC5rdmUzb1QTp/zGoadBcm9Hyt871UYV1/dEj5TZoJMnLN83NtgXdzpK17EjiDNYZW6IEgANTRYQ/LHNLHojZtVrLTFiZ9/+Z4K5eyNm44xzMTRF95ZW40QRSM5+w4q9xK9m33BYXGtbMLW+gR4L/YXpLGzO/aesq3Jz4eZEZI9J/km0jhNQcWs/iV5CBJADW0EKRSEFoJUyC98PfA4basSpEecMW71EAlBAqjhb46QwvTD/JwtY1prRkhhmqtBkABq+JtrSGH6CUGyy0uBLUuCJOjxcIp2k3Qvk3KWQJAAaniRIF3vQ2JKMwqTEYK2V9nG06MR2TW8+ibTt1pBMna4uPo5y0m1Jq0uA8Cb8uIR0h78hc6MIAHUgCA1AUECqCEjSAAA7UGQAKAbECQA6AYECQC6AUECgG5AkACgGzKCxGX/18Jlf4AaEKQmIEgANSBITUCQAGqYCFK462P4eTwLph3LPrMW78T46rCebLGsDyuVAQDmMEJqwl8oA8D+IEhNQJAAakCQmoAgAdSQESQAgPYgSADQDQgSAHQDggQA3YAgAUA3ZATp3a6y6Zto/dtI9oCrbAA1NBGk8I7l+re9etbbks3Pvf3Ehz3CrSDp67FP+pqk62DCzN825pMgSAA1NB0hqVC0ECRPNj8RnOlxFST/SIr8PX2x3AtAkABqQJAMCBJAD7yZIInYRFO24XK9X28IEkAPvPkISQVK07YipG+tDcWKNSSAtjBlU24XGSn574yQAI7ijQXpKume7P5K8v2hQQgSwFG8lyDdbverHNPp2Pk8uDRFgMb1IwVBAjiKNoIkI5BwbUY/9X1+gy25/CZTM8Hcl2TXieL1I/3Md4bcCoIEUEPTEdI2drDF3SD52A53bxAkgBreU5CagyAB1JARJACA9iBIANANCBIAdANrSAa99M/2IwBH00SQbpdh3PbjtLrjr7clmx/bjwB0zf6CpPf+DFdJ0X89r7zcvtKWmvzMndrhkfDmSG6MBDiKA6Zs0uFXjTyetSWRH4IE0CXtBUnEYNcRUswkPxWn6ZSN7UcA+qGxIFlBWNffn7Elk984QtJwTduKENuPABxLQ0HSNE/RVKmGrbYU8ounbLruNH5nhARwFI0EaasYKVtsWcjPCBLbjwD0RgNBsmltEyNlrS2F/Nh+BKBr9hckGX2E6zLr12ZW2lLKbzI1E8x9STaM7UcAjqfxovYWdrDFCBHbjwD0xnsKUnMQJIAaMoIEANAeBAkAugFBAoBuYA3JoJf+B7YfATiYJoJ0u16kw7vtQE7n6aX3Rdbbks3PXV0LL+3b+5WsILH9CMCxNBCk6/0yXII9iewd0vX3Hq61pSI/c6d2mGB4cyQ3RgIcxSFTtnUvjHzelll+CBJAl7QXJLPVx54jpIhJfvI3248AdEsjQdL02q0hLeY3jpBUoDRtK0JsPwJwLIeMkFQsmk3ZUvnFUza2HwHogkPWkFQQTtWd/gW2xPkZQbJCxfYjAP2wvyDpJXjp/I+kNO0dR0il/Nh+BKBrGoyQVARkROIWk3VN5ywdvj7ptbYU8mP7EYCuOWbKtoodbGH7EYAueU9Bag6CBFBDRpAAANqDIAFANyBIANANrCEZ9NI/248AHE1jQZKOf1pzD5LyjC1Rfmw/AtA1TQXpOpzvg3xaCVI2P3OndnhMBYmHawGOpp0gqQjoDYqrth5RNtpSyg9BAuiSRoKk6dnpTxtByuUnYhNN2dh+BKAfmghSKAotBGkxv3GEpAKlaVsRYvsRgGNpIEg6+nh07P0FqSK/eMrG9iMAXbC/IEnnD0cd4+ij+jmylbbU5GcEie1HAHqj3aK2o8WULWSSH9uPAHTNmwkS248A9ExzQVrPDraw/QhAl7ynIDUHQQKoISNIAADtQZAAoBsQJADoBtaQDO5myt3yYA0JoIYGgqRpxY9krEl7rS2F/Nh+BKBrGgnSM2ltEaSF882d2uEJ4c2R3BgJcBQIkgFBAuiB5lM2nT4NqxZrtghSLj8RG7YfAeiW9ova2vlFFOr7/JO2pPIbR0gapmlbEWL7EYBjaS9IigjCqVqRXmBLnF88ZWP7EYAueGNBYvsRgN7YX5CuOvq4SoqOvadspfzYfgSga5osaqsI+Pt/WixqZ/Nj+xGArjlmyraKHWxh+xGALnlPQWoOggRQQ0aQAADagyABQDcgSADQDQgSAHQDggQA3YAgAUA3ZASJy/6vhcv+ADUgSE1AkABqQJCagCAB1DARJH3tdPw8l3mma3zEQjvW4xmxaQd7bVhPtljWh5XKAABzGCE14S+UAWB/EKQmIEgANSBITUCQAGrICBIAQHsQJADoBgQJALoBQQKAbkCQAKAb/rAgfd8///27//v4uv+4I7+Sn6/7x7+P+9evLsQr+bl/ffy7f1Ahf5KpIBnnl048+XxK1/6N9CNI359aj9tExcSNyyDt9Cmd0rTPx2d9uqV42TArAKM/dFCfP18fYstv9UsokRakT5r6lWwWJNce09GAEwgnDDbtms5ZileTZkcjzmS9wF/gdYL0/SlOLE4iv67jKMs7b/jrKx3TJp8ZehsbbOf9/tRfQp9W/UjAdigf79GB7C+r5PnpbZR8KotatGVWPhfo6iT+1FavtTcSsrgzujwW0yzFq0pzvSBtqjPlR/Ka+UvIVEDh77AwZYscpcTY+bzj/dy/v9Rhpo4cjhbM37G3mXTk19mlN3YScdKvzzUOOO9AXpBMnr6sNU5dtGWaT0pEwjKvIRkvFovYthyleFVprhSkOI3qOnNh6gPmu/ejKbZuakaG8JsoLGq7X6HajpR0YiE+Hnw3jqhO6cTB6oQ75s7Tv79/agyIyQuS7XgrOljJlkL5PM8J0rTTjWWQTmpGkl/z/FKU4tWluU2QVtdZov5SbK1T6JuCIAmVzmHInDsVAWHmfI/RkI5cjKOZk0UQwyG/ON+YRhUvFKSCLT7N+BPWw3OCFMVzdTXWRabeZ5TiVaW5UpA21tnMXzKkxBp+P7sL0ux4+N2MjD7vn+K45tf5Q/6WUVmcRjhaqrDE8UpBejCzxX0vdaCtgmTtjeK50WRcn0sduBivKs1t9aWsqjMXFvvAFNaQ/ioTQfqRofrXuGb0oilb5MjTzunCzHf/t3PU7y/516UlHWZ9Z5h3oM2CVLQlkY/URbhYvlWQZkJhmHbG1EghPcooxVtOM1XOIpvrzIVp/iYwsYaUrBf4/dzv/wMD1EkC6tAjdgAAAABJRU5ErkJggg==" alt="" />
create view v_students_info as select classes.c_name, students.* from students inner join classes on students.cls_id=classes.id;
    -- 一般以"v_"开头的表就是视图,这个表 as  students表和classes表的连接
    -- 更改视图表中的数据,就相当于更改原表中主数据
> update v_students_info set name='六六六' where id=2;
mariadb 视图 事务 索引 外键aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAewAAADrCAYAAACrWKVsAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAADkbSURBVHhe7Z29rvS819Y5BD46kHip0P0XB0JBhTaHQAcS9XRQQUVFO8fxShTTUHAKdCNEBRV0r4TEZi1/JLZjr9hO/JHk+j2a594zGTtr2cvrijNx8rd+AQAAADA9EGwAAADgAkCwAQAAgAsAwQYAAAAuAAQbAAAAuACdBfv7+/758/v6mLcj+bx+//KXv6jXFPZE+fy+/vxRNv68v+az/nzfP0tb/fl5Uy9eG+vPnz8/vwObtS0U33foKwDAylawjZCtIqZF488IVXNElV8/r/fvx2agYBsn39eyMQMhoXFCP1sgU3W6YpjaZwt7qmggAkd8+7xeFJ2lcDzXlOvL4T4/sa+miT8AHk5SsBeBpvc/Pz/DBNtNOl9+b5NtmJC+nIgLZkxheYcWCWqvTmn7NAlTaLNayn37/r5ZqKmIFuyv+je7iu/79weCXcQ08QfAw4kK9p+f1++LXpzUPi8SwTd9ZgT789KnaJWobxICn/KmmS59/8ecyrXf4UFvy4Xan6wzknT4uyp5JLZlH1fEEhp9Zu1Y7PGSO4vFejr15SSxr+ezIyC7dWqkpBhuU/siR7/xr4sk7VSk/VPE2kwhlQu22bMgme0SR4s0+/HDcbo1KALH5hpnen/uAR5vj8cuNRqNB/0Zn+Wxn/GB7A99rtrR+JgrbFXxovbptH/YH+pghOzhdqb28fsq0UemTndbli2EHEsAgLNJCPb790Mi8frQrJUHPX8WUUIWEv9znRTjSZ3R2yVR9eoMExKxbN8kq/YzbH2wwHM6gvdnfVGJ0klYtO1tE7shVadF2r7dRoJlkqVKlLk/BezYmfTPkmgzqZy3jf7/Wf7W7LVLnBrBNpg2cN3SpGLXxix/yvtlf+jvpR69XX0mxJRHbbxwObd+b39bO11bkn2kbLHl+O32bFrSlh0f1rrNewDAIZKC/VXJwQxU/iw26jYJak+Q97YTbp2b+glrC/3rH/mzrQWZIVa3QUpQ7h6W76ltdLAgKEe0Tgdpu1hWJUpKssr/dP0KyU7JP0uszXbbJSaOK3vtsoViiE+FU5FzT4knYjP8vo0//ty0BYuhKud8JqLqrIiXsH63P2J2prYRyT6K9HHSlh0f9Hcg2ACcRVqw6b8lgdkkRbinwfSpMHdwcxlplhtPisk6E8nDCvZ232amk0Okbks6Qa02LrbadvnwaVMqR9/xTisaonU6SNvFsiWCTSTt3PFPEWszqRxvS7SxZa9dJLRgF6LsjZVLxG7og20D5/NiwSaq4iVlC/+9ty23jyJ9nOqjPR8AAOciCLYDf2YHNyW7ZWBuvlsh2FKdEVuWU5KSnTnEyhuykqUAH4CEde8Jk7R9u41PLVecEg/w7MzxL9ZmUjnTt1KP7LXL6SRtEgTb/b6NMcfvGsF2yY6XsH63P2J2uttSdkl1GnL6KOYDAOBcqgRb68P2dzL+rFawo3V6ttCcn5OCTUobO6luK+Y5xPw0cIL6E/4eRywHCwb+bV+dhScfXs5vs7q862S6TouUFMNt3A5VF53t2Jn0z2L7yry1SOX0NrtPPtBY98/stcvpJHxg2+Kxa2OWN+j4VL5yPSZ++DPVjM5nIjv9wMTbxb1OIxx/Wzvd+F7sNrixmyPYG1syfFB100Fl+DEAoI4ywVZ/OleTbo6qU0mPE832lJwdyMk6ab/u96V12Hq7LwYiMT8X9EU5XKd/5TIfFGhbw/0pETU+8qx3sXMhUWfEjzDBcTJ0k+0RZDvT/lnWvsprF3cb96+9uGkl1daNUCIS208qdgkWJ2Ojf5W4/rtYsInaeOFYsG25GX9GIFU7vyJjM9ZHoc3RcZGyZccHrqtHnwLwELaC/RQcoQwFch4oUZqEeJZgA9CLcFYPADjGcwUbAAAAuBAQbAAAAOACQLABAACACwDBBgAAAC4ABBsAAAC4ABBsAAAA4AJAsAEAAIALIAi2cCOJ7sxkC4hzhz56cpzBd/gOjtO2PSHY4CTu0EdPjjP4Dt/Bcdq2JwQbnMQd+ujJcQbf4Ts4Ttv23Ai2vVdx+FrvL8wG2fsKh4adu20mWzTYFm67Qx89Oc7gO3x3X8itTPk2qT3PBDNscBJ36KMnxxl8h+/gOG3bE4INTuIOffTkOIPv8B0cp217QrDBSdyhj54cZ/AdvoPjtG1PQbABAAAAMAsQbAAAAOACQLABAACACwDBBgAAAC4ABBsAAAC4AIJg117txuX+/L4+5m2Mz8tZoJ8DrmScnzv0UaEP3/fvz24cZ4wHl6w6WzBh/xXniVrO8929gcb5tmfEUrfcWhjXJWT60Lata2k7jhoIdgYQ7Btyhz4q9KGFuEKwVy4o2AvdbA+4Q24t9aGyrVnwf053vG17QrDBSdyhjwp9gGC3pZvoNfC9m+0Bd8itpT5UtvXjBds9RbE5VcKJ6M8fdf/V16txUJmk935pe8L7wX5e+l6w3qkUVYY68Ids/HktZf0OJTucOl+teuWSlMdLtB8sYry06odz46xqPOzU2Y7y/qvqoz3/aupUaPtf75cqr77jlZWo8D205RMUTojI17OP8kzmPqfJrYRkS61/sg9SvxNJwU6Uo+9b++3rz5/X7+rKzv5EytuzhE6/YdvPuLKvStRNg8p0vh1EHGB/NlGuWbapMtxp2lYl1EEgsN0/b/4G8f38vlr9hnNJauNF4/eRHC/t+qFFnFlfzFuF4F9B7J5Laf9V9pHoX2WdCl3W/X4+pb4HttD/P8vfhpiImByz7Id8eL9K7LXtY94q5Dbbp9x3TcSWav9kH+R+JxKCvVeOYy82w97dn0hte+bRR7BNRy4fJY+IUhTaUrI/u43LmO9whyn7nc82dRKpDn8mBwPV7SOp/5r2Q4s4KxwPWXW24ETfpT6q9V2qU7/btnM2B32PEes3VY72Yw5WyimMpSwKfV9I2VLhn+RDpK034z3Z1nK5aN7I2Z9IbXvm0U+w3QZtHVQ7+3NP26jTHrzNKZMW7LXMUrYuQ9yQ8niJ9oPekO6/pv1wbpxpCsdDVp0tONF3qY9qfZfqVJTH38pB32Mk+u37edOMjQSAfOHTrWX2FsZSFrXtFrGFqPLvUL8TMZ8zyqUF+0h+ORKH+9x3hi0GgHPaxm5zyiQF260TBFT0Uawf+G+zLRovTfvhxDhbKBwPWXW2oK7/ivtI8q+2TkWh/R4HfY+R0W98wFrWt4WxlEVtu0VsCcj271C/EzGfM8olBTvH5iRH4nCf+/6G7dYfBgAHh36z2uKUiQo2wZ97p1So3rcQsM+ioo9i/aA3ivHSrh9OjLMF64t5qxD8y6qzBYW+q+9X9JHoX2WdilL7XcrLaluE37BtfJu3Cvrs5XyPBSN/5sbY9jFvFXKb7VPbbhFbqv2TfZD7nYi1NbFXTtu3bavd/YnUtmceJwr25/cVOZWw9JdqVOoIvuqu9ZWMvC+3fi8p8Nv1CsC3PQp0ynCHKbvDetgOU5ZfP/SlXJPuT3mgRvvBbJPjpVU/nBlnleNBrLMl5f1X1Ud7/tXUqaiwf6Gm7GqLslWJjc8a36uYhFdRR4pFmCi37thS5x9R3e+aWFvvl9MXlJWXkyhtzzIazLBbMJMtIE7DPuKkvmSnlgyKs27+SRz0fQofanlyfkFuPZe27QnBBidxbh/xkbquS58ic09RtaNfnI3xT6Lc9/l8qOXJ+QW59Vzatqcg2ACMhANfn676KVqrehXu4N/d+6gX8dPM9nXZExcLd/evHxBsAAAA4AJAsAEAAIALAMEGAAAALgAEGwAAALgAEGwAAADgAgiCPdPl/jPZAuLcoY+eHGfwHb6D47RtTwg2OIk79NGT4wy+w3dwnLbtCcEGJ3GHPnpynMF3+A6O07Y9N4LNN0SPLW5f7+3KBulF8HzfV9+wc7fNZIsG28Jtd+ijJ8cZfIfv7gu5lSnfJrXnmWCGDU7iDn305DiD7/AdHKdte0KwwUncoY+eHGfwHb6D47RtTwg2OIk79NGT4wy+w3dwnLbtKQg2AAAAAGYBgg0AAABcAAg2AAAAcAEg2AAAAMAFgGADAAAAF0AQ7JmuHjzJls/79/V6/37M2yN8v7is0ucOV5s++YrZc3z/vl+/P+8zRlhP0O/P9L0Fbduzm2C7d4L5Ka70JFs+nEx2Kvm+f9+v13qnmj8vJfCfl767jft6XS0vNaXfwBdjifrvZe5EpLYXdVK5D/W20L5euizfMen1yd2pVK62TuaM/jujjhFc1W7NFLkVGNq2Z/cZNgfX7IK9JtYPzcj13zxzcIt+SNSh1y79B/42ltiGP45Q2ffm7S71PpTawgeAPBNVW1nYN7dAjCOVq61TU+/7gjd2rsQJvk/A0NwKDG3b8wGC/fl924KLYDufhSQFez2K1TMYCLZP/4G/jSXqr6BfyuKt3ocyW2rtbFGnpdR3/v569kDN6M3s3r546NgzU+59l+ejf+y2oKy/LffwfR7atuf9BZtEekkWzgw7bQcnPicRLYKNGbZM/4G/7UO24QIzbD4oXB6yYOA43TNUKldb50K97xou748JFuv8th/JUd/nAII9A23b8+aCzeWcJOIINsO2rE+nsZBgL1lm/ftDswd3/xDskP4DPxpLX+ozZ+ZXdgFUvQ9Ftlhx5X+dg8lswY6Vq61z4WD/BWOLPiDfw7E1K/1jtwUQ7Blo2563FuxQZLdJhT/64yc1TnjLe1ew18TLL5wSD+k/8LexRP3FYuXOatXvurlG1ftQZIsVV7NFUSLY5q0iFGzzsaKbYHNZfzzUjfNRHPF9HiDYM9C2PW8r2NHTcRHB3iQ6fr85Jc77D0/3QbB9+g/8TSwNFK0yW1jMawROKldbp+VI/31pX3plhT5jRbaEvk9N/9htQVl/W+7h+zy0bc+bCjYlkNh3Y4KdQ6QcBDuk/8DfxJI62CIbglntMMEWbOEDSvGKblV+e9ApldutU+Sk/jN2rwe7V6B/7LYAgj0Dbduzn2CT6NlZq33lj+eDtnzeumyNYC+zIh8IdkjHgS/FEvX1j/u7MW3IN6nCh2pbaF/SmumEYMvlduoUOdp/XJ4OSNyZtWmb7XUis3HU98FIMbjLxX2fjrbt2X2GXcdRW7g8JZOSGYdJmL5Y63qukYR6M1O81HIHH2op9929rkMaW5trSaYD/f5M31vQtj0fItigPXfooyfHGXyH7+A4bdtTEGwAAAAAzEKeYP/nv/79/Sd/9fv7V3/79/cf/h168b94PerFff+Xf/D7+5/+owkKAAAAPdkXbBbrv/q78SSO1wNfdMD27/+tCQ4AAAC92P0N+//+478fSdp4PfrFB3Ab7vBbGH7LPOo7Hq95NZ7sewvatueuYHuJ+j/8u9/f//U/zfYy1EC26zP5JiRFDp3RCFxHyZpcS+9yk/Jf/4sfCxvO6KM8eL2pvTp5s0yP1x/bK/l5aVORQeU+5NqitocrDqqWYEnlautkzui/M+oYwVXt1ozPrWClbXvuC7b63dq8/s//NtsK4cRFycr6wEmubFnUSY3AS7VqlmP1Ljcry/UL9O+G/gN/e6MIvtsXr102n30/hTbV+7C1hetybFne63e1NzmZ+sYpHO+XPEDtH7unwf08Q24FhrbtWTbDPo3tbRRlChuBE4c54sx5LWtIe5e7GmIs9B/4G5HkfgiT1afkZjn1PsQPHvwYX79TexvRFnVaSn3n768xr2b0ZnZvX6zddq323DHfP3bb0Ti3gh3atucYwaYkiqPACyLGQv8+2ghSQrDzf5ao92ErjlxXYoZda6dUbqDvGi7vCwWLdfbuh3LU94lAbh1M2/YcINh8BFg6kA82AgWxPeLXdWUegfYuNztiLBzsowq2Imljy3ymTomXXEdQ70N0NovHa1KtV6B/7LZhQG4FAW3bs7Ngc538O1upN0caQe/TD2IO7D0R7V3uAoixcKSP6oiL5Hu96IwOlN7vPqIVP3igutwZtvqNmd5bcTVbFCWCbd4qQsE2Hyu6CTaX9eM72jfT0j92z4d96J1bwZa27dlRsGsDijnQCJsjf4tJqKk6e5e7AmIs9B/4OaJQJhz1Pmz2Iwro9gAuz06pXG2dliP9h8drjoXtH5BbQYS27dlJsHVddQHFVDYCJ01phsEJNCaivctdBTEW+g/8mCB93u9lWcuXD56KzmzU+xAVbO7rYIZtZ7y7V3Sr8tvTm1NfJc4Yu5V4S2NhKvrH7nlo27vnVpCgbXv2EWxKnPZ3PPv60zqRcuLYPcrneoOk2LvclRBjoaKPaonE09KmLFTUxirG+JR4kT0VPki24PGa2pbpZ9tHfR/IiNwKBNq254CLzmoobIQs8YzQu9zVEGPhDgP/ycmr3He7ZEuLRLosHq85M0/2vQVt2/Oegg3aIMbCHfroyXEG3+E7OE7b9hQE2yAmafAoEAsAADCMPMG2tycFzwaxAAAAwyibYf+P/24+BI/jb/7GjwUAAABd2f0N+//9o7/nJGr78Ae8nvcK+n7DHX4Lw2+Z5b5/fj+v9UplXsrlXoz28/MqvFp9BOj3Z/regrbtuSvY/+1f/Rs/UeOF17/4ZyZGXPoNfPFxgs6yLiUY23VRAuU+8PrrZV9hwaQtvJ/1c37lr8+nslMt6/qop0UtfFigzd8E91WPmDhGre8zcCSWmCv7PiNt23NXsNWO//W/dBI2ZtnPfVHf//N/qsNjQ6eBzyJIimB3w4K5rvPVyWsVKvvevN2l3oftTVwkW+r3M9+NU/gOa75guK8y8RhFfX+M56jtV/Z9Rtq2Z55gNyB2l6o0FbZQwoo98pL3yYmt5C5MbGvu193TgeFr/htIHGHUwHdvyTnu9pzb/Ui21O5HqnOU77Rfd3Bght2Zo7Zf2fcZadueYwTbPMUoXzMrbPl+1a0pF7HkI32afaj/lv1yva546/euyEqvvTsKlSXMq9M2UJNQH19zhr3GWfbpaz4IDQ/62H+uVNqWRa3vfKDgj5mX+5s2ZtiNqYylhSv7PiNt27OjYK+BpYKqqOIaW4Ij/9j7TTIhkY/sg5Pxft7bJq7Uq2R2fx1GDHzd5l5zph5pmUW9D9GDs1xb+HuhHzGsKKuzR8bOULBj27Ko9f1DB8JOoaJ9zsKI2G1Ebiwt3Mj3KWjbnsNm2CzebU/X6cC1yfJF02r7BCF1SnxnduySI9jhd6IJnGz4kO9FB8CXoffA5/2FMcR9Tja4s1r1u26uUfU+bPu70JYcoZNm0dK2LCp8VwcH/kHqD9XhvueDc76ferYZQ6jv9ynpcqAG4rRtz2G/YbcPKj4lTi/zjkVa7849JU6wHXZGkmBfsPUsw/39mn3jcl7yer3ooEG/cj2/Dj0HPu8rIn4jRMuwEexSW7Ls5IOA2X7D9uElXr4XXO/s8d4zdjvQKeZBjLbt2UewP+/fl716VcF1d5j5LEmTkpkJ4K9zzjv34rN9wXbhxKmF25aZ/+EHZ9Br4Ov9RGNHzfjIhmBWO0ywU7aE4yF2GlOV385MOWbnukrcgYRi2y/r2JuXE3wfRU4siVzY9ylp256dZtgkme7aWUok/qMG96izhZOoO8PlFycU+/leUNtZeZlgr3gz7qLkeUU6DXwSBduma9s6MzjxkZZ7VPgQsWeJlaQtPB5oDDjjYXOhUEKwlY1TrcPW8BhZD4wckY6K+Gx0it0mZMSSyJV9n5G27TnulHgRhbaYZOcmCle8SxKImoXv/t7N9q2J2b78ZKu/kz/buxozxUstd/ChlnLf3QPSzZgyBzLXWMqIfn+m7y1o2573FGwwgDv00ZPjDL7Dd3Cctu0pCDYAAAAAZgGCDQAAAFwACDYAAABwAW7/G/Z2XWgAX6AWuTAmthTLXjUu49r6pN+H7uDrk/orpNb3jxpj9uIzvqjSuxgNj9ecnCf73oK27TlAsPU6wbKlHkds4f0Jos3rVcOKWcQ3ykw2vFZh95exrPhLwNhud9+laySvRNtAXeH9+Ffke0vmuD+DpVT5lPuQXH0QWe7FLx0zOz6IUNmplnU5S7gY8tt9i4d/tEd83Owu1/Z9Ptq2Z3fB5pnri15tBdu/J/jH3tqMkoleZsL1mYOGULDdGXeQdH9oJmEHhi673klNwWW9xMv70YKdtzzsyrQN1BVpP7pfV6Gy783bXep9YOGWY9qtu34/HEdz3ThFH4S648R95R+IjKS+P4bD/UwBbk1XE4mipXQX9n1K2rZnX8EmAVQ3j9hNbiGltvD31yRinx6kBFPdy5u3G/HkgF8qps/NLFoFvrHV1uO+NomIxZpP/3kz6tWOfNG4KqV9VIu0n+3ZlLJYq/dhdz/LwSJTux/Jv1G+Y4Y9F9s4kLmT7zPQtj07CjbXpwOpLJEwFbaQgNJkY4H3uSaS1Rb+nnRK3CYc+6/+Tdwpr6BBsszc6XNnZh6bVS8z/ltR0UdV8H7WgzH/1K/eNt8MO7RD8kFAHRQGsyc+EOCKpW1Z1PrOAuHPsPF4zYF4B4Y53Mj3KWjbnt0E201oXQSbUKehVfBaQbVwfSnB1gnItdVNRmsi2gqxV6+C3/vJTJe94wA5N16yCe+dzO+dNk8+0jJKvQ9iTLOYSrOe3Ps/W1FW9Rk7Q8GObcui1nc8XnMeMuPI4y6+z0Lb9uwk2JxE14TVS7AVKoGFQcz1xQSbA54+p6TDid6fBdEMOxDvrfBSvcGFaWV+Xpm2gSqyiAT3H9ngzrDV77q5RtX7IPW1/m15p9IcobOibN4qbDlpWxYVvpux5Y4JPF5zFOxDSaxb7uD7TLRtzz6CTYnDHcTLYA4TTJIDttC+OYg5aa5Jg+uLCLa9iMyU8SExSGWdSOKSXphhn8xI0TIkBVvFhjC7tmTZaQ4ozTtm3a+0LYdz+g+P1xwB218j1szVfZ+Ntu3Z96IzQ/nMs9IWLwnqoNZv6W87E3YF27IItn529iL2Tn05syb2czcH34a2gbogPU5QiSPZEMywRwo2f77ZPx6vORmdYrcJ2vayfOpyZd9npG173lawOXltE7W/3EuRFGx9SpyrCG+i8iUV57eft3yGAILdgp3HCc70eE0Wq6ho4vGac9ErdhsQib+y5aMX9n1K2rbnEMEup8yWLKE0CZEDfPPdMMmISTkNBPtqPDl5lfvOB8V2PGxE2YyZsiuWR4F+f6bvLWjbnrcUbDCCO/TRk+MMvsN3cJy27SkINgAAAABmAYINAAAAXAAINgAAAHABnvEb9sdf45p7lbp/5SsR1ANc7vBb2JN/zzvHd/XkqPfVxgj6/Zm+t6Bte3YSbK5rvaJUXT0aXe6SosIW5yrwvdeqwXo9bLidxd29Ita+ypZP3J1zA5UPlmw7bw+uaF+p5Uu8TC9Y1pVPuQ97drrLt3xbBB9EpHK1dTLlvm85o44RXNVuzZfX9ZuYV/1e5Mi1fZ+Ptu3ZUbCP1HWwfLBMK/sJQlSOc+yyPMu8BzHaBGrsbEj6BiFsA69dtt+3783bXep9iNnJn7nLmjix2q/U3uREKldbp+aE/qN9lh0gzUKb2O3Dhw7S3uszsL/r/SPyuLLvM9K2PW8p2O6sJ/flBridTXMCtn/zkevb3JFKHcXSTOYaa0x70SZQt0LIfZC6Bae0LYd6H3LsXKm1cybf+fvrmQw7Jux7fvGY8sePKTodbWJ3FL1iHsRo255DTomrwd3ldN1XzWpSp8Zfb/8RnAwHu/2devlb3WNc+6AHAv0dFnw8Z8bLyib58Cwueb9w3UdTzLCNnfYUNb+Wu66JPghI5WrrXDjaf1zeP2Bgsc5v+5Ec9X0ieFLRKeZBjLbtOeais9i9k0VqbeHgdZJYcEp7+6ACC+/PEWf6286mlYhPPVsYRZt4SQo2/2v7wRUmk7AWkSw6sKr3IWqninH7mRNTez6kkMrV1rlwsP9oX57/4dibmjax2w8dWxzvajJU5MjVfZ+Ntu05RrCZLslEHxjY5B2+4heNcRm7L+dvlQjN90kUik4QPII28VI2wzb95Yqk+l0316h6H4rsFH0QaFHnwpH+47JHTsePpk3sDoFy0zrZyOFGvk9B2/a8v2C7SYz26e4yPcPmbaVC/3TaxMs28bMoJ8RhoGhF7UzaIvggIpWrrdNypP++tC/33uER36emca7rTbcDNbClbXv2EeycxwmK1Nqi97MILe3QFeKt8K7fZ9uiz/ZVj+XU38OpcZc2gRoTHe7D6NXQLNiRGfYYwWY73Ws1uO515pP0waJ82Y4RqdxunSIn9Z+x2463a9AmdrsQ5lblyxpn+1zY9ylp257dLjrbfZygyAFb+Ggzkrg4ue1d5Z0WbLDl5EClfrMHVva15n/uh8R6Y77I0Pyex6/hj9dM2iL4wCQEWy63U6dIhe8eXD4YU6Zt5l9NcdT3kXBufXm5tXnMA4G27TnulHgRpbbw9zOO8pNJkVnrcF/zJ59RzBQvtdzBh1rKfeeD3mVckFCkyobPk58P9PszfW9B2/a8qWCD/tyhj54cZ/AdvoPjtG1PQbABAAAAMAsQbAAAAOACQLABAACAC4DfsKPw/kqWnYF7/BZ2Bx9qOeA7X7x56GJM2vfQ1Rfo92f6Xsu4Nuso2P7SrrKn+lTaElly477SV7bychw3gfjrue0Lgu4yIoh1v8TXnErbUpT7wOuvbTz4++K6/Jjx4422Vy3BksrV1smU+27hq8XVWHDWYLsv6X4HajuJtdtWP2SH+pfv9V9jUDH1vs+Aega5ac8/fMe5Ij+u7fsYxrVZN8HmxOYuiXIfNbhPpS0k2OmETUkjpbibcvRdT8DZnjAJPZ3+QaxuTEKvWB9L29LU+7C9cYpcV+1NTqRytXVqan13xhHvM6yARTwYZ9xW3kc03tz336+uQ/fhu8M46x+7p8FtTo1nTQ/z7D4X9n0Y49qsk2DzEfURgau0xQivu17Uvl6fiGCbGbmanVCysH+rx2pCsHfoHMTct5yoNkJJSNtE6n0oE+zteMizVSpXW6elzndvH1mCTePRmQJyeX0HQr1vHqt6zH1JuM2XmtM5dpuyjQOZO/nei3Ft1kewedCS4NnTdfxSCdVs3qfSFiPYNim4n6nA9hKJhfa1/J5mv8ODwBd93E88pGcQ8750+29FSdq2R70PcTuc0758EGiFyowHbzcUl7u38pTK1da5UOE7jyUqs/jNNsROicdsMGfY+HSuKm7K2q+qMRv604z6fp8O7vOidruR790Y12b9BFsNRlsZ113y+2KlLZxQbCH6WyWPJZhJhGOBTbYuswQqoxNI+F22B4Lt0y+IXXEMhVLatk+9D7v7cu+fb8VVjQuzP060e+Iqlautc6HQd94P1037iPkd3tb383HesV3mgFf9/kq5wBWZ5buJus+nX+y2xYmxbO7ie0/GtVnXGbZXVctkYqF9rLvQdXBy0EkgLtjubRTXpAPB3qdXEHNfrG3vC6W0LYd6H7L2ZWO+djxI5QaOMf7dPLzALny9aCwpU9hOZxZuLzBzX/qUuK6+D71ityXsQ8kkyHIH33szrs36/YY9IJms4kv7d5KAvTgnLrr8XTpKfVNiWezTn/lJBYLt0ymIKW7cflj6g+NL2maKy9T7UCTYKp78+Mk7uJDK1dZpqfRdCbZbiOyg9n6rg10aY5kVsq35+eBsOsVuM9j+GrFmru77CMa1WSfB5nHt/IZXHGA1ttjEwRexxMWVk4TOn5xaXHh/NCPgsjbBeklfbx+VXubk3HjJRRKlMsFi6n3Y7GvnkbK7V3SbmWioYVK53TpFKn33BHsdF/bs1DLGQvjgxRlTy2/ZBvYlWq4JY2L3HLTtZXHucmXfRzGuzboJNg1BEj3nVBiNxvyqy23RCWDvSlNOovQ9mk2vuSHYl7o4BoK9z5ggHi7YkVm9Fpq9R8rSvsxFmNttREKw5XI7dYpU9t8i2DyW1vLub9gsvmu7GIKZ+Vawe8ZSpe8zEIm/srN/F/Z9GOParKNgH6HQFp5dZH9Zi7bOsZwk3f3wfv1T4eGr/sj2btxh4N/Bh1oqfVfCy7N5XyS2z5L34Z8vXrS/dRz5v4P3/R0b/f5M32sZ12b3FGwwgDv00ZPjDL7Dd5DHuDYTBBsAAAAAswDBBgAAAC4ABBsAAAC4APgNO8LeBTMyT/1N6A5+P7XvmHN8V3cue9ePnjGg35/pey3j2qyPYEeWHqgrQbMXWlbYEtknX9Ftl5i4r60Z/hIVXh4UltncjIOvMDefKcE3y3J2y92GXkHM+/Hb1b2iWAmGXUrFS++K7Cn3wY0Nb8XAbszTvqqWYEnlautkyn3fckYdI7iq3ZpkDGZxbd/HMK7NBs2wS+s+xxYObPkY4ase+8kJn4WVkx/vM1wjysl4OzBI5E3l3gzdLjFjAc8+QLkivYJY2A+3NbWx3cT9XXaAVO8D70tOln7dtTc5kcrV1qk5of8uG+O9Yrct+zEY4x6+92Vcm40RbBK8XonUJUewlyd1OcknS7Cd74en1DmR3ndmbekVxCX7cdbYZ1Hvw26y9GJ+a1despXK1dZpKfWdv++vm7aPpLUvHg72jJZ7FmQ+esVuW8r623IP3/syrs0GCLYe6GUH4ufYwgGdt1/e35r8uJybiPi1GRiLYNuy2k/+rv6Ytjt3vbrfADmnj/ZZ29W2ZfLUb8cDQzlZapuX2ONYCO1iW/eCUypXW+fC0f7j8v4BA4t19u6HctT3OYBg92Jcm/UXbCVc/sDep84We3QvvWIJTc+IKfjNtrxT4gzZSbMMK8zu3ZtUfcV+X4lBQRzco3sl9blEvQ9isgxj3oqr+tzsr0SwY+Vq61w42H+bMUHtHx5ATMug2D0ZCHYvxrVZd8FmMRwVVBzQe/lLzQrsk7pMEsoXbN60JmZ1AZS9YpYTaXbyvCIDB/5GmNiWvnEmJctNzFtxNW8VOeIqlautc+FI/3FZ/2C0TjxGMTB2TwSC3YtxbdZXsNXRf80s8xxb9gR72R6IK3/uzsr17DlujC/Yzv6COu/HwIHvCRPbUSPWTL0PyWQZjfna35ulcrV1Wo70nz6o1WeS+KDhSrNrZmDsnkhZf1vu4XtfxrVZV8HmgMo/4nc5xxbef9buN4JdM8MOkhYE+xzEx1ZqG8qTlqXeh1SyTMW8nnULV3Qrod+e0pfK7dYpclL/GbuVeF8m3jvFbmMg2L0Y12YdBZsTa219hbY4SSPntbkIjMs7ySYu2J/1ivINq6+cRO1+6oXkCvQKYuGxldQvtq3tq/mjBiP7XENHinnal7Rm2sTwVvOkcjt1ihztPy4frIYwbTP/Comjvg9GjME9Lu77EMa1Wf+LzqrobIsRbD5i5eBX4mwuHuMXzxyUiPOzstXAYPuc7QmRULOtIgG5EncY+HfwoZZy392D0c1Br0PfZ1vXgH5/pu+1jGszCDY4iTv00ZPjDL7Dd5DHuDYTBBsAAAAAswDBBgAAAC4ABBsAAAC4ALf+Dfv73StA9fIyrJ2v8QVm3lIigc0yHnUB25tsMe9vyx1+C7uDD7XU+v755aWMy8VnFPveyogfGjtFV6uPAP3+TN9b0LY9+wk2CdfLuZK6bE1ypS2R5Q7ui69sVWJqvp6E6slbkrW1kwX8RfvIKk77cZfAcOIraqah9Bv4/EQ1G0tq+VJ0p3p9dtlSuk4+mLj0+pb7nj8IYkDhbksFhLQti1rfqZ3d/ZId7tvNksgp6Re7bZk45h9D2/bsJNhcF4uPrcy+N293qbQlSB7qoMGrhOr1BFvb5Yq69NokSLMcbIHfq+Qb7icB2esOtvmXw7hU9lExev37Gkp6yV3YFdx2/PSomQU7XLN8WcEW7nkgLfeah16x25apY/4xtG3PToLNg9pff1x2V55KWyiJcQ6z66n9RML2UL07QqrspH3/vGmWvGOAmhHTd/S32GbH50W8BcheCHY5m1jidqSOL4sxppMPLK58qtg90LCCq7ZdTLDd/ZId7lvMsDtB7T51zD+Gtu15/xk2FdJPMNrOAuS7ldFebfDzYOB6pMGg9mVn2Al7jR3JWYfZjwWCnQHfmtSLJbZDHyjNLdgUd/Zf+xk74X5mcbelBo20LYta37cz7Jf7mzZm2B24QMw/hrbt2fE3bJ1Y7UBmscyn0hZKYq8P7zcuyl8+nRoVbN6f81sQ1WP/5gGhkpJrvk2W6pQ4zcSNrTzjXgdPhg/KXvM3AcFOofvHCoL7M4ebsKYXbHd/NoaWbQ7uNi/wHKRtWdT6TmPILXTYjhH0jN3zuUTMP4a27dnxlDjV5c6wPTHbo84WDl6dO7azAJ1U2A4/ObLIbmYFlIRCW6PfU4K9JisruNHvRghPH0KwMzC/Yev+4YOz9WeI+QXb/M0x4/57FcGOnLnin4/c9xz3P94ZkBkZFLuncJGYfwxt27OPYPPATiWhLOps8Z6c5e6L9q2Dmup1BZs+P5bzQsHWySyvTvZxHXhMKNj7y9RG0jZQRWws0b+uWNjXRgCTdPKB7V1sMgezdLC2iPJVBDuC+3hZzTau52Ng7B6F+v0SMf8Y2rZnP8HmpBTMsPMTTI0trkhzUgxmAqoytiMS2PxQD7XZPtyD//4sVyazEEdN3wh2xOYP1WP+9KCBFx4Zh+U/VHZe2gbqQvh4TbXf+NmaS8ywCbZTJVkVO0bAFxs4Ro1/swt2JIaVP4fs6kGnfu8AZtijadue/X7DpkTLp8YWwaRBnF91uS3+6WUSSS9n8IVo+t+tYPO+1hnBKpr8+SrULNqbgZEh2N/3eyvYiWTrl/ftmo/yPqqDH69JwmAOwNQp10QsXUWw6QN1QLnEAMWRu858ecY1lbPjx32pctK2LI75zm297ssR6aiIz0av2G0PBHs0bduzn2AfotAWTng7X7anq8PgDoXYFdgvqf6yhRLRJhcGgq3eBzN7f59Bog4JyvNSoOUkxXTcYeA/OXmV+27HkB/TBnMAkX9qdiTo92f63oK27XlPwQYDuEMfPTnO4Dt8B8dp256CYAMAAABgFiDYAAAAwAWAYAMAAAAX4Bm/YZdeqfp9/75fkeVXfBHYJS6iGcEdfgt78u95tb7z4zTXK9T5AkrvYrQfvjhz9gZFvz/T9xa0bc9+gk1it/9IxBSltvD3naurKYmom47kLn1hYY5duc0+ILITjBj4+ir7+MGYtC1FuQ92DTW/NvtyYl5td2JKLCdCNr7Mum0eR54YStv2qO0/ZwkXE6yewMM/etIn5oFE2/bsJNg6kJYEom4nWVJ3rS1czlm7HJlpc+LcaLMn2N/fD9+sw1lepRIizxyK7od+d/oPfF6nnnqcoLQtTb0P2/WvXJcT88t789ZQum5WLzs0ywv5gICE2RaXtu1T67se2+7YcF984FBeZ2/6x24Lesc8iNG2PfsINgtgeCq56DR1oS1mJq1uOrHM6km4EzPsVZv9dc/80o9BNKLPSdAaEcwkQOeBz/FDHRAVPGmbSL0P232xkPk3uonZU2ajVGfe/tLU+k77dQdCMC4ww+7EgJgHMdq251DBTt4wZMOBZOImMQ7qoBLvZigWtnexjfcNwd6n58Bf+2SboKRte9T7ELfj5Bm2NI6GjjH/IBeP1+wN298/5kGMtu058JR463uJE5Sw1qSxTSz2pWbfpohiI9jxctnmP4J+A99NSmGCkrbtU+9DdF8cc07sxB4pW2SjFWX+1wphKNixbVnU+o7Ha45mVMyDGG3bc8xFZ3Q0uDydKIsaW6gMHenr09mcON3ZR/g+gJPeYhvv2wg6+2CNoMR0ubzUlLaBusJ9tx5g+QlK2pZDvQ/bfZEtLJzuDDu47S1TZKMVZfNWEQq2+VjRWrB5n8FBMB6v2ZtxMQ9itG3PfoIdUBZYFbaoJ25xOT+Y3WSyJJUwmziJ6M+L6sEMO4NOA59EKNYX6p7V0jZTXKbeh008Zwpo2Tjgg4A1npm1vLQth3P6D4/X7MzAmAcx2rZnN8H+8EM0TF2cWH/C09AihbZwslSJkcvF9sNHpZGANkKdDHbajmVdKcYMfEmUygSLqfdhsy8VS1RXMMPOFmwTi+FB4XxXiTvwuN5UQGNt+iPbMbHbgp4xD2K0bc9xp8SL6i20hWbW+qtcrkCw92AfENkJxgz84YIdmeEs+iQ9UlYqxyQEW9n4mmkdtobbej0YcUQ6KuKzMSZ2WwDBHk3b9hx2SryMWlu4nBZs9+5L6iIzkxDtZ9vEGIHLZH3xidxh4N/Bh1rKfXfH1EYkzAEJHq85O0/2vQVt2/Pmgg36cYc+enKcwXf4Do7Ttj0FwQYAAADALECwAQAAgAsAwQYAAAAuwKN+w/58jl4wxnbMfhOIUdzht7A7+FDLOb7zvcNjd3SbG/T7M31vQdv2PFWweUlB8qpRrq/jkhPXFvt68U1QxDr45hNmHba9ytVTZ/bhCle9jqBtoK7wftark1UfLeuNpW05HIuzWMx/eJmNWY3grzCQtklwDKbGkbRtj3Lft5xRxwiuardGHSSZOOIls0XdfnHf56NtezaZYcfWAo67qQOXdddia1Hm4Lav6J3OnM/c5SteuaKbv9ydXgNf2s9RG+rLx2KeP3OXNX3V3ffM38I2CWkcjRtjhssue+wVuw3gfqY2t6aHcbXPhX2fkrbt2UmwWSR9cYsluDTltliRDW8tygnNmyXHbuywEWxrO9mxlK28+cpt6TXwpf0ctaG+fE7Mr0jbJKRx1HuM8ffXcaVm9GZ2b188hJZxWHTw0JujcTMTpbF1J99noG179hFsFsBQ3EgoNzPbJAcagffjBTDVlSnYnGzcpBO+rnFTiF70Gvi8n0AolnOA0rYc6n1Ixbw9Rc0vjin1DWmbhDSORo4xBZf3hcKOn/k56vtEcJ8X5aUb+T4Fbduzr2Dzv/ZIu0sy0eXs7SH17uizpGDz99eEr/Lg90tfsYnILUtHskUD4+7U9tFBzGNTo6EkbYtS70M05tW+7Wc6ttR3pG0S0jiStmVxsP+8ccRcaXwMit3TKY135i6+z0Lb9rz1DJvt4KTo3p5Uvccp8QbUx8thpFjqJFpFMV87HlrUuXCk/7isP7vetMfUDIzd02AfMg76NtzB95lo2563/Q2bk5Wun8u6+6b3xYKNU+L7tA1UEUmYOolWNOaTAiptk5DG0YAxtvClfbn3Do/4NzUDY/cU2P4asWau7vtstG3PToLN+ajjFaye4HJZN5FxYvMFeBPoXN58x0+iVJcr9sChbaAufCh2bBwx7mlvaVsWZ8f89vd1+x1pm8LEYGi7NI66jrEUybEzM51itwna9k0Oy+bKvs9I2/Y8V7BpluAKIb/WMUv1mYts+q4R5bKBYKeO/k2ySc+c2QcIdpwjfVSCv345vOgsvS2HCh/EmOdYWw8O/QvLpG1EQrCVjclxJG3b42j/cflg7Ji2mf9M1FHfBxKJv7Llphf2fUratmeTGfb5HLGFy5YEsATVBcFOMFO81HIHH2op9939qYgPEFJl+WzC3G2Kfn+m7y1o254PEGzQhzv00ZPjDL7Dd3Cctu0pCDYAAAAAZgGCDQAAAFwACDYAAABwAW7/G/Z605MEfDWudBUrL48p3TGXoTrtfr9ven/40Z6zc4ffwp78e945vmev/eZ157FxR59vrphvDvr9mb63oG17nirYPFjtVaPhoJW27XOkEXgtriDaGYLMtstLU9i+9YrZvdf8y1xq6DfwxccJqoMls42XNhUZdG7Mc32pR2jWPxKRbJxyWZeG22O7FC0CC7Ozsw+9f/P74PM+9IvdFvCT3nrGPJBo255NZtg8aFODTtqWptSW7+/X+e7Hzm6Xo3quz9yowhNsfaMNDvycV3q9I9XjJefMJHZpOg187i9nBsZtux4A6f5bhOr7KY6bM2Pet43NMY/QFH2Qmf3GKbFY52fLk1k+y1hkeN9mLEGwC9FPH1yOzVTM97lZEIjRtj1vK9jujPf1MjdwYIGlgP6Qmi8JwhPsEOd7RMl60tVPX7zvS328HMM5g0J9Gbufdn681fuwjWvHrl1yv7v9nhdnyW05VPjO7Z1xgLs5sKUDaJ5R/9C4/OFtQj197pY2Knbb0LzfgUDb9rypYBOUBNyjet7vOva5PpNEYoKtEghvd75HaMGmI9iIIe5NJFSiWWY3nEiDbbcU8LaBmsSdqXG/RQQ7v71PjHljiz1Fza/kb7OuDxKSf0N8p9gO6vfHGeOPIUZdV0K22fbinweW/Tqf92NQ7LaAb8eLGfZA2rbnfQWbYBHViZCD2E1mXF9asNek43yPsDPsHB/WJBTu+660DdQ4+mBoTU72vTHCnB4cJtiuLapu8zOMR+iDgBVlVbexMxTs2LYsanwn24P617Fj8ccQ26nG2yLMwQEwBLsCHVtqMkB9nz5jGOPqvs9G2/a8tWArVAILEyLXlxJsNwnR347YuqfE9e+FTjmzn2UWLcyws3Popeg98Hl/EQHk/rTJi/r4TQdOwwQ7PFDbCGjChxRSnVn7k6jwPYj51Ct6rYcV5i9fb5KuJ7ttDtE7dhtiDlLz2+1Gvk9B2/a8v2CbxMACu+Yuri8u2N4yMJtUDN5v2LEE6YAZdkt4X3lJqSzezoz5SL97Aprvwwof/Pnit+5X2pbDOf3H+8w6RgjG1kLq86b0jN0OeHG2x818H07b9ry3YEcSpH5Lf9uHeHiC7V5dvk246YvOdN3uzED8DXvZdifq46UMvZ9UDH3e6xWzfHWyvhYhl3ofYnHN8RI/JS77oDCzzjDvSleCS9v2Oaf/INidCR8pq3wpORC8sO9T0rY9zxVsGmyuMPFrGbzStl3KbVG/X2924C/3UniCbVDJck30VqjTgr1lTVyRmdYt6TTwI3HknXLl/jQHT+qUeJE9J8e86vv1YG256GzPB0bFYOy3bbKR4lCXcQ8IGGnbHuf036mCzW3QZex0it0m8Fp/PjA1MU/9XnbjmSv7PiNt27PJDPt8ymzJShomIXKQu99VQr9JErz/2OdpINhX5A4+1HKO78WCHRy88EE216H+5nFD43Szhvt00O/P9L0FbdvzloINRnCHPnpynMF3+A6O07Y9BcEGAAAAwCxAsAEAAIALAMEGAAAALsCDfsPmOnKX+ESuJneIPszg8dzht7A7+FDLOb6rp5BdbnCg35/pewvatuepgm2v7uRXuGSj/nGCzAmNQCL75/XKfBDHdu20+4reuenxjBj4up/WWGMb/H4rW/N+bszTxs2yrhXaV9USLKlcbZ1Mue9bzqhjBFe1OyQcDzncxfdZaNueTWbYnMS8oOHExcs1lrf5jxPUHGwEdz2nEu49uYVgl9N/4Ksbk9DLF+wjNpwY86ouXkft2rauq669ycnUN07hcZZ1QDwbJ/g+AdvxkMM9fJ+Htu3ZR7A3sCCWiN6BRnDF2sKiLe6f7EseULAtEOwtnQc+9aG6QYQXa0dtODPmtzG+fkfaJtGiTkup7/z99aBWzejN7N6+WLv5IMJuz6+7N51jtwXR8ZDDDXyfirbtOUawWTA7zLDjN0FhWJDJRnuKfpNMOPlhhl1Gz4HP+9J94Mcafx6ISKfTwtuY17ZEZ9ipg8i92alUrrbOhXrfNVzeHxc8/rJ3P5Sjvo9mbXsI9mhatufv7/8HaD70HXAmMz0AAAAASUVORK5CYII=" alt="" />
create view v_student_info as select classes.c_name as '班级', students.name as '学生' from students inner join classes on students.cls_id=classes.id order by classes.id;
mariadb 视图 事务 索引 外键aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUgAAAFZCAYAAAD6nrYNAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACqdSURBVHhe7Z2Jtau4EgB/OG/icTQE41ScikO5v1sLaAWMZRmLqjnMuzarBCpaSMj/+wMAgCIIEgCgAoIEAKjQSZDPv/vt39/0cB+/yWP6+++//8x0iuMp8vib/v0zx3i7P913/Xneb3Ne/bvd5Sz+Nj49//7d/r6YredEysX3z/FxT3zq3C6CdOJYDs4W0n/fsEggMZ1u0/3v4ROdzNMMmeaZO1i5EDSTWwupts1QPrV9fuJ4DvGBwvNO2h7TJFfnq+j1fGS93+Dta6XhOe5/3X7u3GaCnIUon2+329cEGZ6sp372GZCeyKdmzgt3jXT9gE+c2K1trs3vf6FVWMmzo7yeNokuVIyyihXk0/y7exPP+98NQdZpeI67X7cfPLeRIP/dpr9JJt3RYxLp3OU7J8jHZKt8RqJZRmpoLJGcLH9zVUO/jGaWXy91bXWbhZOly5pMr8zb7fHShSDf+eOYjyfKcC2cSwg/BSf/GaU5KLCb27SsXUzpPLMvSeizvPgq1eM01NNnKOWZYW29ZJ6P8nfmSxkrRU3HTa/T/IAK6LW5XGd2f+ENVeeXr13JNCkP9jutxfjvNHC4yfcmH10a9wmhcDPXvN1x8R66zsyxBuctPY9GLJIOPT+Sr/E5rpxbt81w3q5j2aDqibX96TGunVtZNzt/L5IIUqqycqDTQ06kZlbl5Gli4u/tgZYLkWLnr10H0TbTEynM87OT/PkI0spZYxZB9+fTYi6w4GKVeffkRNS26Vmbn88TQbiCYgrJ3kcLG8dZTZ+nkmdr60Xz5P+P+W/LVr6UOSJIh8uDMFmW2rXrr1n9Vver6ZG/5+3Y+ea7lWsqRbcT5m36ucjR60zXC48rOs48fWEaovMXnltzLH49/ZjXMo+dW6XgiR37s8uk57Zy/l4kE+TTZKpLoH5XOnvZBVFIWMTWfCHcZrZ9wR+L/JveMfRE7qa0bUf1Iksyf17OzBM5u5NXYutiWZu/uq4pJHKxmPTXt29YO8619HlKebaZL+kFG7OVLzlyDWnVWlZpW8WuXJvp8v760+9dXsxyC77bxG/Hftj37Mwcy4HrLD2u8DyW0lebJ1TPbeHaeP3cegrnYsf+SsdbXC87ydvkggwPMthoGOIbMUUHqeusRXHli7C6zUqme0Hm+37h7lDYtqd6kQXHOB+rz5eHhvGyniwTh/+WrYtlbf7quq8IUqge50b6DKU8W1tP51Xy2LOVL2tYQb5IWmBmKtdumgafB8H3hwQpRzBLUbcZ5vMKh66zWhr07615e89t4do4fm4LntixP3u8BUFurbeDgiAD9DufKXIAc5qzZQ8Icm2bhWOZQ+S149xDaX3HrotsBRV+uu2ti2Vtfj5PoqYjVeyE6Dj3pK+UZ2vruXO7dkaOF6KDVI9pRZDh8v4aC9J9TJB+PVvt23vZhuy+ztLjCs9jKX3hvFp61rbpOH5uGwuydP5e5CVB2vKYP6/Q744KsrjN6FgkptULwic2O07Ztqy7+4SU0unQE/uv8DBXjy3cvj6bNbV6ScMUPFuz68cnobZNz9rFlM4zEbds/+VGmo3jrKbPk15sjrX17Dy/TxX7sn9lK1+aU0mDHlv52vXXrM6w16dJq27HXT/6ncnG4Ltd6DUoUfDurikb508p56dGqz5tabnN0xeWizm9jvCa3yPIY+e24omN/ZllsrysnL8X2SdI82fQipTdwWoXmZ6gPFT3GVDdpuw3XH6tH6SdHxe+VUrpnLEPo3WbceubpM8da7o/Iy2XRo3q5uOcqWyzkI7owhD0QjtyUkusH2c9fZ7lXO3Ll3Cenl97oYbU8vpDFAuRUrt2BRWTO8a4Fdv+fViQmnatBaQnfIWj15leQ/4cZOXW5Ikch54fEXZWpkvnNk1rsTy9em5tfvh9+amYt6X9mXQU9iPfZ+fvRRZBXoVATC9cn51ZLphWggSA17meIAEAdoIgAb5OuYrpp/PWdPbyu+lDkAAAFRAkAEAFBAkAUAFBAgBUQJAAABVOKcjDb4wAADTkpBGkvppm3xw49M6xe0Pg97tHAMA3OX8V+8VRawwIEgAa8GVB6nuwtgOpeVe05L8jggQAaMCYVWwAgAaM2UhDFRsAGnD+Z5BH0CGRegyhBQBDM6Qgjw6OCQAQMmYECQDQAAQJAFABQQIAVECQAAAVECQAQAUECQBQAUECAFQoCHLld4KH58pp/xU4R9APBBlB4Ts/nCPoB4KMoPCdH84R9GMW5PN+y36v1gxDdrvLJWmWkAuzNjTZb8+7ctot55+3do4APgURZMSV0/4rcI6gHwgygsJ3fjhH0A8EGUHhOz+cI+hHQZAAAKAgSACACggSAKACggQAqIAgAQAqFATZqpXw8Tfdpr89v9j6uN/+plM0Sx5N++Pv4X8h7Hn/u0e/Fib5kHWGLqOdof/xU4wb0IoN/XhfkO4nVsO3G+wPZllBTrd/f+YXBh+TffMh+7VBFYj7zi2TTv1+ofB44Qt/KEz/9p5T6a39gFj0A2OSfn5sbAsECf1oF0FmhVsF6V/Vk78rkdFjSvel+1+EmM//JO8UviC9c17U020J80hAkDtAkNCP7wpS1pm/lr9tpCj7n9x6Ep32rXofSHshgq5NaSRce784nVYdezkQJPSjgSBFfokgpvvj7/HcEmS83vLszQkyEU+fyOr1wrfvN7gr6U+/I4LcAYKEfnwgglTx6fpWACoQLzkjwtIzyLCaaT7L+vNCejxnfwapaa5HkSXpPaZCmhDkDhAk9ONzVeyoemxlmRPIz69v1nv83b0hu0qjUeF76PHfV6TuWr13VM9p1U5BkNCPxoIUMWirtUaE8nkp2yVB6n7yKvbzPtl9m/UDgXbh1bSvR47ptNka3/Vm8KsgSOjH+4J8Pk0/RhXATWRm19NqclJtXo2ErGj+SbUzXC7sLtOHRoUvip5fAEHuAEFCPxoIMpGBqTbaSCl9/mijKL/tJfqykZV+9hGWnWcjyD2NIK04oyC1ut4r/b8AgoR+tKtiu+dpy88UvICIwUhS/l2EuWDeMEm++wxvFj53/DqtRr4ur/yyftLHDGnXH0333T92AAFBQj/aCXIIKHznh3ME/SgIEgAAFAQJAFABQQIAVECQAAAVECQAQAUECQBQoSBIuvnQheTMcI6gHwgygsJ3fjhH0A8EGUHhOz+cI+jHLMja6NbLq4N6Yfp3p9ML9LfnXTntlvPPWztHAJ+CCDLiymn/FThH0A8EGUHhOz+cI+gHgoyg8J0fzhH0oyBIAABQECQAQAUECQBQAUECAFRAkAAAFQqC7NFK+Pib9OdcT9cSeTDtwQ+Vzfjv5F//E9+bPO5/07T2e9ol9Jh7//rjN6EVG/rRRJDhWw7Rr/IVfpzKzreCnKRgr/1YV3+OFT5NfyYoTbv7Un/dcdePmRV/1TDEyjDMz7XJ/9b4WCBI6EfTCFJFUSzgWcFXQXphyN+nKchH0h5La3k9LkxXmN4VNgUZULj5+GlIL84gSOgHgow4kHZJW3T4BXGZyPj5qDxSCH73es6nHb+FXRHkoZ/d/SkQJPTjw4IU+SWFeLqrKEYRpD12rUL79C3p120FjwyM0AqPEESKc9QZ3EiqN5uVyDGdxpQlgoR+dI4gVZi67VwspkD/2jPIh6TB/hELvxrZyX/RthOJBoJUND9jyfn80/Xc81vztX2G66fpfpdpbyJ+DQQJ/fhOFVuioKUAW1meg1fTnsswkvycbie0JJ2PKdlXmk+CaeCp5I/mt9lnMN8s//UbzSdBkNCPjoJ8WEloRCSflzL9y4L0SBqK1Vn9Xlvr822qyLJkFwSpN5NbuG1ZxstYl02j8NNk5cdAkNCPzwpSqoIPF+XcRBR2ViqTgQQp8oqqxE5mc/Lmhpq0qu0oCbJE8Bxykg3qjecmx637yaLS4UCQ0I82ggyiGj8ZKURVacEUbFv9SyMfnfLRpXtzsPA5YS1VXRFm8FnTquJ73v1NIuFxt9/vEeQcUbp9ZA08Vpg2P0esaiNI6EfTCLKKF0gUOZ6Rd9Nu5VQSk2lwqd4A/Ho79u3z0u/D3Zy+f3PpBYKEfvQR5M9A4Ts/nCPoR0GQAACgIEgAgAoIEgCgwpeeQWq3mKnybvI36ft86zG908p81WdxPIOEfjQRpH+jQ6e4H6RtcfXzlvlWkEMMd1bo4qRpLHVjmnsBzWhXnWV/YT76KWv5n7v5OMEW8ri43jAgSOhH0why/U2a8HsVpC/A8nduji/RpvBpPqwn6fn3fCxdn+6uc3fWTzLLN2XJrygCFVGaPqcqzNPk5ydAkNAPBBnRT5D3yaU/ENouQQbLp1V0jVrHjRw9CBL68WFBivyS6t9Yw52V2RakR/e3SE7XC/NKp7og/br6r81j+7WNTPXzmJ3H25wjgD10jiBVmLptK8X0Od1PPoMUSs8b06k0Io+N+CTP3Lx9VWxFjlOq5V6EfiAQsx/d3tfz8ZMgSOjHd6rYEuWMMdxZmT0RpMpRx200cnT5s1+QOiuMPHU59ymogo8JgoR+dBTkyMOdxWwJcp6fyEy/D6NOGx3uEWSwPwQJ0IzPCvIyw53FbAlyJhPkkQgyyU8ECdCMNoKUgpxGPqaMSmEdergzk57t549+ytK3S5ASefsW7wyRo9tmmJ81qY4BgoR+NI0gqziRnL8LSufC5wTpq9ZhY4sRqpkn0tTxIo1H9fiC+ZXGGN3e9xu8PgWChH70EeTPQOE7P5wj6EdBkAAAoCBIAIAKCBIAoMKXnkFq15RpjOHOnk9ZKyHrniPb1W456YIP7eIUtz6nrfvFFmnZfvpmTtbFalh4Bgn9aCJI3wqbFehCNxg73wpyiOHONC2SxtBXj3veWp8OLGF5qCNn9vafzH/aVfNTXzF0+an5fvoeA0dBkNCPphFkNYrJIiot0L4AaxT1XS0uHEy7CMl2w3Gy1FcIk25NmSDNzUNuEoX+oOkUd4+y+4jmy3bus1x1/rdvNJ8EQUI/EGTEi2n31etEkF5cNxFlNpqRWa68nzyClO1ny8SdyZ+yD7+KGfxiaDkqCBL68WFB5tHOUMOduUcIi5SCtMi88C2ichXbSk3zxXYKV0HqMdjvbnIsUdbo/iaRcdBZ3OS3e0Rhl43z/DRZ2wwECf3oHEFq4dVtW5GkDRK/+QxSkxcIMoog9V10eyOIBbksN6fZydavq2J76rvs0UNKF7EGEbnm+dxgI9/bv0eWCIKEfnynih1FV1aW5+ANQZo02Sq1kZRPs4n69GaQyF/mG0Gaxqp4nzaS1L8kb8Lnj4lEzfpuX/7zJPux73zn1fMxQJDQj46CHHe4Mys/XddJUNKnA9euVrF9NOgEGkrOTya6lGg77x4U3nB0v7E0/XSabG0KgoR+fFaQWkWU77SwjjzcmW0cceupHDU9UZSsX6eCFDFKPmj+GD9KVTp95OCnuQrtMYK0N5xolny/fJZ8TUcPGgIECf1oI8hC9GMKaiIJIwX3zK0kg58b7syg6yxpmmW2JUjF5Zu5qURy20CW9XlVlarJ5xGr2QgS+tE0gqxixOiq1+6rc3I07breEs15aXnxGWEVniV6mWrkHcotnXY3Xsm+io84hgJBQj/6CPJnoPCdH84R9KMgSAAAUBAkAEAFBAkAUOFLzyC1q8+U9+/7Oo3S/rj/TdPyjvQ76Ns0EMIzSOhHE0GGrbBxP0jbWhu2yNr5VpBjDHdWYE9rsuSNjhHp88WnvdRtZ3f3n0uAIKEfTSPI9Tdpwu/DzuK/31E8Y6cgl598XfIgHa2n2H/y0iBI6AeCjHin8D3+7n7FOb3BdylVQcZ9Ir8fVZ8NBAn9+LAgpeAnVeyhhjsLESmGrxv6fKjeNJK8WTqNE0GugyChH50jSJWCbttKMX3e9rvPIHW94NiTiFnzJX+LKLwxLH+nP6eAIFMQJPTjO1VsqV6ONdxZsk6aXiF6T1upVLHPd9M4GwgS+tFRkGMOd6ZCyw6/IEgjxDCK1M9ZFVv3HwuRCDIFQUI/PivI4Yc7q4yWUxLkHoqRJ4KMQZDQjzaClILtIyE/2YDoCsOdBTzudt0jgpR1oiq4A0GmIEjoR9MIsoqrTo473JlH19fO7y9sw+dNJEe7HXPTOH2e9QZBQj/6CPJnoPCdH84R9KMgSAAAUBAkAEAFBAkAUOFLzyC1q8/EcGdwAJ5BQj+aCFLfH/adnvWH8GfxJZ2hdbLdX6wgLz3cmaeQR35azY+j6/08CBL68b4gpaBqR2+/ePG940wYYWfxX+4oXuFVQZbSX/vec3S9nwdBQj8+UMUW4aURzCUE+eJwZx4VWi0S3BLkkfV+HgQJ/WgvSJHDEkGqLONCzHBnCUcjwaPr/TwIEvrRWJBWiFn5DCIqhjtLEKFFr2N6dgjy0Ho/D4KEfjQUpK73rxwtJcKIC/fvR5CHhjvzyLLhTSKcVqvKR9f7eRAk9KORIFfkqBhhMNxZNNyZQ6PLYvI3IsGj6/0+CBL60UCQdvmiHBnubAPdX+Wxwqrojq43Aq+eI4DjvC/IQlVvfpYohZXhzuqUosD5d7BXRHd0vTFAkNCPxo00FYwYXfXafXVO3k27rq+d37e2IVGz5EdRosENJ/fc0fVGAkFCP/oI8meg8J0fzhH0oyBIAABQECQAQAUECQBQ4UvPILWrzzTucGe70f0V+lHCCjyDhH40EeTlhzsrdHUKp3qrtuZD0ic0yS+dEGgIgoR+vC9IkaB29PaLF987zvoFhmKQv09jgOOCrPd7XEnfar4oejzfvmmcDQQJ/fhAFVujoKRQX0SQpc7v06OQPlle52lkOU32TSMbZSLIbRAk9KO9IKXwX264MydIEz37tMw3hVr6ZF9Tmgd5fo09OvgRECT0o7EgbQHPfBDKwkdKstAww53N6bN/m7SEN4AoKnToo4lgHZtn6bJ6PAgyBkFCPxoKUte75nBni+AUu43bnBdlQYZDpD0mL0EEuc3R6xPgdRoJUte55nBnyiI7SUvQYq0Rsk13SXK6rETb93BwCfvduaLqs4EgoR8NBGmXL8px+OHOFJueu8iwJrN59J3HI5mv+5Obha5rFyCC3OTIOQI4xvuClGgwjHiiqCeqSgumX6SdN8pwZ9oH9C43guK4kDMaGcpyEi0uskv2ZYZKQ5DbIEjoR+NGmgpGjK567b46Jy+mPb0BrGIl6W8ct+hmoPvNbxjhVH18cTkQJPSjjyB/Bgrf+eEcQT8KggQAAAVBAgBUQJAAABW+9AxSW2unoYY7Wzp7V9CGmUIjVfab2oK28G/3fAqP9UrP5XgGCf1oIsjLD3dmCFqpS5RavDV/MhPKMczvaOsiwfvdAfEvG+pxh/vWYxl1nEkECf14X5Ba8KUkRgU6jZTMmzThNypIv4z8fZqS/Grhi/s/Ph4uHZJemwe6PfeGUSpIlaPPg6Qv6U2iUX9jsevqlgJ03aybkBWkRp9jv32DIKEfH6hiFyKpgQUZ9l+cRGz6rxHUU0ctWsQVC1K+d1GijxD1X7+dcMo6zxuxavQd5vFyHGNGjSGvniOA47QX5Bw9mQ+mqhcW+OGGOxNhSZJmqlXfSJAOlZ1b2L6Rs/xrn2kG6xt8vrnvg8izFDXOEe1QvHl9ArxAY0FaIWa+myNIna/btlIcZbgzU6014vIC8wSCywRp88pH1vUIspQnwXYN+jnOS7vuiCJ55/oEeI2GgrSFNK5KO9IqdiQLK8tz8Ebh02gwuzno9kqCVDnK9yZf7ChHi9T0ne1YlrnoZLtJQ04x34fkjXME8CKNBKnrXHe4M4O7CcRddHR7BUH6Rpf0xmFYyQ8n4VCeaxMRJMB7NBCkXb4oRxHB+MOdCSK6pSuObsNLUv72kV4UQTpmQT4kmtSPbr1ge/pd9cbjiJ97js7BcwRwgPcFKYU5j1xK1UrBREB2Xvr80a737Qv/9cJnnj9mdoq7/xiqgrSRtW4i7TT+FGvqx8c9vKHkIEiAz9C4kaaCqxpm/SNPx2tp3yUml3a9AWTLzhGko3Cz2SM+BAnwGfoI8meg8J0fzhH0oyBIAABQECQAQAUECQBQ4UvPILWrzzTUcGch77/ip8eRdjoHC88goR9NBHnl4c60BTlMn07TpL9Q6BYoIun3rfo+7ZEN5TiCN2UgBEFCP94XpPbvk8LtF1dhZN150u4sRpB+mQE6iht03VDwVoKhOLP+knoDCb4r9Q016339xnEmECT04wNVbBVDUqAHFqSX2j+NGiUi9lIzHcDDKDDLAyETpM83OY553TCvAEFCT9oLUkSwRJB5FDXccGceTXd0YwglJ6wIUiWrWVCNIBFkAIKEfjQWpBVi5rtZDjpft22lmArhF59BWux6NxdB2vSvCVKXX9Kuyz/1vXUiyB0cPUcAr9NQkLbQZ1GSkkZP+txy/vz7EaR91U/XtYKzEaF8por9AY6dI4AjNBKkrnPR4c5m8em6x6rYHqrYezhyfQIco4Eg7fJFOY4+3FkkOF03FKSkq9jFKUDXd8vQzWcvr16fAMd5X5ASGYUSMIXdP0uMqtKCEcJSDc3X+/aF/07hKwiyFvk5MdYjQwRZB0FCPxo30lTYFMJZaCnId0CQdRAk9KOPIH8GCt/54RxBPwqCBAAABUECAFRAkAAAFb70DFJbeKfxhjt7hL9uKFu77/u9ajPAR9jNJ9kOhPAMEvrRRJDPx12E5/rz/bstXXuCfn5+ssKwghxhuLNSGmvT4ry8j6ROmjfl7k/fzpczgSChHw0EaUetWcaAXH7GdCZ7iyTsIyh/nyZaerPwJenUcTJ3bUvW0yywrywun6EEgoR+fKSKnVUtBxWkpjON9ramMKk+WgwjR9tZ3kaYJhqfCuNrXhoECf1oL0gzlJmPIG1BjwQx5HBnT/OYoVbVnu73P0l2RPjccf77Kdsxx+Dfa5e/0xUvD4KEfjQSpC3UKoPoGaRnjiBVmLptK8X0edvvDncWCl9IqsjLKD0pNt9mGcrfPlo00jR5ZRaEmaPnCOB1PhJBLoXekVaxn2MNd2bSsNJQUxa/v1kkf5tGH7e85OX5Wvq/DYKEfnzkGaQKMe22MuxwZwZJw6EIUue9KtargyChH+8LUrv4iPyWxXV9F0GOPtzZjEaAi+j05hCKLxfdsrwmPReoHIcZrMIuR1U7BEFCPxpEkCpBiRBdgdfCrGMkmtWjqrQQVB9LkdP3RfBG4dOouXD8ms6tVui6ICEHQUI/PlPFTnGdqccb7kyXdzeGtSjYpb+8yLKN6GZx+rz6FggS+tFHkD8Dhe/8cI6gHwVBAgCAgiABACogSACACl96BqldfaZhhjvTH/1fR7arLdUbi+ngFnGXKcjhGST0o4kgLz3cmeKOvzbZrk87WqVlO9EbR1AAQUI/GgiS4c40fVES0v6fut1IkLqfvGtPbVrtQnQ5ECT04yNV7KsMdzbjBFka/sxGxakgc0yeyb5vOvIPpX8FBAn9aC9IM5TZxYY7U0HKSs/CIwWdzHvoK4KcbyjuRpLdYCAAQUI/GglS1yk8g/TMEaQKU7dtpTjMcGcmggylH/PUxw5FQdp8m2U455PMcdHoae4dpwFBQj8+EkFGhV4JCr4hekb3+xGkyqwWMdvnh7LdRJDmHe303e00n4TicpcGQUI/PvIMUgv6lYY7WwabSNIyCy8RZJR+eA0ECf14X5CXH+4sPH75u9itKRGkR/LOzg5+kkEicN8jQKNHRJqCIKEfDSLIaw93Fv9yocgtEpo23Nh/c0HqvpZnro/J71e/X8So+ZRWu6/N6+cI4CifqWKnuNbd4YY7S28ABfyNoPRsMfzueb/PsnyKZec5VMcTECT0o48gfwYK3/nhHEE/CoIEAAAFQQIAVECQAAAVvvQMUrv6TMMMd6as/bSrQRuq1hqpdjT4ZOg6ss25cecun+Nm9AHhGST0o4kgLz/cmUH7QK4c/w4B6hs56y39enx596jaNOYPfyFI6EcDQdr3jK853Jnv52h5+OhN0mvlZIVm0h4JUmX6guiq4o3zbnnlcWQQJPTjI1XsbDSagQUZRnSTVLNnoZk3YnS+k9tqBBksJyydxrdZ8vpM+fhJ3r8+AfbSXpAihksNdybim18TFOIobkOQ8p19s6gkSInECweSvoG0vH2U5/WYA+0iSOhHI0HqOrZwRs8gPXMEqYXYFn6VYl7YF0l8h2OFT9Nhq9Sh+JVAfAVBLjINlhN8BJlF4gWWVx3TfY/KsXMEcISPRJDzczdPWsWOZGFleQ7eSLuJBtPBJdYEGaY7lltYxU5fSfT7WW4qflnZRhqtnyVbm4IgoR8feQapQrzScGcGdxNQoS3JqQsy6haU3ECiZ5AqxJXIkAgS4HO8L8jLD3cmRDcEm377Uf72o/hEggxbv3Ox1Rtp7LbDKHH1GeQ8byQOniOAAzSIIK893Jl5/pgJPu7+Y0jzQgnyQ/FirAsyZ3mOSQQJ0JrPVLFTjAjGG+4sbrGu4NKuN4Bw2aVhJ0T3/1o+IUiAz9FHkD8Dhe/8cI6gHwVBAgCAgiABACogSACACl96BqkNCtNQw50Zkv6Mmzzvf/fpMbdiz2jDziUaXI7AM0joR2NB2r54sySCFlw/2XlWkL8/3Jkuv6RPu/s8tX+PS086Zd2BNH/S7xT5PusSBA4ECf1oKkjtvzfJlEVRWWQVdkmRv0uS+ApH067rBXIvRJLFLkGRIJ9yoxAxJjeUf3ojCUfDuDwIEvrRTpAqBSnsxQEWRhWkixRN53gXSYYRcTotLswjayNCL9kwgpRtnSZ7TgGChH40EqSuYwt3LEiRXyKC4YY7M2g6NyLI8LeuPUkEWXxvG0EmIEjoRxNBhlJcjyBVJLptK8X0dcNfHe5M02eP36UtuSn4KUtfJsjyeggyBEFCPxoIUoTgIx9hVxU7jJB0/dMY4Ejhk3UmXz3WvAhbn9PPCUSQB0CQ0I/3Bemip3SK3ic2ghx0uLPHXZYP5CboTaKYJ2k6VZAu2vw3yXaIIHeAIKEf7RppHFEEOfpwZ3MEGAtyoRJBOjFWB6UII0hIQJDQjw8LMinoRgxWJEMMdyY3ALvoi4LcAkGugCChH80FWWQrYjoNR9O+CDIUv2mUcWn33+0KlnUd6tUVECT0o48gfwYK3/nhHEE/CoIEAAAFQQIAVECQAAAVvvQMUlt3tQHDfTwNx9Ourfdxu8o7+ajr/kKj1jfgGST0o7EgRXz/rjvcmZ9Mh/AgTfew61NIrZO97+40dyOCBQQJ/WgqyOsOdyZruh/wf0wq+TBNL6QvesPI8dTBPdzfICBI6Ec7QaoEpXTvehd7IEGmrxVOD0mPi5p99LjMcyuZ/eSRZ2kyw6BNVLUXECT0o5EgdR1bPY4FucjCT0MNd1Z4hKDT8qhgSZuNLMto53KTZz6ClH+z97bBgSChH00EGUpxPYJUYeq2rTiGGO5M0hanQdK/Eh1G3nOCnb8LI223XW2ouU8IYQFBQj8aCFKjwUVsu6rYIoZhhjtLBRm1PFciSCdGs2wlCjXb0nVlPr+4EIIgoR/vCzIRxFy4Q1EYQY463FmYFllfnxcWpFeNjqObxYJv9IEUBAn9aNdI44giyNGHO1N2RpBVKhHk90c2OisIEvrxYUEOPtyZUoog3ae9giSCfAUECf1oLsgiLkqKo6sz8oYgXSRpW591O/YGkD2PTalEkDptufWaIEjoRx9B/gwUvvPDOYJ+FAQJAAAKggQAqIAgAQAqfOkZpHb1mYYZ7uz53FpBtqsdxTcW05ZrfRVzz+61t0D0OqI29pg+mO7zsPAMEvrRWJAivn9XGu7MkfSFTCfz+uGeASdkO5ut3ob8OFWYOqjFrtVlP2GPAu1y9Tst5ggS+tFUkJcd7kzSFyUh69so240Eqfspd+0pTdnAFSZaDL7TzyY/0/1USM6HnreX0/w1jl+fAK/STpBa6KTQ7noXe1BBatozuZmoeFtcJt9k37e7RIEbB2AiPlnGLqXHHETesyxXQJAAu2gkyKWQxoIU+SVV7KGGO/OoIGWl2sAT5j30FUHOeebEVbzJeMy+fARZOV53HNU3kxAkwC6aCDIs0MXCPRdIFaZu20pxiOHOFJWWDpRbidyekt6yIHV/wTPbQFyaj5on0b1D5vsRfvSZpj9Wzcclz3ekwRyv+1tAkABlGghSxbCIbV2QDingyzO6348gNc02CXoDSKRvZsh2E0Gq1LIIL80nobicEeSSZ15wxWULpO95I0iAMu8LUgp1KIRZDGE0ZQr+oMOdCctYj0laZuElgozSf4BMkFbK+7apaYwj9VSQ292WvgmChH60a6RxRBHkFYY7i45f/i52a0oE6Xm4bjkiPLl/WKQ67vtLqviKWVOJICOkyl/M1VnaC+n6D1n3vCBI6MeHBTn+cGdxdVWkFLlFG27sv7kgdV9LJLdISr9fxKj5lAptjyCf93suSJFj1mVIiNePj+t8vH6OAI7SXJBFjBhd9dp9dU5eTHt6AyjgbwR51BaLLxTaUyw7zylVxxNB+vxNbzjL9m1kW5KjIVlff0nxvD81iyChH30E+TNQ+M4P5wj6URAkAAAoCBIAoAKCBACo8KVnkNrV54wNAS3SrtvY2wrsW7nLaH/RufsPOHgGCf1oLEjbWhp280lbV+08K8hhhjsLMV1pJG21FuOIvN9kOH0/P84IgoR+NBWk9qe75HBnHr0h+HQZUW6lC0G+DoKEfrQTpEpQhLDrXewRBRnK0aOSXJVcmA8peiwIMgdBQj8aCXIpzLEg8whpxOHOtNN3uRO8plPyw+VB/qZQnj/hRARZAkFCP5oIMpTiegSpQtBtWymmrxv+3DNI94zV+L3wvNWk5+kHti2h+4uHOzvNveK0IEjoRwNBapS0iG1XFVtkMtJwZynZu9HZIwaHfB8KtTR9//30s4EgoR/vC7JSyK8z3JmuU68m66SNNdH71YpGnGm6o3yBMggS+tGukcYRRZCXGO7MIXLzrdbxyDyl7cn3ZnQfSfvqM0hEkIMgoR8fFuT4w52FeDHOgnw1IiSC3AGChH40F2QR14Ax4nBnacPM2jTfAI6uBwKChH70EeTPQOE7P5wj6EdBkAAAoCBIAIAKCBIAoMKXnkFqVx99y8R9PA1vpP0Z/DLhC2irf9xyzTO2dcgf6EcDQerycYvsWmut7QJkBTnacGfadcnKzvX1fNz/dHQjkzYdAm1OX55ndhmZG+TFvfRW0uVBkNCPRoLcWF4KfVzQnUD836fp/Hck7YvorN+c9PX3re9BurM8sPifjX2IQPWXrJe8OFO+nAkECf1AkBHHCp+Vm/5rI8g5kpzTLdtNfhdbq9ZerFaukg8u2vbR4zLPrQQCgoR+NK9ia/V6mh8uLoV+LuyDDncWpnF+VOAFqdFkuM1KR/HlEcOSJ16+4EGQ0I/2jTQqPyn8kfPmSErn6batAKpi+Rqvpz2NBP1zRJN+n27/OUS+i9aTfLkVnkv6KVv/siBI6Ed7QSpS+KOfG/Ci8EgENexwZy7tT/01riDdpSHQQgHGr2ESQdZBkNCPjoIcdbizhTCaNNFwIMgsnVEeyH71GWWh6v39qPpsIEjox/uC1K4sIr958bCKPfxwZ7p8LLQoKakgw3TLvHC9WgQJKQgS+tGkkUYl6COfqJEmqkoLJkKyEVH6/NGv+90L/73Cl3X6NoKUPHB5k85bPst+o1ZuBFkHQUI/PlPFTnFVx+GGO/O4aDATfBRBJnhB+nXNB92/lWl1vcuDIKEffQT5M1D4zg/nCPpRECQAACgIEgCgAoIEAKjwpWeQ2uVlGmu4M01Txz6Lz6ftV6oNOuFk3shJ3vseC55BQj8aCFKXjwvq3Jpb6PhsW2etIMca7kzT5MQk6Yla7PVzqQuTS/faFHW4D8jezJkJjmNIECT0o5EgN5YXEcTdVsJCLH+fps/fi2kv3ABmqfkBKlSOO9OXD55bp9SP1E/n7071DggS+oEgIw4UvookNb0qsb1yVBDkHhAk9KN5FVurkpca7uz5NO+Wh+m/axr1vzlZNo8WWcZ5tjVtPXpQsV6nY/mBcwRwkPaNNOG72J45gtR5um0rxRGGO8sFX/icPX8UqRb2sS+C1O3tk+sr0evvgCChH+0FqaTP3dIqtlRLxxnuLBaWGRncRcemiv2C9PcIMl2mGD3KMZiffHgpHb8CgoR+dBTkqMOdaRVbJvdJpWiTE1axBc2TUkt2wLYgJQ9lA2Hkrfms6/nP9jvtIWCns+RsOxAk9ON9QV56uDOHNtSYNC1pMQPmOkwkuSONeyLIBZvPmrd+nXrXn5FAkNCPJo00Vx/uLI3gdNJqr/9+S3o+6nxNkAtRRPn1PPw0CBL68ZkqdorrCjPccGcuXeEzwFCW2bPBFUyUufm8Uo8vv7HEUrXLjNlAoyBI6EcfQf4MFL7zwzmCfhQECQAACoIEAKiAIAEAKiBIAIAKCBIAoAKCBACoUBAk3XzoQnJmOEfQDwQZQeE7P5wj6AeCjKDwnR/OEfRjFmTpfWKdltcD9cJc3reOL9DfnnfltFvOP2/tHAF8CiLIiCun/VfgHEE/EGQEhe/8cI6gHwgygsJ3fjhH0I+CIAEAQEGQAABF/v7+DzL2yE3GeiyWAAAAAElFTkSuQmCC" alt="" />
事务

事务是必须满足4个条件(ACID):四大特征

1 原子性(Autmic)

事务在执行时,要做到“要么不做,要么全做!”,就是说不允许事务只执行其中一部分。
即使因为故障而使事务不能完成,在rollback时也要消除对数据库的影响。

2 一致性(Consistency)

事务必须是使数据库从一个一致性状态变到另一个一致性状态。一致性与原子性是密切相关的。
在事务开始之前和结束之后,数据库的完整性约束没有被破坏

3 隔离性(Isolation)

一个事务的执行不能被其他事务干扰。
即一个事务内部的操作及使用的数据对并发的其他事务是隔离的,并发执行的各个事务之间不能互相干扰,这些通过锁来实现。

4 持久性(Durability)

指一个事务一旦提交,它对数据库中数据的改变就应该是永久性的。
接下来的其他操作或故障(比如说宕机等)不应该对其有任何影响。

事务的ACID特性可以确保银行不会弄丢你的钱。而在应用逻辑中,要实现这点非常难,甚至可以说是不可能完成的任务。

事务广泛的运用于订单系统、银行系统等多种场景
例如:A用户和B用户是银行的储户,现在A要给B转账500元,那么需要做以下几件事:
检查A的账户余额>500元;
A 账户中扣除500元;
B 账户中增加500元;
正常的流程走下来,A账户扣了500,B账户加了500,皆大欢喜。那如果A账户扣了钱之后,系统出故障了呢?A白白损失了500,而B也没有收到本该属于他的500。以上的案例中,隐藏着一个前提条件:A扣钱和B加钱,要么同时成功,要么同时失败。事务的需求就在于此
所谓事务,它是一个操作序列,这些操作要么都执行,要么都不执行,它是一个不可分割的工作单位。例如,银行转帐工作:从一个帐号扣款并使另一个帐号增款,这两个操作要么都执行,要么都不执行。所以,应该把他们看成一个事务。事务是数据库维护数据一致性的单位,在每个事务结束时,都能保持数据一致性
事务命令
要求:表的引擎类型必须是innodb类型才可以使用事务,这是mysql表的默认引擎
查看表的创建语句,可以看到engine=innodb
show create table students;
mariadb 视图 事务 索引 外键
修改数据的命令会触发事务,包括insert、update、delete
开启事务,命令如下:begin;
开启事务后执行修改命令,变更会维护到本地缓存中,而不维护到物理表中
提交事务,命令如下: commit;
将缓存中的数据变更维护到物理表中
回滚事务,命令如下:rollback;
放弃缓存中变更的数据
数据库中默认不开启事物,但是默认是提交的
查看方式如下图命令:红色区域代表默认自动提交开启
mariadb 视图 事务 索引 外键aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWgAAADaCAYAAACLkNgfAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACSuSURBVHhe7Z29riS9U8b3EvhIEEi8IuK8IiHeGyAgQocrINhrYDIQAURoA9JzG4tEMAkBl0CwQiNEBBFk/2yo8leX3WW37TPdY08/P6l3Z9rtcrlcfvpjuvt8+b2/+/c7AACA8YBAAwDAoECgAQBgUJ4k0Lf7x/vb/XJ1X5/J9XL/9ddfzTKEPyrX++Xtzfj4/nFz63bi9nF/f/+gEXoFGvOs0Pfbx3vIk7cD4lPXntK/lxq/XgbSl0+SF2gnXEsnrUi8PaPXQkR5eb983K8+A5Oyt7d38rkhPal+bgLwJHm0IOZsygmZa3MPf1aceYLX9L2QL7vQ2t6u48fC936PUpDbY10w886tGxh1DlX1Qen7AWwKdBBk+v5ODj5LoGWS3vj724V2GUSawDfekTQEMq0vOFKgPaVyCPTOQKA3SEVKHKlOkjfrOVTbhwEF+u39cr/Qwr5fL+TcB61zAn292FNuI+KrTtnOXGh73jPJbThAvl6q9VmbSpLytibQmbLq/Yg2AWid9yP443cIBuofxcOu534utW9Rny/LgG7atLQItGmLOnrTNy+S9dMlqexf5A6VXyihuYzPZGxRLnlrdpbKNjwmz8izpO9L/wRavhg6cqKGTHvZ/kUiw/Fx8ySQ93ObdJytfdN+VtyS9uTZrZZLxg7lOa03sfJjwY2WyhzZuGTnX00fmLTvx7Ah0B/3K3X4cqVJxI6LiSPhoMTrbaf1RGZEUDJENpUkDeVp2QFH0HbnwENLcHtygGnQQxUq+0gmec6mp1S+LrvR+NjJbxK29tJOyU9Txv2xhSHO9psbNy6jtv1OklB3iq6ddHVKWle1RcS+MA/Os6jvcf8CmXyx2/blRJFCfrKPq/5xe2Z7LlvnUtbPXlzMvPjeriy6i/BH7dG/V/FZzaWQM7bcrPMxKJUZmx4lLg51fm30YRNX/1NxzLAp0CYofqB5nebFKkj5AFm2yglpUxsE7wv9H+8V2deGSGm2HfnBjEUnbGfKaOdgkk5HtSkolRfrmolPYmP6n7dvKPmZ9k/GRytzg7j4JnaQorxItB3Xj+MbWI3Vg/Os0L/AygcirUe05EQRrb2A0j9uj3bWLLx8dhVR8vOTBFFjgXPrtPYCaZmPtfHf9pdF23TBryuV0ceF/LgX55fWhxpMXzbyrJNtgZadFQkrT9uMMEZB4jqlo1g9gFmbSpJyoI0vqzJruzrpFNsedTDdYHgfg68+Lm6QeRsWy3X18oQoJlCpbotAE1k/04SX8akpo/+NXTK41dcFIcpsUyTGoXlW6p9HW8f1PpETRbT2Akr/nC/vJhcScdzwsws33kbU3BE599EcGafxlKRlvp9i/WECTTayfXgyFQIt4HXcaw4KDX7o52rbjolTsqn4Ek6JSn7WoNV35AZznRA6LASp7S3RKpWvyzovcSREfqb9k/FxYxQiG8XZiiz/TvHBSU6n8R9+ElVgJ5w91Q11js6zYv8cKx+INGYFtJwoorUXyPTPbc+xjPxv8LOHMCd9HNN4StIyH+vEf+O+X1cqo48LSlwcW/Nv1Qe3/ll8SqCtHthJFW/bP3FUm5EvfGRG333wVn6SbR/kGrR+Ongw35TrhWEQHXxt3lxVoT5cwjU2Xz8e4pxNTymB0jJzJEj2m38kLPnJ4yDjkcTejht/E9cNDbaMdxRsyYxfS4JzOxc6NZd1js4zU5brn8PXd1896bYtOVEk054l078QI95pxuVZPx9AsC18tut8/ymm4rOaS8J/Xmd89+tKZfRxQYmLY2v+aX3YxGyrt/dZ+gTafFx+mTV3d0Tb5iaOTZj0FMt3LGuT2pXbl+6DtuXLhNhE62fAnu6wzVhsqH/O17Q9I5quj0asVoYzNpV+pANeEu9Wsn6mCZ/Gh8q9/+ldDlJ8zOdsXDVsbqTidWieub6HuwMyE3mp/6icKLNur9A/bfy4n2FF3s9P43KD21t+YFvaM+tl57VcEv63C3R53C2Z+edxPsV92MDEWLH1APICfRaEMMYDORJL4j1KoAEAjyEcde8ABBoAAAYFAg0AAIMCgQYAgEGBQAMAwKBAoAEAYFAg0AAAMCgQaAAAGJQKgc49DAAAeC5nnpvn6DsEGoBpgUBDoCHQAAwKBPq0As3vUvCPQMtleRcCB8g/054GCmUoQ9nCY8vOPDdLfX9FcAQNwLSceW6eo+8QaACmBQINgYZAAzAoEGgINAAAgKcAgQYAgEGBQAMAwKBAoAEAYFAg0AAAMCgVAj3Sr6XsS8Nfz43+oGSMvOE9/kOkAMzCMXNzzLmCuzgcjYFgUUz+wu2ef1SxSEGgA+lfrQZgGg6em0PNFQi0ozUQ/Beo5fZcv+Go95FAoMFLc/DchEAfzi6XOKK9crLX5rL86ZJt6/JxoTruOXy3jTzNShMqa9MJ9MfF1n2/KMmVTTryxdXjdwFcagKQtJe+X0D109R5p+WN1l0WX6P2OnwBJ+DIuUloc8XlfFi32mav3G3v+4zscw2aB8mraGGvy6IbtjNwWyxU+va+vLTHj2yaBOTt2drNJODqdC7jn932atff6Mij5kgjai/xJSGUhUli+2b8S3zq8gWcgCPnJqFtvyHQ++VuR98nZB+BDqLDH+noMFd5NeBbArxVTkibwg8Dl9UmnaxHFPvh0dpLbXt8mUhwTmbjnljX7Qs4AUfOTSI3V+Q6uc2uuQuBdvQEwtdZC+pNXL5Yn0pttbW2x2RtlpLHk0s6YS/YLe4ZiI32VD9FnbxAd/gCTsCRc5PoEui9cren7/Oxk0B7seEfJcQe1AzYZbG1GvCtttZJVbTpysLmXJYmR03S1ZLWU3xZ+SnqZAVa2gQgcOTcJGrmSprzu+UuBNrRGQgzUHQ6E++irWDa0TOJEg94v0CrNk0Zb8/fMtegfX331ZNue6P+fKQbpaQJmSar5qeow+tWAk10+QJOwJFzk/DbuK8WFnrvw7refrkLgXZ0BsIM5loQr/IOBzqlipMg1xYnwfpUyedX1qYTunBnhHYXB7HUl8lHvrj1tq77oaNEIqxkOElWxU9RJyfQXb6AE3Dk3LRoc4WvK+fr7ZW7nX2fjP0EGgCwM2eemxBoBwQagDGBQEOggUC/1OIXf8kFAAAeAQQaAAAGBQINAACDAoEGAIBBgUADAMCgQKABAGBQKgQat9kBMCa4zQ632UGgARgUCDQEGgINwKBAoE8r0P75+nRZnrPnANmHNswz+FGgUIYylC08tuzMc7PU91cER9AATMuZ5+Y5+g6BBmBaINAQaAg0AIMCgYZAAwAAeAoQaAAAGBQINAAADAoEGgAABgUCDQAAg1Ih0Ef/WsrtJX+5G+wEYj03uIsDd3GcOgnOCz+xlf7VZzAaEGgINAT6lECgZwACDYHuCMT1Yp+h98/Ix1WtvcvH5f7u/gCr30Y+Z5+edpdtFrh9mHb4ef7L5ZLUzfvC9S7uXQDvF1GH7UkbV2HTlX1cbD+iepuQL66e8fUqamq+mLZIRGn92/tlaZMHqlTmyMaa+uPX++Xt7XLHVZARaZybSX6u3n+h5RmzVS/N3WqHPkNj3ydl9yNoFoK3SAHYHgtHTrxseem66NpmDm+LW7oZkV8LtObLul4QN5esYftUoEno1Xob2G2vzi7VFZ9VX0xbLJy23KzzvpTKjE2Pt+2+CnAEPQM8fo0CHfLTjvEyjzJ5ZopK9ZLcvV2NyFdNz0/R2PdJ2f8Sx0oY8qJg2SonVLFRCELlqPVFq+c34jJpQ9os1SuR1pPkbAo/eIKYZvy6Uhl9XMjHGgI9A41zU8ulmtxtqUcckzuNfZ+UXQT6Ji4ZmNOeSBi27OmiUbaZIRUlmViGjC+ler1lJdJ6kpxNsR4CfVYa52Yul/jzZ8rEvAzzU0uqh9LY90l5vECbAbss269EasueIhqbNjO4esFUrS9aPe8QlxWTNVOvRFpPkrMp/IBAn5WOuSlzoDZ3t+qt8uoIGvs+KbsJtL1cZa9lVYliQBGNTZs5vC3essWXdb1FrK73S/iRJLFp/MzVK2O3bbwG7drldXsI9FvTj5zgeHL5myHNASm0IRf4W5K7xXo+d0Pp/UbllL4709j3SdnlEsdV/tr7EQ9m3h4L3/pUyYtH2WYBTi6ya35dztzFofaN6qm/aBMsXqovLpHDXRO738VhP7cLdDnWFvtjD6/HXRyj0jg3oxwgEqFV84zZqkeffO7auv7gYk8a+z4p+/9IOBKcWLEKPZY0kQHYlXOIlA4E2jF3IPjHRet72yWHLiDQ4FAg0BDoodFP1f1iD5Z5IJXTtj3ICnSNnwAAEDO5QAMAwOsCgQYAgEEZ8Bq0vSSB0/4j2CPW846fvzuHl+q7hJ7K0XNzJM7R95f/kRD0cfSDKkM9GLO6jWxUeuYm1cndzjkVEGgHBPqMQKBfU6DtnUz+xUYf4qGr2YBAO/qSIH+qaO3hdaMp5EvzgyokarR+lNeNZm0mcTEP+HhXNttL4hIlYm78+K6ZJGd5nJxTm7n0sgLNcYnHcqgdYxOtfZ+T3Y+gOQHih0PYnng8eoUtTwVasraZw9vilux90HG7OV/W9UISO7EJ26cCTUKh1tvAbtv4qLeZbLbcrPO+lMqMTY+37b4K+ieuYjOKi7Wdjl+uvSguq1dZ2rbW/bL1ZBPpd4+aS68q0GnuMtxXLTDD09j3Sdn/Escq2ZUJHLFVTtROoCBUjlpftHp+ozTJpc1SvRJpPUnOpvAjiI9fVyqjjwv5WD9eoEvjkGkvrUfE2xVyJYr9+sgxoPiirhsS7n+HQJu4unpRnGaise+TsotA43WjjtqJntaT5GyK9VMItGxbiUteoJcxD2MfjJdySYgytycc2syl2nF7OqX+K2g5kMRmHhr7PimPF2gzqUqvBt2yx+XKBC/azODqBVO1vmj1vENpkkubpXol0nqSnE3hx0sL9MpnSTmXbN/tZaHgD9ukeBZzSVs3JOX+r8E16NnYTaDt5UY7OapEMcDlygQv2szhbfGWLb6s6y1JzEnu6yQ2jZ+5emXsto3XoF27vC4S4VIZfVxQYu3gidv3ulHFZtp2RqC19tIYxq+yzI2fg9u5XGJRYl+2cslv476Oy0b/FWw8/TV93MUxOrtc4sDrRm35/ndx2M/tAl2OtYW2cW3W3cVRsBm1TahHqLn2lrjwEr/Kcis3rU/pWUxNLi3bjCzUW/3XKOTZVPT0fT72/5FwJMwR1Y7TLRUiAHblHCKlA4F2zB0IvG4UvC4QaAg08y//fL//yS/3+y+/db//4W/Twv9jwYIFy0AL69Ovf3C//9M/OuGan22BZnH+5Xf0gGDBggXLcAsdRP793zgBm5ttgf7j31cCgAULFiwDL3xQ+QJsC7Ts9D/87f3+P//tCs4OXwPTb1ED4BhwDTrq+7/9a6xXL8C2QJvrzm75v/91K/dj3hvnF16hD2AGegRa3s4obrO72pdWRQcce9/19CkyfQ+/kdH/L0DbEfQBQKABqKVVoHl7cSfTTTyo4gQ6uid8SoE+Vq/2ZheB5tvZeLBXA156YMEliFyihwQ4mdyef/0ACA1W80MeJKK0fpRXdQLQTqNAc24n+RgOJsxcvJi5EnIaAv10dj+C5gQIg2zELyPQDv3o0+75V487O+z3xsekTaLa8iVByZdSmbHp8bbdVwGOoMExcA42CLSWx16EfZncxpcNSabvn9Sr0dj/Eocc8F6BTvf8MnHSMkmunvCDRduY8utKZfRxAQINns0OAi1tynk2HBBoS0eHs69zTIVOSZisQOfqqeLpyNUT6yHQYF72EOhknZbgQwCBtrR2mMWMjlpD4OTAp0Inyxw4ggaglkaBTucDEXI1mov8kimyyy+S0hJ8CCDQltYO+yQwgUtf5+gGXi2zcMKsXzvpxZDXPugadE6ES2X0caEs0H2v6gSghUaBdjkb5g7ltbyLQ85FzmFz9guBfiq7XOIovc4xDLxSZsm8dpKTya1/zF0c9nO7QNtXWLI9ucR5nOkDAA+lVaAZmZvxfdDxXLR5DoF+Lvv/SAgA2IkegX4VINCWF+swAK8DBBoCzR31j3sDAMDIvJhetR1B/9d/upUAADAYv/lNrFcvwLZA/9Hvik7jZf1YsGAZdUn06QXYFui//qu401iwYMEy+vKXf+4EbG62Bfp+u//Hn76JzuMoGgsWLKMupE9/8WdOu+anSqCbfimO7hl+MKt7Nc9DeOJrAEbypcQsfvbTfheHfVjLPchFc3V5cGw2znEHy24CHV7TmTxU4h9UWT3ckdQzD7KkbeYEmhMt9xAL2+Ub7vmm/EuLwFO/mx9+IUGg9c9/hWluzPjhA7ueJ2qwl8Tksb54GuPJmLiJ73L8XZmaL5/ycyZaRYrHP47DvDux1r7PyT4CTYK4erw6gm0mj0lH9fireE2pRxVob0trb11WK9DRkQbXnewVpuzXyk7wI0aN9QN9YZrjaYrIXxmjVKA38qXHz7ng2DXOzTTnOKbaIA9PY98nZSeBFiKgJoAy+bV6WjKl60rt1djUSOtJcu3xemc7iKNfVyqjjwtKXBytYrNsvxw1R7GRqHF5nC+mr63xZNIYST+1ekkfINAJPp4mdhs5MTyNfZ+U/a9B107+mnraulK9Kl8U0nqSnE2xfgSBlm1faPy4rrSRfSVsYAdf3NeItKx2/EplDgh0gjYOHDdtkIense+TMtYR9MaEU9eV2tPK0voaaT1Jrj3h/xACTR7y9UZ+IdXHjT5f+HqtaJvLvDk1Lg/0xbWnmFqXpeMn/ZJ+lsocEOgUXIOejbGuQW9MOGs7nejeltbeuqxKoAlrp+GaqfCf1wUh5HWlMvq4oMTFwROp7RWm1hb/KMnmTN997HwcjbFcXB7pS0c8DeLyjCtrFejXfu0rx65NpKJxoBjiLo6x2e0SR7hTIZogPOGW02q/qIKlCTSxvMpUCDUnGk1yXv/cuzjsZ54EbQJdiEuAtnFt1t6RYAXKbmk+i77nXwm7jy/kQftdHAT77etEfkbxI9R86fFzJnpEqjAOU9HT9/l4vECPDE/iWGkAmJhziJQOBNoxdyD4xzDre3r6DMDsQKAh0NPDA5mePuun8X6Z4yB7pD68QjwBGI8TCDQAAMwJBBoAAAbl8deg01/XVexlh9pTX/9LPi/1d2HMSFtc9mUkX4BO49x8Kc7R9ycJdCeZW+/OAO+kRvmBcyRfzk27SMmDnfUYkr3sLXhHl21BdSHQTGMgINC7AIEGa/pFShvD0kMsR5dtA4F29Am03zPmHjzgJTp9TurxHnXVZk6geXBXd2o42O7bUQ+qUNLTerxuNMH0X7SRjKN8L4iJT+R3Mg5RYWGMTkHj3BSsBZpzIx7LZZujy2ro7/tM7CPQNNnsZMnde8w2k+ubUT3+ujwFF1AF2tvS2luX1Qp0tHfnuuKz2p7xnxPOlpt13t9SmbHp8bbdV0Fb8lr/V3aCHzFqrB/oi2lX9lX23fkUzN2uJLrLttE48DtFhE/5MToLPEYPEuh0jBgeJw720WVV9Pd9JnYSaCECatCVya/V0wYwXVdqr8amRlpPkmuP1zvbQRz9ulIZfVx4nCgu2/ORihs/GRuJGpfH+bLqq2yPy9g/t2OOMGXxOIS2lbLz0S9SWYH248FFaW4fVVZFf99nYv9r0Bx0+d2gTP6aetq6Ur0qXxTSepKcTbF+BIGWbQ/3utFkHG5X56O7FBVMcz3hY/CVnVLjdzb6RSor0O6rgccpF+s9y6ro7/tMjHUELQeM62kDmK4rtaeVpfU10nqSXHvC/yEEmjzka3zDvG5U2i+MA+84QpkaI4frg+LeiegXqfUYlq4JH11WQ3/fZ2Ksa9Bbk1idlN6W1t66rEqgCWtHu76ZaU/4z+siES6V0ccFJS4OTt55XzfKk9HnUNIe+XIR146t7aVR3lbmz43ygjY32DJcg15Nrwo0MYziyeMizmaOLtumv+8zsdsljnCnQjSReaKuT1lVwcocZeF1o0nfC0ixM59F349+3Si3b7dP2+Oy+C4OGWoqDePAyzs5shQXxugUdIgUzSsfS78sY1uK59FlW1BdCDTzQoFg0Y+VBoCJOYdI6UCgHXMHAq8bBa8LBBoCPT08kPb0ebn8oZ/G+2WOg+yR+vAK8QRgPE4g0AAAMCcQaAAAGJQdr0HbSwuHn97Kuz+iOyVm4EkxA5NyjuuwOufo++v9SDi1QOfR7lsFZ6dnblKd7lvbRgIC7YBAjwAEGqxpn5ufezhkJCDQjvZA+IcSVr/gO8GUe/Bgt1TGcDKt7sZwcN035WGUxOaqXhHqd+5IQ/PFtEUiSuuf/7pRT2MfmCRmq3HI2XT1wqZyR2mweXSJHkrx5Rtlsj3vTK+f5o6TZNuVr7Ng4xb3uwT3Pc6deXf8rX2fk2OvQfOkognoJwsnR/zejExZsMVl6f3M67JIoIPNtvugoyMNris+q76Ytjj5bblZ5yd+qczY9Hjb7qugZyI198EUlcahYJPryf6oAi3GJiJfFrUnXzfa6ycR9Zfg71rMx4fj1jA30zFieJym7Hxj3yflCQIt9uByEreWecO99Uqk9SQ5m7zetRsmvF9XKqOPC0rMHM0CnfopSct64ylJ+yPrGfJ9y5Yp7YU49PrJRL6tjyrnoXFu+jEy8XH15NhPRWPfJ+V4gc5N4qPLSqT1JDmbYv0wAr2y70jLeuMpKdUzlPIoU8Y26SiZL1PIJd0hGmr9NCyXOdIj77lonJtaXDhuU/a/se+TMo9Ap0dL3rBWVlOvRFpPkrPJ61270x9BS79K8ZSU6hlKeZQpS21Kev102Hhes/Geg9a5iWvQszGHQAdb/C25ZqqUxRM1V6+M3Va7hpnxRfjP6yIRLpXRxwUlZg57pJduX6a5D6Yo8SsR2rzN5ajU25T1bJu5PMqXRb4R4XWj3X46uD7lRv0PriNSiqlOFBeKAe7iGJsdBJon6vq0VBWlaoEmOJlIVNjWuHdx2M88CdoEuhCzAG3j2jziLo7wPR2Hgk3eifj16StFTb0OgZbtWV8Xcen108JtUs7EQZ6MUtxybMVlFnr6Ph87HkEDMDJWoKfW51PPTQi0AwINXhA+Ap/68gYDgYZAvyT6JQW/zHFU9Qp9eA58mcme3rsVAAzKSQUaAADGBwINAACDsuM1aK73hB9hSneGdBDdmUCG/Hez7pO2A51+7uIL2Ik95gOuQeMa9GyBeKhA83XezA9Jq9u6PsFn/XykL5+Edxq195pLeuu9Av19b5+bcqc+d7wh0I4TCzTXh0A3AYFu50iB9swfbwi043N76eiUzgmRvFE+2C2VMVR+3IMq3Of4DomVP5oouvbCumQb/gvj/t0S5rWjS0G571vkBLonZhvwHRAhJklf/fpQXnMb22Y9m3/aq0jN3Rgiwa4UvzrRIZsi1nUPIZFtWj/Oq2SZfpGCQM/BsdegnSj4CcFJEr0DIlcWbHFZ8miyUhaEI7KZ1qvA1G84gjaTNRat2BcpyleazJqf/LXxBT6aL/StK2YNaH72Tvx8Peur7p/vB32kGESxL2BjoT0GnolZyANbbtb5mJfKjE2P8DWhN2bWJgT6lXmCQAvBUwSsuswb7q1XQ1pfItvx8PZy3coXiqMT4YhSH2rI+dITsxaUensJdHbYXFz5KLaq2bTvklzMeL3rJ4u28cWvK5XRx4V8PyDQPfT3fSaOF2iZuHKCH11WA9fPTWbN1kZ7tyufPtPEoKPl6DLGZ/1s9eUT7cnLNOaUPKm3j0CX8s/mWfWON+27JBcXsR4CPQr9fZ+JeQS652iwVK+GtL5EtuMp9SGBha6q7zXkfOmJWQlXL+SCUu9ogeZ6/JY/3qZqaNO+S3Ix4/WunxDoUejv+0zMIdDBFn9ruJ7KNve6Bq2W8W15PlZrXy7ilZdWWFztYt8rUH3pjFkJ347ZUK/nBXPTVkK+HvuayT/ZbzUGOjYWjdegXT953R4C3RMzaxMC/crsIND6OyLUxK0WaILKj7uLw2Hs5ic93zXAduUv75z4dh3FLHnlZnoXhxU6U1DuewWaL2z38Xdx5PtnofF3bbbdkZCrl8u/teAZoavqB9UV/bCC7NBiJsanXaAL8yHQG7MOkaLcKvsyCx19n5Adj6DBNPAOYc5ZenLOPDch0A4I9CvCR/N2TNPLH2AeINAQ6JdEP+30yzgHk3v6yQmenMrv0t7RsZ5lbAHY5qQCDQAA4wOBBgCAQcE1aDAI9pILLkG0gGvQuAYNgVaZ5T7S+e93fY0+7EP73PS3gfKC+6DHBwLdCQT6OCDQOfrn5vwxhUA7WgKR25Z/Wbfrs6/cNNj62qslTZl8uMBXdA8F9D2M0tGecqO/9mDF2uYSg0DlAyl8G1xoS24fPRBBSHtbflLd7EMs9K39QQ6a8LR+rNdxvjo216KcqgQCPQcPP4IOT1NJeJLyxHL/B1vylZsGbmv9+DBj79V1j+RSPRYJ046xyZ+5pPWe3o72HPkE37K5rFVjtQG32/KIuO6n9TEXs6jvXF7zKLQRTltu1nlfSmXGpsfbdl8F84vJXnDMINCvzMMFehl4ccTIE5JnnpmstE4ekUVkJmmY5AuhnbTMt1VFR3uOfIJnbDKRMHF84jaqkDbYTyl0ivCpfpZipvQ9kKsn/Ag7Hb+uVEYfF/Jxy8f67LTNTcn8Me3v+0w8/hq0mJjm1ZpUUSZD9pWbhkxbbNNdLohOdxNxMCgilaejPUdZoHPxWnZaXL92R5J9xWdF31U/S/XSMkmunlgPgT6SxrkpmD+m/X2fiR1+JLRHhvwinQ++NHDh68O5iZcKSqYtdUI7uCx3NLhJR3uOPoH29a60jR6TFa5/wV5JTFsEOheztEySqyf8gEAfSevcXIBAz8EOAm0nmnlbG33jSRl+2KGJmX3lpiHfFtuRCXUjcSBTxubnrkE3tuewvqciw2zEy/lb/WOX2Z62NfZs/xYRFpeRVmUW3U87Rg+9Bp0T4VIZfVzwtt1XQT7WZ2cj1wpAoOdgB4H2E8rONPNZTMbsKzcNpbaozN0BwMs72Tebucke7g5omsgd7QVIHElQuEy7iyMfLy4nIdWUKEPpFZ8c31yZJeMnxW11N0Zg6Xv9XRz2c7tA807G2pNLHJ5crM/OVq4p0IFGOdaz0NH3CdlFoA8lmuwzYAV6zkkBxuIcIqUDgXZAoB8K+4ujQPAQINAQ6NHJCrR+6uyXZxzB8im+vWTgVhjG8xMAMAbzCzQAALwoEGgAABgUCDQAAAwKBBoAAAYFAg0AAINSIdBnvpUHgJHBbXa4zQ4CDcCgQKAh0BBoAAYFAn1agfbveEiX5V0PHCD/foQ0UChDGcoWHlt25rlZ6vsrgiNoAKblzHPzHH2HQAMwLRBoCDQEGoBBgUBDoAEAADwFCDQAAAwKBBoAAAYFAg0AAIMCgQYAgEE5iUD/uH/78uX+5ev3+0+3Zkp+fr9//fL1/n3qTjySn/fvX7/cvyIg4EUpCzQJwjeaAF9Y3EgYvv2YdSKMI9A/vtlY9miKqZv2QY7R12/1dkv1smU/7z++f6OdhCvjnHiyOP78/pX8+EYjDMDrURDoWNQ+IyxgoTuO5ug5PVq0R5DxGNWIValeoewHCff3H2Y9Y8XxC+243YpnoMYFgNcgL9Au8b+42dc0GX98M9t+paOvcLTlj/zk0Zk5Kjcr9VNV44MVsx/fbPvWVv2RohUYX8/5QPj+fP3mfaR2KoWm6Muqf67QxSRdasXN+psIeypOro1Nm6V6LTb9OEdO6XTFjPlJBwqrfJHEOxQAXonGI+jKU8kgRn4i8qkx28kflZvP6ewzdqjNVAho0n7/1jIh15c4vECbNp0oVU3yoi9xO5qoyj63oNZzvoSwpb7lKNVrsFm9005tVMfMlXEOmO8+j2KachOAiWi6Bl17hJmd1Ol68d1MTJ6kTiytbrp1bjv+/ONnOj1ryAu0FZd1eZaSL4X+eT4n0LEIhT6QaJkzje/r9jRK9apt+jhsqjPRGzMlfhq9MQVgdKoucXDex4K2QWZirWysJuNytMztmolnNqbTWHmKTJOxyo/AAwW64Iu3mS4yDp8T6KSei1WIRSbuK0r1amy2nHEY+mJWm3PazguAVyAr0EUx3SK3bbpefjeT/tv9G01kc/T2lT7T0XtqQx5NV3jieKRAL6x8cd9LgtIr0NbfpJ4TyjSeW4JWrLdlk68J0/fWWHmaYubK0hyIwTVo8Lrkj6D9RKKZw4lfezRjyE6seHLHYuXKzHf/2bXHdw/4H45IQNoFYi0q3QJd9EVph2IhLw31CvRKOA2xOGlHkvq4leqVyhriJOmOmSvj9k2hcg1ajQsAr0HxGvTP3nteS0c+PEFZALzNIBxOGJwYxEKW3H9bexeHm7y2LblQ/e4j6A1f0v6J29IMUXnlDs9hYpL6KO0pccnuWEv1MmXeVrpsi+MnYsY7a1mW9MP61LHDA2ACyj8SgrEgIcOThBK7U8fRM3hVINAAADAoEGgAABgUCDQAAAwKBBoAAAYFAg0AAIMCgQYAgEGBQAMAwKBAoAEAYFAg0AAAMCT3+/8D7fOPaPt6AjwAAAAASUVORK5CYII=" alt="" />
 可直接用 SET AUTOCOMMIT 来改变mysql的自动提交模式
SET AUTOCOMMIT = {0 | 1}
索引
思考:在图书馆中是如何找到一本书的?
一般的应用系统对比数据库的读写比例在10:1左右,而且插入操作和更新操作很少出现性能问题,遇到最多的,也是最容易出问题的,还是一些复杂的查询操作,所以查询语句的优化显然是重中之重
当数据库中数据量很大时,查找数据会变得很慢
优化方案:索引,最基本的索引,不具备唯一性,仅加快查询速度
语法
查看索引
show index from 表名;
set profiging=1 --开启(执行)时间的记录
show profiles;    --查看提取用时
创建索引
方式一:建表时创建索引
create table create_index(
id int primary key,
name varchar(10) unique,
age int,
key (age)
);
方式二:对于已经存在的表,添加索引
如果指定字段是字符串,需要指定长度,建议长度与定义字段时的长度一致
字段类型如果不是字符串,可以不填写长度部分
create index 索引名称 on 表名(字段名称(长度))
例:
create index age_index on create_index(age);
删除索引:
drop index 索引名称 on 表名;
外键foreign key
如果一个实体的某个字段指向另一个实体的主键,就称为外键。被指向的实体,称之为主实体(主表),也叫父实体(父表)。负责指向的实体,称之为从实体(从表),也叫子实体(子表)
对关系字段进行约束,当为从表中的关系字段填写值时,会到关联的主表中查询此值是否存在,如果存在则填写成功,如果不存在则填写失败并报错
语法
查看外键
show create table 表名
添加外键
alter table students add constraint f foreign key (gid) references grade(gid); 
    --添加表students,添加,外键名字fk_students_gid 外键 字段为gid 参考grade表的gid字段
删除外键
 show create table 表名                --查看外键名字
mariadb 视图 事务 索引 外键
 alter table students drop foreign key 外键名字;              --删除外键