INSERT INTO report(NAME,keyword,refile,content,DATE,STATUS) VALUES ('%s','%s','%s','%s','%s',0)%("name", "key", "refile", "content",str(datetime.now()))
report errors
ERROR CODE: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key,refile,content,date,status) VALUES ('%s','%s','%s','%s','%s',0)%("name", "ke' at line 1
The keyword of MySQL is used. After modification
sql="INSERT INTO report(`name`,`keyword`,`refile`,`content`,`date`,`status`) VALUES ('%s','%s','%s','%s','%s',0)"%(name,key, refile, content,str(datetime.now()))
Read More:
- [Solved] Odrive gui Error: Do not use the development server in a productioun and supported version of the Socket
- [Solved] ValueError: check_hostname requires server_hostname
- Django uses Mysql to report an error loading MySQL DB module: no module named ‘mysqldb’
- [Solved] Error starting proxy server: oserror (10013), “an attempt was made to access the socket in a way that the access permission is not allowed.”, None, 10013, None)
- Robotframework post error“:“Internal Server Error“,“message“:“syntax error, expect
- [Solved] Failed to install PIP for MacOS, prompt: syntax error: invalid syntax
- Python syntax error except exception, e: ^ syntax error: invalid syntax
- Python errors: valueerror: if using all scalar values, you must pass an index (four solutions)
- [Solved] Python sqlite3.OperationalError: near “?“: syntax error
- [Solved] NPM install Error: check python checking for Python executable python2 in the PATH
- You can run the Ansible Playbook in Python by hand
- [Solved] PIP Install tensorflow error: syntax error: invalid syntax
- MYSQL-python Install EnvironmentError: mysql_config not found
- Zlib.error: error – 3 while decompressing: incorrect header check in Python
- Python Use sqlalchemy Error: pymssql.ProgrammingError: (102, b“Incorrect syntax near ‘(‘.DB-Lib error
- [Solved] ProxyError: Conda cannot proceed due to an error in your proxy configuration.
- An error is reported in the requirements code of the generated project
- MySQLdb._exceptions.ProgrammingError appears when scrapy crawls Weibo hot comments
- [Solved] Python operate Kafka error: SyntaxError: invalid syntax