尝试用python写sql进去
- 第一轮
insert_sql2 = 'insert into hotword_12345 (hotword,num) values ({},{})'
for i in range (resultDf.shape[0]):
cursor.execute(insert_sql2.format(str(resultDf.iloc[i, 0]),
int(resultDf.iloc[i, 1])))
一直失败,以为是utf8的问题,
alter table
tablename
convert to charset utf8;
- 第二轮
结果还是报错,结果突然想到是不是中文识别不出,改成
insert_sql2 = 'insert into hotword_12345 (hotword,num) values ("{}",{})'
for i in range (resultDf.shape[0]):
cursor.execute(insert_sql2.format(str(resultDf.iloc[i, 0]),
int(resultDf.iloc[i, 1])))
结果还是写不进去,但是我在navicat里面,尝试这条sql语句,是可以写入的
insert into hotword_12345 (hotword,num) values (“人身安全”,1)
- 第三轮
然后还是发现还是写不进去,这个时候是不是不是string格式的问题
insert_sql2 = 'insert into hotword_12345 (hotword,num) values ("{}",{})'
for i in range (resultDf.shape[0]):
cursor.execute(str(insert_sql2.format(str(resultDf.iloc[i, 0]),
int(resultDf.iloc[i, 1]))))
可以了