pymql插入语句出错 请问怎么修改？

Question

向MySQL插入，提示：

Traceback (most recent call last):
File "E:/Python37/Project/test3.py", line 45, in
levelOut) + ")"

TypeError: can only concatenate str (not "datetime.datetime") to str

代码：

river1=
[{'stationNo': '033', 'recTime': '201911241530', 'levelOut': 9.96}, 
{'stationNo': '029', 'recTime': '201911241520', 'levelOut': 1.16}]

-

for river2 in river1:
    stationNo = river2.get('stationNo')
    recTimes = river2.get('recTime')

    recTime = parse(recTimes)
    print(recTime)
    levelOut = river2.get('levelOut')

    print(stationNo, recTime, levelOut)

    insert_taipei_river = "INSERT INTO taipei_river VALUES( " + stationNo + ", '" + recTime + "', " + str( levelOut) + ")"

    cursor.execute(insert_taipei_river)
    connection.commit()

数据表结构

Answer 1

试试，你的recTime格式不对