The mysql insert statement in flask reported an error: 1241, 'Operand should contain 1 column (s)

The code in

view.py is as follows:

.
c_location = request.form.getlist ("centering location")

    connection = db.engine.connect()
    mysql = text(
        "INSERT INTO livingexpenses_coal (c_location) values (:m);"
    )
    result = connection.execute(mysql,m=c_location)

now an error has been reported:
sqlalchemy.exc.OperationalError: (_ mysql_exceptions.OperationalError) (1241, "Operand should contain 1 column (s)") [SQL: "INSERT INTO livingexpenses_coal (c_location) values (% s);"] [parameters: (["1asdfeld," 5"])] (Background on this error at: http://sqlalche.me/e/e3q8)

that is, c_location is now an array and cannot input values, but the normal sql statement can use:
INSERT INTO table name (column name, column name) VALUES (column value, column value), (column value); to insert multiple data at one time. Please tell me how to modify my code. Thank you very much.

Flask-sqlalchemy flask python

Feb.25,2022

c_location since it is an array, you should take a single element as the SQL parameter, such as

    connection = db.engine.connect()
    mysql = text(
        "INSERT INTO livingexpenses_coal (c_location) values (:m);"
    )
    result = connection.execute(mysql,m=c_location[0])

or format the entire array (if possible), such as

    connection = db.engine.connect()
    mysql = text(
        "INSERT INTO livingexpenses_coal (c_location) values (:m);"
    )
    result = connection.execute(mysql,m=';'.join(c_location))

Previous: About create-react-app webapck profile Modification

Next: Js array processing, object adding properties, array processing into objects

Just learn flask, to add data to the database does not seem to be added, the front end is an empty array, how should I find out the reason?
from flask import Flask, session from flask import render_template from flask_script import Manager from flask import url_for from flask import request, jsonify, json from flask_cors import CORS from flask_sqlalchemy import SQLAlchemy import os from fl...

Flask-sqlalchemy flask python

Apr.01,2021
How can flask do multi-table queries without foreign keys?
< H1 > user table < H1 > class User (db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(40), unique=True) password = db.Column(db.String(128)) < H1 > order form < H1 > class User (db.Model): id = db.Column(...

Flask-sqlalchemy flask python

May.24,2022