qq_42672853的博客

import pymysql import time conn = pymysql.connect( host='localhost', user='root',password='123456',db='db',charset='utf8') cur = conn.cursor() def run(): # 批量插入方法 s = time.time() data_list...

#1、加载所需要的包 import pymysql import time time1 = time.time() #2、查询的数据表 db2 = pymysql.connect('112.128.0.001', 'root', '123456', 'db') cursor2 = db2.cursor() len2 = cursor2.execute('SELECT * from xxxx') ...

MySQL基础(一) #1、如果存在某个表就删除 drop table if EXISTS model.`data`; #2、创建一个表，写出字段、字段的数据类型和表字符集规则 create table model.`data` (InvoiceNo varchar(20), StockCode varchar(20), Description varchar(50), Quantity in...