Mysql错误:#1054 - Unknown column 'id' in 'field list' 解决办法
第一次用mysql,在插入数据时,竟然报这样的错误,
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwMAAAFDCAIAAADph0UxAAAgAElEQVR4nO3dfXNb12HncbyW+BVsPduHne72H45HM93dSbeTtFV2k401w0Zdr3ajOJUa24zlTRPJSKtmnJbWyrYcxgpjmJJtUZQ3lEPWpZ/k2nqAKAGk+CgSfABAUHyQSEqy7v5xLi7Ovfec+wACBMDz/cxvMhQeLi4BMPfnc84FEhYAAICpEo3eAQAAgIaxm9DkyvnzY9/uvvGfutJPEEIIIYQYkoRlWZdyPz6b/bPx5bfuPpi4/+Xi/S8XCCGEEEJMSGLiTm9P9mur92+sP/hi5f4/37n//p37/YQQQgghJiRxYWzfaOmN1ftDS1tni5u/Kmy+QQghhBBiSBKnh/94eeujpa0zDd8VQgghhJAdTqIr/cTK/cECo0GEEEIIMS+JrvQTd+5fbPh+EEIIIYTsfEQT6m/4fhBCCCGE7HxoQoQQQggxNzQhQgghhJgbmhAhhBBCzA1NiBBCCCHmhiZECCGEEHNDEyKEEEKIuaEJEUIIIcTcVNmE/vHjg69d+mv1tbOH9x84nPVdnu3bk0gkEonE8cvuGyf2Deke6PK+RAj9fSNkqHNPz2xlx2q12Qg5dlz5ELOH93cecz1j0j/Vz0/lBp09B/b0zGpvub+v03eXlsix4+5XZKjT/RYihBBCtpFqmtA/fnTwqXNPfufsN1/9+GnFDZwm5O4x9pHYn8v7EqrmFBy7vmgP6p09BxLBm8327dHu0vaS7dvjfejwSmc/P077UfUzX48MbkKzh/cHP6Tm+RnqDLmB7unV31F5+86eA0HVs/wMeOudvgl19hzQv80IIYQQVWI3oZ9/9N3/8e63//7akR99+jffOv31zsH/JV9bORa6jtnHjte0lIhH0Q0MRDiQvzHUGdCitpfgUS772dizP7HveKf6Zvb+q3ZelAD5SdZy/3aVZ9gpT5qhu6FO56E7ew4oniXd06u7Y9Dt5duoXyy53tk/O0+C6j1z7LivORFCCCEBideEfv7hd/e//a2fXnn+xSsd//1Xf/ZHP/r93Nrr3puVD7HaA7bvmJft2xN1Qsoe54hwtNMPNTm1oB7DQiHbvLwvkdg3ZM+OHTuu73PKeIdDwmbHQjqT4vlxN4mAVud9esPu6L19Z88B6Xexnxb/A8m/lN2ny0+CuvTUb6iPEELIroy2CX06/7MLEz+RL3npw+9+5+w3j13uOHr5uW+d/vp/eOH3FDVoUznYEDwm1NlzILH/QJQDmJhPidaZQifdxH7q5q2qHDHSL9YRHc7ebGWd0FCn8xuVZ4ucMRtpd8STE3OJTGfPAftRsn177DsGrxPyNhJ9V/M8vaF39L0cYYNP8txZIpHYN1Te88qT4F5WpX/7EUIIIdqom9Dniy8dvPjk4cGnztw8Ii55aeh//+WZ/3b0i2d//MUz33zja//+yO+qa9CmfSjq6dxzvNNZIn3s+IHDPeXxCe+R1R4/0CwidsU9kBCckCakHlHY9mpc9W8x1JlIHNh33HVo13Qv5exVeb2zWOLtbFYa/5C6ZqXriLXGQby/rGKkJ3ITCr6j6uVw1kJpS/Ds4f3ll8l5acJeIybICCGExIiiCX089w/f6//23146/NPLP9z7qz9JXev4p48Otvd8428/f+ZH/3r4v/7yT//w+X+rrUHSIp7KJNTsYec47T+MOQs+Isxr1KgJ6afYttuEghYJVUZo3HEPmMlNSDEmVNln95llYiPlMbPZTvkXrwwIbbrGhBS/bPAcVsAtQ+/ofzku7xO/l+hDypc+27cnkdiz/0Di+OVKv5EqkbLxBJ5DRwghhLijaEJzd3/x5Nt//v33/+p4+v/86NLf7H/3W0/1PvnCpUNH/vXQN7r+y7/74eP6GtTZcyBxvM8ezJD+i/+wdkzIVR1Ch4Vq04SGOhPHL6uPl3VuQpqRGV0T8o4JVfZZ1E2pPdjDP74+oX/QREIxz6iY5NK0ivDZMfcdgweNpLGfgnsj+w94XyzxGuk/YoAmRAghJEbUs2O59V/8xemvPnX+yaOXn/vx5z94/rPvP3/p+3/xiz/5g+cCalA5s5Um5J+7cVcNb7MJ+wSdGs6O1acJBZW5+GNCmibkVIHKifeKOnW450CiPKCienKUz7OnkURfMR16R8XtQxYkZfv27O87pq41QS8us2OEEEJiRLtiOrf++ldP7Nn31t4jn/31c59+789PffX3n/2d8Bq0GaMJqU5lD/5ImB1uQu4lzJESMCARY0wo27ev57J/dsy18Wzfnv19h4/bu+etU85zKP1GUkvTr5uWXhTptZg9vD/KCmj/HbW3P3ZcGsFSnjw41Cfm+1QnxAW8sqyYJoQQEidBZ9HPrr3+xN/90Te6/vTrr/3n33vm30SqQZuuJqQ87h+//EbgJx+6jpH+q0KbkO/U8dDTszUX2r+IbixHne2exS3OZes8pjiiu8dR3A/kakLqBUDeXqXbB6mxOW1JakL6p1d1x4DbuxZCBQykuZdGhb0Bwj+YmxBCCJES8nlCs2uv/+ELv/sHz/7O3HqkGiSvX1F2gspnA4bNgvkXwXiHT7YVxSHWd0iuYkxIPaMU/bMQVU9a5deXr3Lf0nfO+aa7avg+aDGwfzRPKhOCYQXOea6YGiOEEBIj4Z+sOLt6KmINIiKKb9sgOxG+bYMQQkjs8F30hBBCCDE3NCFCCCGEmBuaECGEEELMDU2IEEIIIeaGJkQIIYQQc0MTIoQQQoi5oQkRQgghxNzQhAghhBBibhKnh/+4uNnX8P0ghBBCCNn5JC6M7css/byw+auG7wohhBBCyA4nMXGntyf7tfl7jd8VQgghhJAdTsKyrEu5o2eyX0sXjs7f5fvFCCGEEGJQEpZlWZY1tdLXN/Zk943/2JV+ghBCCCHEkNhNCAAAwEA0IQAAYC6aEAAAMBdNCAAAmIsmBAAAzEUTAgAA5qIJAQAAc9GEAACAuWhCAADAXDQhAABgLpoQAAAwF00IAACYiyYEAADMRRMCAADmogkBAABz0YQAAIC5aEIAAMBciRwAAICpaEIAAMBcNCEAAGAumhAAADAXTQgAAJiLJgQAAMxFEwIAAOaiCQEAAHPRhAAAgLloQgAAwFw0IQAAYC6aEAAAMBdNCAAAmIsmBAAAzEUTAgAA5qIJAQAAc0VvQlcuJE6cSFy4Uvn5xIUB59rRoXbnWvn2J04kTpxoHxr1X1jJm0Np3VXOBsX2fUlKDxhjD4O35t6Tys5XZyCZaO9Oyz+olZLWxoDnMt1dQjZVC8qHKG0kHqzW93EBANhR22pCUkvwNCFfrVGWjPAm5DxElU1Is4f6raWH3tTuYXUiNaHF7gdWshR/m/WjeYj06oP21cW6PjIAADtoe00oceLNbtE03E1I9Am7hfjuqB5lkW+mu8Sz5W3soXpr5YYkFawrSd3I0EAykUgOKP+V7m5PCO3d3a4m1J20r5DumsuVNhIbqh4k1xHlNnUGkon27gHnHuKx0t3t5UdNd7fLl9obi/QQpaT1oJsuBADYJbbThC5cSHpGWdxNyDU5JW1k55qQfg+VW1NvXNzRPyykbULSj6JbOE0o4bpNuWnoB4QqTUizTR31Y1Wq0ECyvb3dM1QV9SEGNiyGhQAAu8W2mtCV9NCb9qCLp2d4pp/0s2beoaPg+a/YTUi/h6qtDVxQPGJ5WMjX6jRNSBpjybn+6b595Z+Lq+26UZZyS9FuU0fzWNL2kslkIjlQaUcxHoLVQgCA3WN7TchuCW8OpRU9w55XcpWheE3IVz7iN6HAPaxLE/KUEO06IadrlDYS/rXS7vtqt6mje6yBpN2I2rsHutvbu9PlS+I8xOJqu26HAQBoMdttQvbPySFFzxBcM2URZ8fsVlRe4uPbWpwmFLSH9Zgdi9OEkgO5wCGWWjah8oBVe3c63d2eHBAdSFwQtNt+AYNYAAC0mO03odxo95ueWTD7kvLgijSmEnmdkG6lUTVNSLGHmq3VYsV0jNkxcXmEMaEazI5VFkUnu0X7SXe3t3d3J6XV0hEfgjEhAMDuUYMmJK0K8vaYSLNjckmSmkq5vmxrxbR2D3Vbi3EWvXT+lb3E2L8a2rdiutwupNtEWCek3aaO7rFc1wwk29vbK4Up8kOwTggAsHvUpAmVV9jIl7gqhdMkYjQh5QhNtU1ItYfarbmXewd9suJA0jnrfKC73TNCFHwWvVQzopw7ptmm7px27WPJw0VylQt4CN+2OXcMALB78G0bzWAboyzp1Q1dE6rPsA2fJwQA2E1oQk0h5mdMy3fcUFWoujUhPmMaALC70ISaRG2XIdepCbFCCACw28RoQolEogn/FwAAoGqUCQAAYC6aEAAAMFfEJmSfWO76nENxXnr70Gi80911Z8sHfOCQ/HE+0g2Czm/PlZJ8+h8AAAgRdUzI87HRufKHL7/ZPSp9dJDv84Rq3IR81/q+I0yo+lQsAABglMizY3bd8Xyr/IUr5ZJ0IXnBNWi0nSakG+xxbdO/HUdpI7FBDwIAAKGirxNyfxGpKCXJK5UeU7lEukE9mpDyO+olDAgBAICIYqyYFmM/4vvh7XGgAVUlEreu4eyY/xtSlV+nauOb0gEAQFSxzh1zBmwq3aVSidw/16cJ5XLOl8Nry1DAV7sDAAC4xDuL/kryxInEm0MDQ2/ag0OeQRppFXOMJuT75tTAk8Js2pkyPgcZAABEFfPzhOxvdC8vGHJ94bx7nEbbhOzyJGbZKtuU10FrmpDn/DUxOKRqQowJAQCASOJ+smJ59qp9aNS9csi+2mknqpIkrzFSXqU5i9494+ZvXS6sEwIAAFHF/ozpyscIqT5usTJso29CuZw8tuS+PLgJ5TxlSP7ExQrOHQMAABHtym/bYKkQAACIZFc2IYaFAABAJLuzCYnVQqybBgAAwXZrEwIAAAhHEwIAAOaiCQEAAHPRhAAAgLloQgAAwFwt2oTS3Z2JxPOB6ewWnyg0kIp6SwAAYJo6NKFsd/vzyfIJ7APJSudISme1qy533TF0yy4DqUT7xe31mdBHBwAAu05dm9BA8vlKQUlfbE8EX04TAgAAO6ueTeizpG8cqL07q7+cJgQAAHZWPdYJDSSVK2+y3e2i8Wgv19wxdMs1aULhjw4AAHabHVsxne7uTCRS/jEX3eVhPksGr4NOfla+Zba7PeiWqnIGAADMsDNNqNY1yKcWY0IAAMA49W9C2e7251U1RXd5VWhCAACgCnVuQp8l1dNPusurRRMCAABVqGcTCl8iXTM0IQAAUIU6NqH0xXblQmbd5bJS0nrQvRj9sWhCAACgCs36bRvp1Q19E1J2KX/aL6Yj3rImq7YBAEDLadImtNi9scoQDwAAqLMmbUIAAAA7gCYEAADMRRMCAADmogkBAABz0YQAAIC5ojeh0kbiAedzAQCA3STOmFB69UH7aoyPOwQAAGhu8WbH4n70MwAAQDOLuU5oYMNiWAgAAOwWcVdMs1oIAADsHnGb0OJqu7XBl3QBAIBdoZomxFIhAACwOzAmBAAAzMU6IQAAYC7OHQMAAObi84QAAIC5+IxpAABgLr53DAAAmIvvogcAAOaiCQEAAHPRhAAAgLloQgAAwFw0IQAAYC6aEAAAMBdNCAAAmIsmBAAAzEUTAgAA5qIJAQAAc9GEAACAuWhCAADAXDQhAABgrsT1sRlCCCGEEDNDEyKEEEKIuaEJEUIIIcTc0IQIIYQQYm5oQoQQQggxNzQhQgghhJgbmhAhhBBCzA1NiBBCCCHmhiZECCGEEHNDEyKEEEKIuaEJEUIIIcTc0IQIIYQQYm5oQoQQQggxNzQhQgghhJgbmhAhhBBCzA1NiBBCCCHmhiZECCGEEHNDEyKEEEKIuaEJEUIIIcTc0IQIIYQQYm4SNyZmG74ThBBCCCENSWIil2/4ThBCCCGENCSJ1bsbDd8JQgghhJCGJGFZ1uLSSsP3gxBCCCFk55OwLMuyrJX1exOz+eHxuqwZSt+6TUgrpuF/n4QQQuoduwnVyiNgt6vtnwwAoLFq0ISqPqJ8CTQHWhEAGGtbTYiWA3PQhwBgV6qyCcUqQA+B1hSrEtX2LxMAsDOqaUKhBch/RHkAtJrQYkQZAoBdIHYTCuhAyupzX28LaA4B71JlMQroQ/X4KwUA1E+8JqSrQZ4CpOs6m0Ar0PUkTyWiDAHALhCjCUXvQP7esyG5BzQr+Y3q70bR+1D9/mIBALW1rSak7EBy9XEOMHfd1oHm43mXeuqRU4n8fYgmBACtK2oTCqhB/g4ktx9xjFlbW1tbW1uNYAWopyhvQvF2leuRU4n8fYgyBAAtLXYT8tcgZy5MdCCnADnVRxyB7rgtA83E8/6Ua5NoRU4lEn3ImS/TlaG6/t0CAGolUhMKrkFyB3JGgEQBckpPqVQqlUpLbkWgOXjemeLt6tQjUYnkUSK5D1GGAKClxW5CwTVI7kBO+xEHm0KhkJcsAs1EfnMWCgWnIYm3sacP6coQTQgAWk54E/IPCHlq0PT09Llz51LA7nXu3LnJyUmnD1GGAGDXiNeE/ANC9+7dO3fuXD6f34F9BRoln8/39vaKKTNncEiUIeUcGU0IAFpF1CakHBASk2KpVGoHdhRorFQqJebLxPoheWQoYFio0XsNAAgR0oR0U2PO8qD19XWaEEyQSqUWFxcLhYKnDDlzZEyQAUAritGElANCa2trNCGYIJVKzc/Py2VoZWVFN0dGEwKAVhGpCfmnxjY2NsTJYqurqzQhmCCVSuVyOVGGisWiOKHMmSPb2NhgggwAWlG8JuQfEFpZWaEJwQSpVGpmZiaXyy0sLOTzeVGG/MNCNCEAaC1Rm5B/akwMCN25c4cmBBOkUqnp6enZ2dm5uTlnjkxeLaSbIGv0jgMAggQ1Id0iITE1JgaElpeXaUIwQSqVmpqaun37tpgjE8NC8moh/wQZS4UAoPnFbkLirLG7d++KAaFSqUQTgglSqdTExMTU1NTMzIwzLOSsFhJNyHMGGU0IAJpfvCbknxpbWlqK1YQyXW1tbW1dGd2VXRlxk66MVRzs6BgsWs6/K4qDHeKS4mBHm4pi+/ZNNY/ckoqDHW0dg8Xyjz72de7bihcg9OnaGf6XtnKFs/eBb5kdlEqlxsbGJicnxbCQWC2knCCjCQFACwlvQsrl0uvr62JqrFgshjYhXV/xHo0zXW1tbR2Dg+LwWD5K2pcWvRt0mpD7Ou3BVeyF+8Y7YfKVvUe+cvTzQqzb733vRugNy50m9FeqPP8x6oTnRZPv6S5T/o4asEeqHqaoZVL5aZ4Gm0qlbt26NTExIa8WcibIPEuFWDQNAK0idhMSH6goFgmVSqUoTagsvItkujq6MqIJDWa6OioHRYddlOx/dHUFjAlFKGD1Ob4Whk49tvfIKyPiX3VrQpYlRtEGi0FNqKoRFX9hKW9AWWUqL2nkuul9cbw7KLfiHXzpgqRSqdHR0fHxcXmCTD6DTHzEIk0IAFpLpCYkvk3Jv1y6VCoVCoWoTch9TBaHQvl4pmguzgCRfXd5Lsg7JiRdL22vfMlOjgjd+PWRbTShKuhHWirPb3GwI3J7sLdXuXmmS/xcfiDnmvJrFu9pFpvpGCzaA3j+94JlFQc7ykXXs9uqW4d49Mh68NBa23x05+7D1Y0vtx58WUU7SaVSIyMjngkysVTIv2ja8wVkcR8LALBjojYh/4ljYrl05CbkPUZqjmfuY600NSL3mtB1Qm0dg0X7HrphI824wsh7j+09IlKuMnazEal0mpH3pH8uXzwq7mL/YN9473s3nCZU3vLTQ8uKzVYGgeQxoeWLR498Ze+piyOfP733yFd+Pal6ptwlRNMQ7Ct1z4anuujm3XwNqXKha71SQBNyV6fKVGZ5BweL0quqGBMU68fcNwwvRcW1hyMLWzdzG9em1oZn7qan1+eXt8Lu5JVKpbLZrDNBJjehO3fuBJ8+FvexAAA7ptKE1tbWPvjgg3feeSel8tZbb7311ls9PT09PT1nzpw5c+bM2bNnz549+/bbb0dqQr5JGkUTsg9x/hmRcq/xHPTtA7u9jYAxofJSo7DRhKXPn957xN2EXM3G1VriNaFTT3tLj3fL5U0pmtDTR4885mtCln9ITCoYrmfCVVbcl2pKi6t/BHct16UhTSjCMiFpBNBpQmJ75f4r/dbhU3+PHj3Krz4Yyq5dnlh+Y3D6pb5br74//nGm8M6lhduFe7E6SiqVOn/+fG9vb29v77lz595999133nnn7bffFn8IZ86c6SkTfyzKvyMAQLOxm9Da2tq7776bTqdXVlbE2I9YHO1806r4bo21tTXnlLFCobC4uDg3N5cKb0LSf/GrD4b2NfZEiTxyNNjV1dbWMZjxDQM5/whrQpX+E9aERLmRC4e4ZO+pi0vi35OvOCVJ3YQsSzk7Zm9B/lkmtx9vE5KHkVRPqzw6IveD8nPhPOFxmpDrjuVnWzkkFKsJuXc66GJXE3Lvh2YDalsPHl2bXv98bPno2czVydLS2lY2t/KTM8NDN/K/vbZ4d/NBpK1YlmVZqVTqxo0bmUxmdHTUfzq9cxLZ2tqa8x314rx6sYwaANCc7Cb0wQcfpNNp8XFBcu8R1WdlZWVlZUVMhxWLxWKxuLi4OD8/n8vlbt++HdqEnPLiPa076JQkd9vp6OiQbuyaHVPM+EhHZbtDKfmPpnbRcSqOWPssdyPRcp4eWo7XhMpzajd+XWlC8uzYY/ompGpO8vPgdD3vGixncMUeZovbhNwvS7mC+KpQvNmx4IXsmiakHRMKt7R2//OxO50Xxr732hdjc6v9V3Krd7de6c+8+Hb6/atzs8W7kbZiWZZlpVKp69evO2VILJ12PmhRrJ52vo9M/MmIYiS6EQCgOdlN6MyZM6urq5ubm+vr6071WV5eXl5eLpVKpVJpaWmpWCzm8/nFxcWFhYW5ubnZ2dnbt29PTU2FNqFMV1vXoPfwpVklW75IOky7xjvct8t0tdmbdpUAaROKc7zDlpWUF/Q4i3s8i3hcY0JSfYnXhEbekwZ7gsaEIjQh3ayT+yN5ojehTJf3yZbnrNq8nVTaTH3GhLbRhBaWNz+8UfjBG1eeOvHxgf/78fj8ypmh8UOvfvw/O//l/KXp8fnVSFuxLMuyUqnUtWvXRBkSC4acMiROql9YWFhcXBSfPb20tCT+cMQf0R0AQLNKOP8vf//+/Xv37onJL08HEjWoUCjk8/mFhQUxGjQ7Ozs9PT05ORlhdkxx/NOtE2prK5cb35nbvjGhTJdz5pG/CYUvmPaVImm5dHm8pzJK5F3Q415U9JivCXlXTFv2VaLZiNGmGo0J6a6rvglpn6lIZ9Err/K9yoEbEk2oq6ura3srpudLG/98feHv37n5V//04V++9MFTP/9gX/Liky/+v+e7Pjn70fjE/Ir+rl6pVOrq1aueYaHJyUnx8UJiZEh83GKhUBBlyNOHAABNqNKEtra27t69K4aCPB3IqUFiQGh+fn52dnZmZmZqampiYqJmTch9mJRXApdPtHafO2YPF/gPrZoPXYy2Tsh3Mpd7EbQ0U+a0GWehtD0OVC5JAU1I3uzTQ59XMyZUKSWhJ0+pSk/Qk+FfnOO7Y5TrlE0oGteJ9trPzgxfMb2+cf/sh5OD1+YOvfrJd3428MnNuX0//c1TP7t4/tOJl3vTd9ZjnEEmmlA6nR4eHs5ms6Ojo2NjY86CodnZWdGExLCQKEOePgQAaEKuJrRe/uRocZ2/CTljQtU2oaBPyrMPv65zoeRjqd1/nMmyjP0JOeoxITFepNiJZvi44lpwThALOiFLWk2u+mKObX2+kvv1inOXQM5oT0DHiv4SPnr06PrE0jOnPv3NF7d/+IuPn/qH/h+8+i+9n4y1/937lzILcc8du3btWjqdFrNj/iYkJsjEnwlNCABahbcJiakxcZ2uCc3NzeVyuZmZmRizY9iFgkaHmsrlW4svn0t3D4688dvML9/PHH/ri09uzMXdiLxOKJPJiHVCYnZsZmYml8vRhACgFUVtQmK5tNyE4q0Twi5V1Zea7bRHjx7dWdscmSldnyhkppeW1zar+4xpMTV28+ZNMSbkWSckNyHnr4YmBABNLlITck4c86+YjnLuGLALiCYkBoRGRkbEh01PTU35V0w7p4/RhACg+cVrQouLi+KThObm5mZmZiKeRQ/sAs7nCYkBIfksevERi+JTheQT6WlCAND8wpuQfBa93ITEounp6WmaEEyQSqWcqTFRg8QXkDnLpZ0mJJ9FTxMCgCYXrwn5T6SnCcEQzrdtOFNjznJp5Sn0NCEAaAmxm5Dn9LEo37YB7AKpVCqTyYgBIef8eTE1pjxxjCYEAC0hqAmVNCfSeybIent78/l8Y49SQF3l8/ne3l7x0dLOgJD8SUJiaoxT6AGg5URtQv5F084ZZNlstre3N8oX3wMtqre39+bNmyMjI+Lkef9ZYyyXBoAWFa8JeSbI5HXTU1NT4+PjY2Njo6OjIyMjmUzm5s2bN27cGB4evn79ejqdTqfT165du3r16tWrV69cuXLlypXLKleAegp414k3p/gg6XQ6ff369eHh4Rs3bty8eVMsDxKfKy1OGZPXSiunxmhCANASIjUh/6Jpz7CQOJ1+cnLSKUOjo6PZbNbpQ/5K5BxvrgGN439DOgXI6UDitHmnBol5MfEV9P4BIRYJAUBridqEPMNCzhlkzrDQ7du3xUdOj4+Pj4+P37p1SwwOZbNZuRINDw+Lw8ww0EzkN6dTgLLZrBgKEqfNOx8qLRZKOyuE/GeNyWWogX/eAIBQIU2opJkgk4eF5DI0NTUlvpZVDA7dunVLrkTi6JKR3AQaTX5DOu9SpwCJM8WctUHO+WJODVIOCDE1BgCtImoTWpK+gMxzEpkzRyamycSaocnJyYmJCVGJnD7kGJFkgcaR34ryW1S8aUUBcs4UE6NB4q0uz4t5ThljQAgAWki8JuQfFhJzZM7IkLyA2ulD4nnLomUAAAoOSURBVHAiJhfGxsacsSKgqYg3p3ijOu9b0YHkJdLyaJCYF2NqDABaV3gTKumHhfxlyBkcEn1IkFuRY1xjAqinKG88uf0ITgcSH6Koq0EMCAFAy4ndhDwftCiXobkyuQ85i6mdSuRpSEDDed6T4mexHsjTgQRdDWJACABaTqQmVAorQ56zyfzjQ04rctwGmonn/em8b+VxIM+ZYtQgANgFYjchZRlyFlB7JsucgaJcLucUo2AzQD1FeROKt6sz/KOcDvN/sQYfIwQArShqEyoFliFlH3IqkdOHPP8Emoru7SrezP4ORA0CgF2g+iYklyFPH3LmDhwLknmgWclvVPkN7LyrPR1I/iugCQFAK4rRhEruMiT/d7CyD8llyPNPoJkp373KDuQfDaIGAUBrideESqoy5O9DTiWSW5FfAw91gCzgXeq8k+W3t//NTw0CgBYVuwmVfGVI7kD+SuQpRkCr8L+Nle92ahAAtLRqmlBJVYYCDhL+IwrQEkLf29QgAGh1VTYhQXdIULafgBsDzSbWG7iuf6IAgLraVhMSaniwARqi6vdwnf4sAQA7pgZNSFb1EQVoFTX88wMANFyNm5BSo49cQJVq+4cAAGhCtWlC09NTp0+/lnzxyAtHDhFCCCGEvHDkUPLFI6ffeHViYrweDaZWatCEpqenjh39YcOfbkIIIYQ0YT768Lc1n26qoRo0odOnX3vhyKFf/vKVpaWCBQAAYFmWZRWLhWtXPtvaXLu7vlKnHrN9NWhCP/nxcy8cObS8XGrs0w0AAJrNw4cPtzbXNjfWwvvEpZfbXr4Udou2sNvEVoMmJMa+GvtEAwCA5rS1uba1GaEJrc8NPtt2qHfMd8VY76E24VTGsrbWpQva2pT3iIMmBAAA6kjbhC693Bbm5UulUmnyN891DBYty7K21ksl1wXFwY7nfjNJEwIAAM1K24Qun2rrygTcMdPVduqyKD6ubjTW90zb61dX7E5EEwIAAE1M24TWt6ytdddMl3vOa31LDAJVhoAsy0q/0tb2zPtFe3Ro5errlbEjmhAAAGg6weuEVjYeum+e6Wpra+sa3qicbeYa+FnfsqyHlSvXt8RjrMfsPxU0IQAAUEdRV0yX7LXRzw4W3c3GPTvW6xtE2t7ZZDQhAABQR5ompJkWU8ySuWbHtjY2hrsq64uKgx0d/bdpQkBE+f6DiSAH+/ON3kUA2GU0Tcg3LWYVBzsqjcf2cGPFtyx6fStzqu3lS6JMvTYszZU1WxPK9x/c4QPLzj+iY/hkInFy2P1TMHtndfscdTPV7WdNnqnhk/V5tss7J29fajCux1Re7t8x3a4On1Q/yRELk9hsA992ANACIs+O6U4EE5eXz7kXa6mL/T9ok5dOV68lm5B2wxEesV47FbcJ5fsPils1pglZtegx9WlCzjNT2X6+/6Cr5pQfVnf59ptQRM5m61UKAWAX2GYTKjegV9Jicw83VsRFHR0d214kVGrR2bHttJkmaUKuY3jIBmtK2mz4PoRvq/ZPpbRX+f6DqmdA98xULvffUbOp7Tahyma3/WQCwK4V3oScj1h87v2cb6ZrfUvMmm2tl8qLi0QpevjwoSXOqm/as+grpUP8Z74z4yAdMoZP2tMNleORc5Fzmbi7uPzkyZPSJIX/eBf4iMOK+8rzILqDpWfvnH9Ju3rS04T8v4VnR6XDfeUJUW7QsyfeLct7JG+sMrai26zq6O2pGe5n1PMbySMiEZ4i/yuseGoiNIqA8Z3YZWSbTUhCFQIAjfAmZJ8K7zo9XrKy8bB8hVhcJM+Iifs26Vn03qOoVEcqF5ePHsP93ou8d68csSLMjmke0XvffP9Bd41QHBd1h3lv65CbiastKPZVOgC791m1QdeeKLZcaQD5/oMHDx6s/NYH+/OBm1V1B1+PsX+rfrmteWavIjxFzo+KF13zzKjpXvzIg32uOqxZ/1MNJsgAQC2gCS0tLVXdYGpl55qQu344S2Tcxz3XIVV58LR8m4vziIohGPnxlfMumsO857ba2THpsZWXOTuk3aDuImcrUuc5OVyesClfGLRZ5TiGeyxJfb1ncUyUp6h8N03fDHi2vE+BblVVNT1EX7wCC1PIOB8AQKJrQktLS0tLS8VisdBQOzk7Jl8uD2xU/lvcf8aO04TkY0/EJqR8RO8Iie9EpJD5ovK/vDcNbELebaqakH6DuotcTfHksGUNn7TPuBInhylbZHgT8jcsy/fKRGpCmlfT+6JrnxmfWtcgq5azYzQhANBQNqGlpaXx8fG+vr5UozW6CVUusY/lUQ6PtWpCOzImpNvm9seE3LNQJ4dFERKFaFg+AUu7Wc2Ejv10Sdeq1yJFGBMK6AbqwSFtNalDDQp6uKo2RRMCAAV/E1paWioUCufPn8/nG///mw1tQsMn3WuiLc9xrXy9rzrpzh6KOgrlXs+rWm7s2ah7eXWlYshNwbVOyDWW4t9V5Ypp3QZdv7Z6y64FQuIfypVK7s1qRzHy/QcTJ0+edD9P8uprTxOK8hSVX03Fi655Zjy/ueoF110eGSumAaDuPE1ITIrl8/lUKtXoXbOsBjch1flIqsv8h8zy/IrnKBZpFMpzX2k9iO5IVtmlg/39ntGR8rY8Y0L90lWaTfoWhms2WNn5gC0HLv1W72fgTJSrIro30e8fE4ryFAVdpH5m3Dvj5tRm1eWuvQ4uOjVrQuEPBQCm8jehYrG4uLhoQBNCgOhHzsrBetsjIN7tNuUgRg07ha/n+Jcu+R3szweullaWrmZ9MgGgCfhnxwqFwsLCAk3IdBFP+5aO5jVsQpHPOW+EWu1cDRcBBWrqJxMAGo4mhFqp7ZgQAAA7QdmE5ufnaUIAAGD3q64JPf7447rLdVdVhyYEAADqqOZjQjQhAADQMmhCAADAXHGb0ONlustpQgAAoGXUZJ2Q/E+aEAAAaBk0IQAAYC6aEAAAMBdNCAAAmKvqFdOexdG6y7eJJgQAAOqIz5gGAADmogkBAABz0YQAAIC5aEIAAMBcNCEAAGAumhAAADDXDjSh7ZxXTxMCAAB1tDNjQjQhAADQjGhCAADAXLGakPKDpJ2fnf/1XMXsGAAAaFJVfNuG/2dPEwq4ZVw0IQAAUEc0IQAAYC6aEAAAMFdNmpDlq0EBP8dCEwIAAHVURRNSLoL2NyHPjasrQzQhAABQR9sZE9oBNCEAAFBH1Z1Fv2O7RxMCAAB1xPeOAQAAc9GEAACAuWhCAADAXDQhAABgLpoQAAAwF00IAACYiyYEAADMRRMCAADmogkBAABz0YQAAIC5aEIAAMBcNCEAAGAumhAAADAXTQgAAJiLJgQAAMxFEwIAAOaiCQEAAHPRhAAAgLloQgAAwFw0IQAAYC6aEAAAMBdNCAAAmIsmBAAAzEUTAgAA5qIJAQAAc9GEAACAuWhCAADAXDQhAABgriZvQv8fWE2irI4KcA8AAAAASUVORK5CYII=)
#1054 - Unknown column 'id' in 'field list'
看似字段id不存在于表中,于是找了好一会原因,结果是字段id前面多了一个空格,去掉空格就可以正常运行了。
当时用mysql-gui-tools-5.0-r17-win32.msi见的表结构。很悲剧!~
作者:酷客多小程序
出处: http://www.cnblogs.com/ywqu
如果你认为此文章有用,请点击底端的【推荐】让其他人也了解此文章,
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。