Problem code:
MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to you
r MySQL server version for the right syntax to use near 'read,mention) values ('家长偏心对孩子的影响有多大',15424499,5655)'
at line 1")First analyze the error message: MySQLdb._exceptions.ProgrammingError is because the connecting party did not respond correctly after a period of time or the connected host did not respond, and the connection attempt failed.
So I first checked the sql statement, and when I ran my sql statement in Navicat, I found:
Obviously, the read inside is the keyword index, and an error is reported.
Solution: change the key value in items to something else.
Read More:
- [Solved] django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.Did you install mysqlclie
- [Solved] Django Error: django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
- Python Use sqlalchemy Error: pymssql.ProgrammingError: (102, b“Incorrect syntax near ‘(‘.DB-Lib error
- command ‘gcc’ failed with exit status 1 error while installing scrapy
- Django uses Mysql to report an error loading MySQL DB module: no module named ‘mysqldb’
- Python Error aiohttp.client_exceptions.ClientConnectorCertificateError, Cannot connect to host:443
- urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host=‘localhost‘, port=8097): Max retries excee
- [Solved] Django.core.exceptions.ImproperlyConfigured: SQLite 3.9.0 or later is required (found 3.7.17).
- [Solved] Selenium.common.exceptions.WebDriverException: Message: newSession
- [Solved] PyTorch Error: TypeError: exceptions must derive from BaseException
- Python asynchronous co process crawler error: [aiohttp. Client]_ Exceptions: serverdisconnected error: Server Disconnected]
- [Solved] selenium.common.exceptions.WebDriverException: Message: unknown error: DevToolsActivePort file doesn
- [Solved] socketio.exceptions.ConnectionError: OPEN packet not returned by server
- [Solved] selenium.common.exceptions.JavascriptException: Message: javascript error: windows is not defined
- [Solved] celery Startup Error: kombu.exceptions.VersionMismatch: Redis transport requires redis-py versions 3.2.0 or later. You have 2.10.6
- Python opens the table and appears pandas.errors.ParserError: Error tokenizing data. C error:
- [Solved] Python Project Error: django.core.exceptions.ImproperlyConfigured: WSGI application ‘WebTool.wsgi.application
- Module not found error: no module named ‘filefolder’ appears when learning engineering knowledge
- [Solved] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- [Solved] USB: usb_device_handle_win.cc:1049 Failed to read descriptor from node connection…