#coding:utf-8
SQL_STR_FORMAT = '''insert into traffic(district,yi,er,san,si,time) values( '{0}','{1}','{2}','{3}','{4}',{5});'''
datapath = r'C:\Users\ALI\PycharmProjects\data2sql\data\traffic_data'
import MySQLdb
import os
datafiles = os.listdir(datapath)
fo = open('o.sql','w')
db = MySQLdb.connect(
host = '172.21.7.24',
port = 3306,
user = 'root',
passwd = 'ali',
db = 'didi
Python 连接数据库&切割字符串
最新推荐文章于 2022-10-15 11:25:44 发布