mysql中使用concat例子

时间:2023-03-10 04:30:15
mysql中使用concat例子

数据库为mysql,需要把旧门店记录的note字段的资料追加到新门店的note资料的后面

旧记录id为old_terminal_id,新记录id为new_terminal_id,提供格式如下:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgIAAAExCAIAAACBIV0FAAAgAElEQVR4nO2dz88cyXnf55i/w4bvexpgLvZNUQLLkROEXEYb/5C0vVpba0UWRdORsVp5FUW7l6EX2Nz3MmCwxMIEwQFCIBcCuwFj7B5yCcAho1CEbSVBsrYse1cUl5XDzLzTVfU89aN7ut6u6c8HdSB7aqr7nf4+9e360VWzHz3+iZP+239/8J/v/pez1P7o7pvPmf/xlbLphXcuf+HutV994doLxU/9lbtvPuf/PiQ/vf/W8/MrNw9H3rs6v/j2++d9VVWkm7fv3Lx959wvo6LkiO3dK3PElpV8vc2c/zseINjA//xq2fQv3/mzf20++MILF77wqPSpv4oNJCYnMl1XIOkJG8hNrrruvX1h/vy1e+d/YbWkiA34HiDYwKMXi6Ybn3vtxovm0YXX5p+7W/jUj17EBhKTFZmEZU7CBnKT95Bx8/J8fvm987+wWlLIBkQPEGzgx03JdPfb//jujxvz49965+L8tfeKntr8uMEGEtP7bz0/P4AHZCRsIDdhAz2TagOaBwg28Pilgum337nyxUePXzKPX3r01q/Or1wse/aXsIHEZEfmR9cuzukUSkzYQG7CBnom2QYCHiDYwF9+rVz6r198ofWQOb/4xUclz/6XX8MGEhPdtZ0TNpCbJLFhAxlJsIGwBwg28Fcvl0t//vnX/nz/77/4zRfmv/bOXxQ8+1+9jA0kJh7QOidsIDcJ09LmV98976uqKAk2EPYAwQb++veLpbt/9Pm7h/9++Z2L89dulju7+evfxwYSEw9onRM2kJuECaP0QOakY9jA//p6qfSVd67+80etI4/e/rX51S8VvICvYwOJSRgb4AEtLWEDuakttnevMCUhOx3DBv73K0XSV9/Zzj25+qXdkVv/ZDdCcHZk+IQNpKR3r8xdeJ0nOWEDWckVG0rLT8ewgf/zB9NJ2ABp6IQNkAqn+FvE4XT3zefM//3GdBI2QBo6YQOkwukYNvD//s10EjZAGjphA6TC6Rg28PE3p5OwAdLQCRsgFU6CDWxVmJ7uvvncpFLu70MikUh1pbzWwM3bd8yUWK1Wn/yHz5FIwyU0RiqcfMlhAyEIUdLQCY2RCidsIA9ClDR0QmOkwgkbyIMQJUXT6satXgmNkTLT0SWHDYQgREnRtLpxq7vAsAFSfjq65I5vA5vlYtasO1/lqMgO0TsfGGOe3umd51zTpx8+NsY8+/Dl4xSY9vcmnXSUP93qxq1nXcEG2gnhJaajS26Q1kCiE2yWi8ViMRNZLDcdq+5jcr428OShMeaDJ8VFRjRmpdWNW589e9YtjdMGEF63ooqlo0uutw2E6vJIxb5ZLsTaXjtennO1gZeffmzOJRqPnI4YQiOLxm1a3bj12WfPuqVR2gDCG7KoY6SjS+4oNtCxzsYGgoloHLKo46XVjVtPn37WLWEDA6bTFV665F7/wQ9TJHc0G9gspSZBs94sF1oPT6U28ORhO4sdLZJc2vmfffhyiqS2DdU27UarW6B79m0YG/Px9U/3RT29Y31re3b/iPhXBEpwvpJSWlakdfjpziUmf/H0s27Jj8mkX1vRwJOHxpjHT6+fZdsqoX3kjafGmIdvILyqhZcoudd/8MPvvf6DV197PSq5YVsDW29oluu1lEN2jhENDfg28MZTY1pVvxdmrlzcDE8emmcfPzbdWwNvPDW7MDvEwFlU3/nAGPPs48ftED0L7P0Zt3+CMYdIjvwVXgle/uvXn7VqFrcy6hiNfX660jH55BdPuyXNBkK/dkADWwGc3f3r159ZRe2OxDrfEd7YhZcuue/8yXdTJHd8G1g3s1mz3lby4dpcbw0sRzLTyPm9vKctOTz8xxmvkI424I/dWZe0Dc6zi2nHUitadkfa2ZzaQYzG9iPktn7RHiqdTztFY7+frnRM/vzJ025JtQH91w5qwH7Yv/OBMY+ffXw48umHjz0BI7z6hJcuuT+8fCVFcsO0BtZN4IF+3bjP/fYRt1spWlkPh/17yQ1qPx6shxc7NjLUKUSjcAGWap2HQU3WfrZg/EiBofct7J9A+0Vjz5+udEx++vNfOOlP/90Pt+m73/v+v/2T737rytVXvvFNP1ugU0j5tSMaaNfXTx4a8/H1Jx8+do64vyrCq014ouTE9LXfeyVFcsexgaVbjy8WTWv60HYqkVyhj/o1A+v3UhrU1hOWJRdFsp1t4EzoHu1odEpOikbhKTIhGg/RcmjvH+gVjT1/utIx+cmnv/DTqy0DaF76PTFPhg1sf+2YBlpff+PpoV/70FZImI6J8MYuPE1yfvqdL381RXLHsAGhFl837bp922LYbOTh4PG6wChtQB/fO6do3A8MHnobQqWdUjSexeQ/fPpETK9845svvvTyb//uV7QMHW0goIEzlV6//syp/a9ff4bwTkJ4Ack56cLzl1Ik19sG1o3U+9O2gc2ySesfGt8ocXKn0D5mfEl5DUyx8zEpGpUCzzkahTriSNHY/acrHZN//8kTLT1/6UuBT7NtIKqBfbfGkw8fn2Xze4cQXtXCa0vuT7//77fp1e99/4+/8+q3vn31lW988+zT3/hnv5kiub42IDcGnNZAAK2JMAYTSB8iVpQn5d89wvQYItaH+EYSjdI0ktyRun4/XemY/Nk//LxbyreBmAZ2JXzw9KEzMmwdQXhVC8+R3Kuvvf7H33n1D7/9R1//g2+++NLL7Y8+/09/PUVyfW1Abgyk24BIv28fkbQJo62AcZUn5E+ffCaEwa6X1j5jUPel2ub7SzrOSF3fn65wTP7d3/+8W+pgAxEN7H9Jq5D9TUlcpwHhjVx4vuS2BvBbv/PlbpLraQOKC/SryEfTGBBfHzvrkTTGeO1HQXnWKNbTO1n9jIdztYLHHhbz4v+8R+o+eHKEtnn/n65oTP70Z592S11sIKyBw6ftx3n/5QOEV7HwRMldfP5LnSXXzwbWjVLZ97GBEY0aj+9Ff9Lo0urGrb/92afd0igXkyCNPR1dcrNr9zrbgDD2e3gxOO953n6heCRtAWyAlJBWN279zd990i1hA6QO6eiS69Ea2MhLRJjubYF1MyYPMIPbgDTr2ZhTWNVrSn/v6satv/npJ93SOdnAad6I6fy9R5ccu4+F4EmNFE2rG7c+/ukn3RKtAVKHdHTJYQMhCFFSNLEXMalwOv+9iPX3vU6QS5cu/aOX/9O533XSCSdsgFQ4CTZw983nstKv/PIvTSddunTp0qVLKwCA02VmHvxuerr75nPn/YBelEuXLs1ms/PumoJTZrVanfclwLRYrVbGzNqpiw2c919RCGwACoANQGGwgQywASgANgCFwQYywAagANgAFAYbyAAbgAJgA1AYbCADbGD07Ncgibyzvssmb5a6R9k244B3EnsFFC2XU4z3OTZQFV0lJ4pF00RQMAnXEMmADWSADYwXJ6iCMXmW167ot6G2/+Y2U7sce4XD7ed2CZvlIr72ibNAir8/BzZQB0eQnJzPyRMSTPQa0i7StYENNqCDDYyXQ/ysm3BMbqOqaZx4E5avWjfBsJWNIhzom+Ui+tyIDdRBb8mFirSO6EVHryHtIh0bWC5msxeW/wobEPfJxAZqIByT+9reDThxEcNIeHsfR20gYixbsIHa6Ca5lHKSBJNwDZEMjg00s9ls/q1/MWEbOOuEE358bKAGQnI/VPaiDbjfCgeu8uimR21SnxE2UB/dJOfSpXWZdg3RDEJrYNo2sGXdYAO1osu9/cSf1BoIhKE0NBAL2/2VRcahsYHa6CY5B+HjRMFEriEhg2MDm+Vs9tp/ZGwAG6gXTe72cS/oBB/wq/rECRtyHmGY0B6V3oEN1EZHyfl5Jf3FBRO8hqQMwkyhRwwRYwMVI8vdPar06HgRpwbu7uPYwKA/Q9D+hhD92EBtdJVcpIhUwQSuITEDE0ZFsIF6keTuH5Nj0nktIGWaRij0bGeRs/thjQ3URh/JHT6Sh6YSBKNeQ3IGbEAEG6gXJf50wvV8bOJPMIMdyGIgYgP101dymkEkCkbPm5oBGxDBBuolGg/GmLRJGDEXiBdiZxCz+5eLDdRGT8mpTxOJgkm7hkwbuLv89fThAWwARsbRbGDdpLwamt4YCE4GaYEN1EY/yQW+nSaYtGvItIEXmDCKDVRM15hcN95SEe6bPO38woxRqwR5gM8uV+78xQZqo48NRAaYUgSTdg2Zr4/xFrH2Bjc2MF60zljtYV2KyXYZ4vesEWQpS9IKLrFZ4NhAHRxDcvHhJRMUTPQa0i6SsQEHO9LtX2uGDcDwYANQGGwgA2wACoANQGGwgQywASgANgCFwQbyIERhaNAYFAYbSGU7VrBtDUzkT4ZzARuAwhzHBk4egw1AKbABKIz0+tibz2WlX/nlXzr5dP/Bw+0/Lu1ZAQCcKLMfPf5Jerp5+875PaOXw9AagFKsaA1AWVZ+ayDXBs77TygENgBlwAagMNhAHoQoDA0ag8JgA3kQojA0aAwKgw3kQYjC0KAxKAw2kAchOmasdbTUld1DGaIlHLJEVpTcZVP2BwmdAY1VRVc9hHamkTe01D6MZXD21BO+jQ3kQYiOFnshaH/vbmeRXnkp6Vacems/Ji0f6uYVFouPLRuMxurgCHqQ8zl5HCFulgtpv0slw2a58NZP96/BtYENNhCEEB0p6yayWV90b1g/gx9eu//G1nbffrFpnJAWFhVeN35UorE66K2HUJHWkZDDRDMI2eUtLg42sFzMZu9O2wbCi84TotUQ3bDDjjl1W/G8/aJa33JjWiyN3cdOgG56SClHekzwvhJpYSRcq2MDzWw2u/zedG3AakJJt40QrQan4vd6iYQOGjeetM2eQmF/qOxFG3C/JZwXjdVGNz24+GrL3Os6BfkbQmvg2r3J2oDdkeb/nxCtBz+odiNlzdr59+FDeWROGeXVR+p2X0hqDWADJ0A3PTgE9h1WZxVEMwinkDI4NrBZTnpswO1nwwaqxR8ibh32o0V57s+0Afu4F9dCaVJgorHa6KgHP68kDn+Ey+npDGRoHQqOYzNTKIS9x7gxhGgliCZwCJqFFz3HsAH3qDLe58UsNlA7XfUQKWInWPuo174IZRDPok1Os21gwp1CNpvlQu5Eg1EjNn39iNmGxD5bWiQHDkdnIlmnPXs4EyZ6oLHa6KOHw0fyuJH8FsC2mGiG1FMJNjC/chMbMGbdSL8kITpylO5PUfztNoPecZ9kA6F3gfS2+O6LTEOonL560AxCfAppKzWaQbtYSXKODVx8+/2p24DfG7SDEB0z6hCYEhrtKEp7ogsfF64m4XUh3huonZ56UOtt8Rvtk0UzJF4GNuCjeoAhREeM7gFGea6PvTigxtPRbGDd8BbxCdBPD4FvB2YPJWZIuwrBBqb83oDvAeslw3cVEPQAY4w7FGDsLqFWGfaLBnI4dQ17S1xajxMaq44+NqDKQPpYewlSzWCvsJK6mEQzm/ZMIXdJAm/9DkJ0lFjjrm2kJX1CPfahCdhaf69mPlLYh99R34LG6uAYeoh15B/yhAoPZrBFL5+KCaNthNqE4TsoDBqDwmADeRCiMDRoDAqDDeRBiMLQoDEoDDaQByEKQ4PGoDDYQB6EKAwNGoPCYAN5EKIwNGgMCiPYwM3bd7LS/QcPp5NWAACnDq2BECue1GBg0BgUZkWnUBaEKAwNGoPCYAN5EKIwNGgMCoMN5EGIwtCgMSgMNpAHIQpDg8agMNhAHoTomLEW+1JXdg+vALYvQ1nz0Vp2KmnxOW3xyF1mZblHqIWIYJxs7r6nMoE9tCMfiqqOxgU2kAchOlrsNXX93Yil3bzbnzthKUS18x2liMhyke7ZsIFaiQtGyJuwDZGbx1mE1F71OKbqeFwY49vABhsIQoiOFHeJcDd6hAV914115BCByTsQu0GbbAPbq2kaMTsaq4OoYM4I3m65SOuIWnRc1bG42OLYwHIxeRtotbCEW0aIVoP1ZCQu6563x6S25Ue+DewvRsmOxmojbAOR2x0sx6nUlZIzLkZuMTg2wLYzh19V9GFCtBp8G3BvZuaugF57Wt6/LGYDh9jFBk6EUM0bvd1n5HcyZqlaPw2tAQd7b9jNcuH+yIRoLdhqF5+bsjeH3bUUm7Xz71iBbhG7LNjAiaDbQMLt3hPYVlgbA85SdftjsVo72MBmOW0bsNksF+LezTB+3Cd1IWLU/YuDzepDSPrf9CZ/iP2yof3EjUFj9ZHWuxiun1WBWocdWeeoWixgBzOFVIS2ACFaCYLY3fDYV+c5NnCIy0XCxI/tGdxZGvE+JDRWG7JgEm+3XsRObt7En1YpGao+fOxLGxsQEH/+LYTo+NGfh6xJ/81am4URGiL2xwai3bC7DPGJRjvQWG1Igkm+3Wcfyb38covS6xqKqzrUTsAGdKRRekJ05ETaxF5e1S2SYlJ7uvK/FHpZyCkCjdWGUuWn3W6jG4QoRHFAwClM66/UvibYwHw+v/weNmCM1C9EiI6ZHA/QXSAn+iKz88LdwbQGToTYHM0tqhjUil38RoLk5LfbA3FBayCI/QaeIURHTJ4HuLPC3E/SWgNdZmVEv43GaqOfDQS+HZg9FLgU+9OUuMAG2rjdar6zEqLjJK71deNMBY5MBtLeGwi8mG+dIjTC1M6BDdRPHxtIeVTQF4uIqTrx2Uh4fWw+f/7avenagLP2E+8N1IA1StamHQDt/lohMLTuXCurcyK5yaB+LJ0RG6iVJMG4+cUunkg1HVw6LqjqpLgwtAY8InUFIQpDg8agMNhAHoQoDA0ag8JgA3kQojA0aAwKgw3kQYjC0KAxKAw2kAchCkODxqAw2EAehCgMDRqDwgg2cPP2nax0/8HD6aQVAMCpQ2sgxIonNRgYNAaFWdEplAUhCkODxqAw2EAehCgMDRqDwmADeRCiMDRoDAqDDeRBiMLQoDEoDDaQByE6ZqzFvqLbj4U2glKXhYueIlqCk42l5Sqn6+0O7UzTrFMyuFcQ0KRyDXuwgTwI0dFi7w3h7wvmLMPrrcqbsDpo5BQ564sK243vQWN1cKTb7eeL1uTeFpRnB0ILlsYk17KBzWx24a2PsAENQnSkrJvIdmHRvWEP/1X3G4icIlqC88WmYaHpijnS7ZaLTMzgn1kzgrjkDjawXNAa2OPtPGYMIVoRkQ07YpsCRncRkQtNKWEfqew3cCL0ut3J5QgZpC+IPpAiOXvbGWzAGNVUCdFqcOporwtH305+WBs4KAsbOBF63e4zIvuQaf2Y8sbDSgshzQZoDWxh+K56/GjYjQ83a+ffHqk2oMetXkL78QIbOBF63e49+cMCynndJ9hUyR1sYLPEBozZLBeL5drbh9gYQrQalGf9w1ShQMAl2oDenFBLsI9jAydCr9vdzhvZTNvJoDyGCIPGSZKzZwpdfm/aNrBZLhbLjbAdvTGEaCWINfRhpsQiPG0jyQYCJhB8TIu16dFYffS63aEiwhkSbCBHcrYNzK/cnLANbJaL7a+GDdTKNjqce7fzAG9soNsQsXiKSAnRqUp70Fht9LrdZx9lDQuo520fzZOcYwMX335/qjZwZgLYQKUoFbQYRtoDfcQGYh4glhB6F8jJi8Zqo9ftNp2GBQ7nVYeIcyWHDexozwzHBupDr6Dlnlf1BQHdBhI8IFKCUxYaq59et7vTsEDgxMGLoVMojrXUAE9qlRGsoMXWgBaXaiCleUCohJTzo7Ha6GcDXYYF9I/CpaXbwLV70x4i3kFroCbiFbQ3FJD73kCyB6gliBeNxuqnz+3uOCygfBq7El4fywQbqAilHecq3skmzbtQi0g4RaQED2ygao5yu7t3CDlZIicPXQNLy4nY99f60QhRGBo0BoXBBvIgRGFo0BgUBhvIgxCFoUFjUBhsIA9CFIYGjUFhsIE8CFEYGjQGhcEG8iBEYWjQGBRGsIGbt+9kpfsPHk4nrQAATh1aAyFWPKnBwKAxKMyKTqEsCFEYGjQGhcEG8iBEYWjQGBQGG8iDEIWhQWNQGGwgD0IUhgaNQWGwgTwI0TFjLQalrs/eK4ObSd+KuHMGNFYVe9FFVhjdZYsvRHhWVjRD/2vYgw3kQYiOlnUTXkbaWZLXX783muGsXCuWpV0/emVAY3XgVNMJu5YGHi3a+TL2ITvSNbg2sJnN0rcewwZgLLQ3jtsfsRQf3Zc1YePWzXIRDrX+GQwaq4WDPGKr/G+l2DSRKr7DbpRHugbHBpaL2ezCWx9N1wa8hpjzkxGi1WA/zQvP9nZIRTNsIym6BXG/DMagsfoIV8H755FoHX/kfcgyrsGxgclvO7NZLoOPaoRoNUj7MrXjxD0Qy9B13/CMDFvQWG2EquBDozR2+/vtQ9brGoTWADYQgBCtBT9mduOyzdr5d2KGfZypez31z7AFjdWGXgW3eyYjNtDzKaLXNTg2sFlO3Ab8LmYbQrQSlJ2GDzWwEk9qBmGAzT5H/ww70FhtaFWwfTyhGu+xG2WvaxBmCk16bGC9XG5CVQUhWgVi9XqohhfylIlght2HQvuh/aDVK8MONFYbchXsHg3aQJ9hgf7XINjA/OLb6ZOFTs4GGqc7mSe16thWt3IV73X9O0PEeobo/NH+GXagsdqQquCEiWfOR52HBfpfg9QamF99d7I2YLNZLpxflhAdOaIHKGHUbjNEM8iPW+1KvH+GLWisNpTqVkdqp/acXNDrGrCBIPYrSYYQHTeKBxitY7UVOtEMcigeN8MWNFYb0R4dY0ygLu87LND/GugUauO93IMN1IPuAUZ52G/HRDSDGELR8bfMDMYYNFYf/Wyg97BA/2sQbODye5OdKeQOBtApVAtBDzDGeEMB2nsDGetRaC+c9cpg0Fh99KmCjzAs0PsaeH3MZrNc2Ot1uL8YITpKrBXh2giP3moPbUoGO4toO70zoLE60PretYcRvU+we4fQUa6BpeV82j+sXw0QojA0aAwKgw3kQYjC0KAxKAw2kAchCkODxqAw2EAehCgMDRqDwmADeRCiMDRoDAqDDeRBiMLQoDEojGADN2/fyUr3HzycTloBAJw6tAZCrHhSg4FBY1CYFZ1CWRCiMDRoDAqDDeRBiMLQoDEoDDaQByEKQ4PGoDDYQB6EKAwNGoPCYAN5EKLjZr8ilLAonLgKl7Yk4y6zvAFB7MtWrsB2yMoKYGisKgKSE7LZK1dqNOuUDO4VBBeVC2oSG8iDEB0pTsxoNhDZu8MtzMpuLzuuLW3trAi5WS68fS3D60yjsUqIS07IGxFg/j5k9pYo4ibcYU0a49vAZjabs/uYDiE6Ug7hoS28nmwD26Bpmlh2bTuBcCPBX/qaxczrJC65PamKyneBdRPd1DSsyS2ODSwXk952Zseh/eTdEUJ09PS0gX0Yddn+VarU/ZJjV4vGaiNsA+mKOsY+ZO7DSViTOxwbaGazWfoOlKdoA+29ZoRfkBAdPb1s4FBVx7O7OWLfEC9M+BIaq41Q7ZyuqOPsQybsbxd/9hFaA5MeG1g34Z+ZEB09PWyg/bweyS4MDexPrI0Bi60BbOAE0G0gV1FZwwJqpsO1xDS5w7GBzXLSNiBtO2lDiI6eoA2ExvSi28eHp1sIo4DOgJ3gA9JAMxqrDU1yCYqy83bfjbKdyTllUJNbmCnUZrcl/SHYmcVRH2l7c8sb0Le+ltTF0/7GLuTsM9ux61b6e6FhA3UjSy5LUccYFvCr+ARNGmOwAYvtfVos2h1rjA3URpoNOHWy/6WEJrjQDRubq+e9eSDM40BjtSFJLktRxxgWkBqWiZrEBtr498melGsI0QpItYFWjIRe1AkVZseTeOJYU55HjRNAqfKTFdV/WCD4Fgs2kIX/ZGa/MWQI0QrIswE1tlIG5Ow8+miCfjXSaBQaq400yamK6jssoHmAdk7/crGBNruxgQPYQH3kdQqpGVM7hcIzRiMX4wnOGDRWH/1soN+wQMADlJNqr6pgA3vcsKRTqD6UoLGnAotjZxaRt/bl8IuMFljXoNoQGquNPjbQa1gg4gHC9+XShNfHpmwD9q3y2gKE6GjROmPdh/WEHv9WbifArOFdLfqCU7Tb16BFLxqrgwTJ+fnFDpquHUK2HgOXEFvOkNaAR+vu+jUFIQpDg8agMNhAHoQoDA0ag8JgA3kQojA0aAwKgw3kQYjC0KAxKAw2kAchCkODxqAw2EAehCgMDRqDwgg2cPP2nax0/8HD6aQVAMCpQ2sgxIonNRgYNAaFWdEplAUhCkODxqAw2EAehCgMDRqDwmADeRCiMDRoDAqDDeRBiMLQoDEoDDaQByE6ZqzFvtSV3WNLgIU2HHZPFVsE3s/g7D4mfBONVcVedClLFbb1ENqZplmnZHCvIEn2omKxgTwI0dFiLwTt77ztL*D/fZrkQo1vY6jslg71krbZKMBqrg5wVa6OCaefL2ocsJnv7iLJqtWsDG2wgCCE6UtZNpEZP2BtW2BdYOddsNls0jRqx0QztE8qLv8PoOegntt9Aqh7yXSAme2GZ6nXjn8KxgeViNrvw1keTtQGpHcbuY3US3W7DD6now9o+22yx3ET3FEzYv0ysP9BYbYRtIF0P/fYh22IJXdysIL77WDObzeYX335/qjawblznZNuZWnEqfq+57BxI2XvYtANL+UI0g3uJXg40Vhuh2jldD732IZMziRcmXIfUGrhyc6qtgc1yaT8uNoRorfgxsxsoa9bOv1ufNuvwcFr76Sq6mVQk7NUNBNFYbeg2kKuHrGEBNdPZtYitgbgNbJaz2bV7jA0YY6R+N0K0GvyxstZhoYoXxvDk9kOo+RDNkDQNCY3VhmYDCXqw83bdjdLO1LoU4UvS4wczhTSEpoAhRCtBNIFDTb/wp22Ie9RbQeTGujRnI5xBvEhl2gZUhGwDWXo4xrCAJHu30t8/hkRtIH1g4JRtwB0l2EGIjh+xt8Wv5rcBsc8Wmz8anWiUMBNJu1TGnypHqqKz9HCMYQG1k9F9VUWYECfYwMzCoKUAAAvjSURBVHy6YwNnbJYL+X4RoiNHCQYxjKyHJ/Fpy5rkobMLrVAG5XKllj4aqw2lyk/WQ/9hAd0D5LyS5GwbuDDhmUI7VBcgREdN5IFIHvHdhaTek6/U4UcZ0pPyoLHaSOmwCeih77BAjgeILoANSEg/1A5CdLQEg0FsDdhxGR3ylYrsaQNiFjRWG/1soN+wQJ4HbAuLvkVspv362JbAe0SE6DiJB4M9FGCk8bToC2f+KXu8989iEidDHxvoNSyQJHt3+RKhKOH1scnPFArFNyE6SqxBsDbC0324xz66CtcZnVoD9hUw/lQzWv9/cJ2p0IsmIqEMSbJvX6Z2IiaMCtAagHMEjUFhsIE8CFEYGjQGhcEG8iBEYWjQGBQGG8iDEIWhQWNQGGwgD0IUhgaNQWGwgTwIURgaNAaFEWzg5u07Wen+g4fTSSsAgFOH1kCIFU9qMDBoDAqzolMoC0IUhgaNQWGwgTwIURgaNAaFwQbyIERhaNAYFAYbyIMQhaFBY1AYbCAPQnTMWIt9SatCBTOIS4W5y88NXIIxaKwy9vczssLoLtvhhod2pmnWKRnUUsTtlRQ5GmOwgVwI0dFiL+MsbMsayxDfH+AoJbRyyKtHorE6cGrghB0iFd938+UsWxv7wma58FaaVtY2b9nABhsIQoiOlHWj7yOcliFhC/n+JQjWxO5jlXK427H9BrZ3uWm6bUMUzJCyxZ1XgHetjg0sF7PZtXuTtoHw8tyEaDVk7+eRG1HZJag7l9tfQWO1EbYBa0PreFsxbx+ybNGK53BsoJlNe0t6e/tJbe9mqIHR2YD4qXCVaKw2QtX3wedT+m+y9yHr1BqQ+yHt1sB8unsRe1vRO9sGEqL1kB9U2TaQWYJcWfjNATRWG7oNtO9uRF/d9rbOEq26Z6VjA5vlbDafX313ujbgNbnsu0uIVoIwRBzL4E26iMz9yCxB8SVsoH40G7CPJzwk5O9GmSDa9kQhRdLCTKEJ24Cz/6TXOCBEK6GDCcg5Ih39OSVgAydLoJ2X2lbsMCygZYqK1i8GG/A4+KvWeoJRozZ9kzNEs3UqIa2yQGP1oY79p47mdhoWCGTMHYGQbGC6YwPGmHWz/QmVn5MQHTnH8oBDVi/2upYgtuoZIj4BlCpfx9FUt2GBQNb47FVh5ottAxfe+miqM4XcoYB14/6ghOiYOaYHGDn4+pSQ9tCIxqojqcNGr8s7DgtkniWUQbCB6b434I8FeEcI0dFyZA+Qnqv6lqC8Pia10KEi+tnAcYYF2ieJdi+JQ54sJrHFmyiEDdTCETxg3Xjjef4IX68SvCCV4xuN1UYfG+g3LBCTnDPjPXExiWY2ZRtwe4F4fawWrMWz2ljDs6EMxkQWielfglCQaCporA60/n/tSUG0gd4dQlHJ2cKVS6I14BKOUkIUhgaNQWGwgTwIURgaNAaFwQbyIERhaNAYFAYbyIMQhaFBY1AYbCAPQhSGBo1BYbCBPAhRGBo0BoURbODm7TtZ6f6Dh9NJKwCAU4fWQIgVT2owMGgMCrOiUygLQhSGBo1BYbCBPAhRGBo0BoXBBvIgRGFo0BgUBhvIgxCFoUFjUBhsIA9CdMxYy2ypK7trGcSlwtyluoIluBkCO5cFcqCxqtjfz8gKo7tshxse2pmmWR8lww5Ls+JlYgN5EKKjxV5TV9sv3t4g3M8Q3bAjVIJ9UmmFYHu9SHn1SDRWBynLyXp5I5tV9N+HzMlgL56fuNC02cxmF+ZbknYkxgZgFKwb8bn9oPj43rCxCIuVIFTq62bmeZO/7QyLmVfJ4e7H9hvY3uWmie4keXQXkD/3rtWxgeXibBPK966mOMHp2UDL49mSvmZswQvyz7SBWAnio71VQaibULK1Ud2EbWB/i+MbCvffhyy+AY6Yw7GBZjab7fej/+jaxXl0X+ITswFroxlh1xlCtB6knb6cjZnsA0mtAb0EMb7aZYrlsyX9CRCqfA8+3+1B/agZtIsQWgNnVfz7bz0/v/j2+xOyAWfLNrakrxit5357qP1v6xvxpzWtBLE10C5Triz8r6Gx2tBtoH13U1qbg3YI6fuoOjawWbaHiBP6hU7KBvy9iF1fIERrwR8ibh2We/y8iReRPSQT9hNsx53yqIYN1I9mA/bxcC3dezdKNUN7opDSUgjOFMIGvOYAIVoFogkcZmssEqZtbIuQanW1BPdhax9/2MCJE2jnpXY6lhgWkBvBxmADNlKnEDZQG2LTd1eDez370b5aa6goXoIzR3uzXJx9Ja2yQGP1oY79p3Y6FhkWCGTEBizaE/w2y0XT0BqoDKX7UxS/0nEkf6lTCdY0A33wAI3VjVLl60jt1GGHBZyLleYoKzYwvSFi075/uylejA3UgzoEpvSbRtrR8fmgKSWEXl0Qj6Gx2kjpjwlU1cMNC6RehmADU54w6uCNEBOi40X3AKM8y2e9KNClBHdoSXl9TGqhQ0X0s4EywwLBqxBsYOKvj7XwXYAQHSlBDzDGCB35bofOuvHG86QJp6kl6LbhvMsgj9dBRfSxgWGHBZwqLHExiWY2m12e8GISrRG99uDeAUJ0lFgDs20C47fKu176x5klBOeEhPKgsTrQ+v+1Gy/awPAdQrZk5YwsLWcTXkqCEIXhQWNQGGwgD0IUhgaNQWGwgTwIURgaNAaFwQbyIERhaNAYFAYbyIMQhaFBY1AYbCAPQhSGBo1BYQQbuHn7Tla6/+DhdNIKAODUoTUQYsWTGgwMGoPCrOgUyoIQhaFBY1AYbCAPQhSGBo1BYbCBPAhRGBo0BoXBBvIgRGFo0BgUBhvIgxAdM9ZiX+rK7rElwFol+VmCC8OJi43FVqhj+cK62d/0yAqjnqJCO9M065QMe6KqjsYFNpAHITpa7DV1/X3BnPV4Q8vzHvYcFhYoDWxAkLQHlLMi5Ga5YL+BKklYkNbPG1FH9jZjcVXbepPXI3VtYDOb/ejxT95/6+q1e9iAACE6UtaNG4aO4NP3ht1+sWmcT4UAau9ZGirROWfkuRGN1cHhbsf2G1AUFSoyMUNU1cpOR+Hdx5aL2Ww+n8/nz0/BBjbLJtiCEm4sIVoN0c3D5JjbR4kYcOJq8c5WM7G14aN7BaKx2gjbgKao3HKEDFFVq/ueCnvr2tvO/OjxzcsnbgNnnWly3+/uqLuFoDGEaEVIO32176e4nfwhROLPXcbLlLKrZXzHWDRWG6HqW1eUS5dtxiKqFk8pFCO0BiZgA1uEPSbtLcT9HekJ0Wrwxb4z/2bt/NvJsbvjSa2BPBvY1xaR/cfQWG3oNhBSlEN2h1DrDJqq5QvzpezYwGY5aRtw633fBwjRShCf9duTKpRJQPZgW2RswN3a1Zvb4TfX7VOLV4nGakOzgYii/LwdN5vUVK20L6I2sJ0pNFkb8LqBvAOEaBWI1euhGl4I0zbEbldLH26lvw++8KbDnknYV6V11EJFBB66g4qKFpGQIaRqbCABzwb8aRzYQIW41XXroN+L2hoHSh5APjzrRyb+2FciB6USk1AR6kBs6nTiLsMCh8OqqhP9CRvABk4M0QOUMDprM4Re1AmGpzB6FDitGJTYQP0oVX6yojoOC0RUbcS2ZsoQ8bRtgE6hylE8wGgdq6GWeMq0npgLOIWIRSqPZlAR0R4dY0xAUZ2HBeKqTmunYAMMEZ8KugcY5bkpWNMn2IA0ozh4VqFMLSahIvrZQOdhgRRVK6+PSbMSHBu49/aF+fzyexO0ASaM1krQA4wx/oCtNpfIKtEqcN24Nbo/3Ou92uNkib7TZtBYffSxga7DAq0zB1UtvT4jL2Nlvz42PxBvE1RsA/LwHq+P1Yg1cttGWhQooc/fyEHb7vEVLSdpmZnIawNorBK0/v+s9mWfeaLtHEHRxRQ30aXlnB9OGCHQflBCFIYGjUFhpmkD3SFEYWjQGBQGG8iDEIWhQWNQGGwgD0IUhgaNQWGwgTwIURgaNAaFwQbyIERhaNAYFEawgZu372Sl+w8eTietAABOHVoDIVY8qcHAoDEozIpOoSwIURgaNAaFwQbyIERhaNAYFAYbyIMQhaFBY1AY3wb+Pw//Eu5knhfbAAAAAElFTkSuQmCC" alt="" />

共有2000多需要转换。

存在多条旧门店合并到同一个新门店的情况,最终新门店的note字段需要自己note原资料加上全部旧门店的note资料。

在excel中拼接SQL:

select @note1:=max(note) from cmdm_terminal a where a.terminal_id=149356;update cmdm_terminal set note=concat(note,@note1) where terminal_id=147611;
select @note2:=max(note) from cmdm_terminal a where a.terminal_id=280149;update cmdm_terminal set note=concat(note,@note2) where terminal_id=147663;
select @note3:=max(note) from cmdm_terminal a where a.terminal_id=291854;update cmdm_terminal set note=concat(note,@note3) where terminal_id=147692; ......

excel中是这样写的:

=CONCATENATE("select @note",A2,":=max(note) from cmdm_terminal a where a.terminal_id=",B2,";update cmdm_terminal set note=concat(note,@note",A2,") where terminal_id=",D2,";")