Python3—-对远程windows server 2003服务器的mysql数据库中指定库创建数据表
1、参考数据库的数据表的格式
2、Python代码:
# -*- coding: utf-8 -*-
"""
Created on Fri Jun 22 20:00:02 2018
@author: Administrator
"""
import os
import sqlite3
import operator
import pymysql
def connect_mysql():
db_config = {
'host':'192.168.16.115',#远程windows server 2003数据库地址
'port':3306,
'user':'root',
'password':'root',
'db':'chrome_history',#需要连接的数据库test
'charset':'utf8mb4'#编码
}
try:
cms = pymysql.connect(**db_config)
cur = cms.cursor()#获取一个游标
#对chrome_history库创建表urls数据
cur.execute("CREATE TABLE urls (id VARCHAR(10), url VARCHAR(500), title VARCHAR(150), visit_count VARCHAR(20), type VARCHAR(2), last_visit_time VARCHAR(20), hidden VARCHAR(2));")
cur.execute('flush privileges;')#必须实时更新数据
cur.execute('select * from urls;')#查询urls数据表中所有数据
data = cur.fetchall()
for d in data:#打印查询的member数据表的数据
print('id: '+str(d[0])+'\t'+'url: '+str(d[1])+'\t'+'title: '+str(d[2])+'\t'+'visit_count: '+str(d[3])+'\t'+'type: '+str(d[4])+'\t'+'last_visit_time: '+str(d[5])+'\t'+'hidden: '+str(d[6]))
cur.close()
except Exception as e:
print(e)
db = connect_mysql()
3、脚本运行后: