sql - Python pymysql INSERT INTO inserting empty values -

sql - Python pymysql INSERT INTO inserting empty values -

i'm trying insert values in table, , although rows beingness created, values aren't beingness recorded. here code:

for in range(2,6): team in ul[i]: name = team.string #string html element print(name) #this works fine, , prints desired name cur.execute("insert teams (name) values(name)") conn.commit()

now if set values("test string") instead, works, 30 rows added (what want), , name: "test string".

yet when set in name variable, rows added well, column values empty. column i'm putting strings in varchar. there don't know how sql statement interpreted in case of python string variables?

it appears sql statement simple string , name variable isn't beingness inserted it.

perhaps this:

sql = """insert teams (name) values({0})""".format(json.dumps(name)) cur.execute(sql)

i utilize json.dumps(myvar) escape special characters, e.g. quotes, etc... might break sql insert statement.

sometimes it's helpful print out sql statement , seek run in client (e.g. mysql workbench), in order see changes, if any, necessary generate syntactically right statements.

python sql pymysql