python - MySQLInterfaceError：无法转换 Python 类型列表

Question

    @app.route('/upload', methods=["GET", "POST"])
def upload():
    if request.method == 'POST':

        file = request.files['upFile']
        file.save(os.path.join(app.config['UPLOAD_FOLDER'], file.filename))

        dir = app.config['UPLOAD_FOLDER']+ file.filename

        cmd  = "INSERT INTO posts (title, author, file, date, subject, field ) VALUES (%s, %s, %s, %s, %s, %s)"
        post = (request.form["title"], session['user_name'], dir, x, request.form["subject"], request.form.getlist("field[]"))
        crsr.execute(cmd, post)
        mydb.commit()

        return redirect(url_for('upload'))
    else:
        return render_template('upload.htm')

它返回： MySQLInterfaceError: Python 类型列表无法转换

标签： pythonmysqlpython-3.xflaskmysql-python

Answer 1

一种解决方案是像这样将列表转换为字符串。

','.join(list)