python 数据库插入操作报错，求解

Question

# -*- coding:utf-8 -*-
import re
from pymysql import *
import datetime

db = connect(host='XX.XX.XX.XX',
                     port=3306,
                     user='root',
                     password='XXXXX',
                     database='python001',
                     charset='utf8')


cursor3 = db.cursor()

current_time = datetime.datetime.now()

user_id = “A100”

query_insert_order = "INSERT INTO goods_orders(`order_create_time`, `customer_id`) VALUES (%s, %s);"

cursor3.execute(query_insert_order, [current_time, user_id])
print("------------------1------------")
"""每次新增，修改，删除后都需要提交"""
print("------------------2------------")
db.commit()
print("------------------3------------")


执行后会打印 ------------------1------------  ，再这之后报错：一直无头绪，求解

File "E:\learnPython\08_数据库\python和MySQL交互\order_test.py", line 62, in create_order
    cursor3.execute(query_insert_order, [current_time, user_id])
  File "E:\python\Lib\site-packages\pymysql\cursors.py", line 153, in execute
    result = self._query(query)

Answer 1

我试了下，你这个代码没有什么问题。就是上面代码中 user_id 赋值的时候用的是中文的双引号，这个会有问题