Mysql Error 1064，python操作插入mysql数据库，报错但是插入成功

68 阅读 0 评论 45 点赞

我是靠谱客的博主眼睛大冰淇淋，这篇文章主要介绍Mysql Error 1064，python操作插入mysql数据库，报错但是插入成功，现在分享给大家，希望可以做个参考。

复制代码

def Creatsafe(ware,goods,db):
    time = data.get_time()
    Goods_num = len(goods)
    for a in range(len(ware)):
        houseId = ware[a][0]
        c = sqlNum  # 每一万条执行一次，否则速度会慢
        minnum = math.floor(Goods_num / c)
        for k in range(minnum + 1):
            if k < minnum:
                num = c
            else:
                num = Goods_num - k * c
            txt=""
            for r in range(k*c, k*c + num):
                safetyStockId = data.id_str(2)
                goodsId = goods[r][0]
                shipperId = goods[r][1]
                txt = txt+f"('{safetyStockId}', '{houseId}', '{shipperId}','{goodsId}', '1', '10.000000'," 
                          f"'{creatID}', '{creatName}', '{time}', NULL, NULL, NULL),"
            txt=txt[:-1]
            sql=f"INSERT INTO base_safetystock (`safetyStockId`, `houseId`, `shipperId`, `goodsId`, " 
                f"`goodsForm`, `safetyStockNum`, `createorId`, `createName`, `createTime`, `updaterId`, `updateName`, `updateTime`)VALUES"+txt
            db.execute_Insert(sql)
        print(f"第{a+1}/{len(ware)}个仓库 安全库存 新建完成")
    return 0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
def Creatsafe(ware,goods,db):
    time = data.get_time()
    Goods_num = len(goods)
    for a in range(len(ware)):
        houseId = ware[a][0]
        c = sqlNum  # 每一万条执行一次，否则速度会慢
        minnum = math.floor(Goods_num / c)
        for k in range(minnum + 1):
            if k < minnum:
                num = c
            else:
                num = Goods_num - k * c
            txt=""
            for r in range(k*c, k*c + num):
                safetyStockId = data.id_str(2)
                goodsId = goods[r][0]
                shipperId = goods[r][1]
                txt = txt+f"('{safetyStockId}', '{houseId}', '{shipperId}','{goodsId}', '1', '10.000000'," 
                          f"'{creatID}', '{creatName}', '{time}', NULL, NULL, NULL),"
            txt=txt[:-1]
            sql=f"INSERT INTO base_safetystock (`safetyStockId`, `houseId`, `shipperId`, `goodsId`, " 
                f"`goodsForm`, `safetyStockNum`, `createorId`, `createName`, `createTime`, `updaterId`, `updateName`, `updateTime`)VALUES"+txt
            db.execute_Insert(sql)
        print(f"第{a+1}/{len(ware)}个仓库 安全库存 新建完成")
    return 0

python执行的时候会报错：

数据库execute_Insert发生错误|Mysql Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
但是实际又是执行成功了，就很神奇，是我的sql语句写的有问题么？语法上真的没有看出有啥错误。