结果如下：
实在有必要执行其它操作，倒建议直接在SQL命令里写，自带SQL语句的补全功能。
python-mysql：设置数据类型初探
标签：into arch pymysql 自带 open arm das cursor zhang
python-mysql：设置数据类型初探
import pymysql
2 import pandas as pd
3
4 dbcon = pymysql.connect(host=‘localhost‘,
5 port=3306,
6 user=‘root‘,
7 passwd=‘1234‘,
8 db=‘model_database‘
9 )
10 cursor = dbcon.cursor()
11 data = pd.read_csv(r‘C:\Users\zhangjingyu\PycharmProjects\MyModels\knnCluster\data.csv‘)
12
13 sql1 = ‘DROP TABLE IF EXISTS cluster_data‘
14 cursor.execute(sql1)
15 sql2 = ‘CREATE TABLE cluster_data(x FLOAT (8,6),y VARCHAR (20))‘
16 cursor.execute(sql2)
17
18 data_mysql = []
19
20 data_mysql = [(float(data.iloc[i, 0]), float(data.iloc[i, 1])) for i in range(data.shape[0])]
21 cursor.executemany(‘INSERT INTO cluster_data VALUES(%s,%s)‘, data_mysql)
22 try:
23 dbcon.commit()
24 print(‘success written!‘)
25 except:
26 dbcon.rollback()
27 print(‘failed written!‘)
28 finally:
29 cursor.close()
30 dbcon.close()
View Code