# -*- coding:utf-8 -*-
import mysql.connector
#打开数据库连接
conn = mysql.connector.Connect(host='XXX',
user='XXX',
db='XXX',
passwd='XXX',
port='XXX',
charset='utf8')
#使用cursor()方法获取操作游标
cursor = conn.cursor()
print('-----------------------------------------------------------------------------------------------------------------------------------------------')
#创建表
# 如果数据表已经存在使用 execute() 方法删除表
cursor.execute('DROP TABLE IF EXISTS Wangyi_Python')
sql0 = """CREATE TABLE Wangyi_Python (
ID BIGINT (20),
NAME VARCHAR (200),
FILE_NAME VARCHAR (200),
FILE_PATH VARCHAR (400),
FILE_SIZE BIGINT (20),
FILE_TYPE VARCHAR (1020),
FILE_URL VARCHAR (400),
REAL_PATH VARCHAR (2000),
DESCRIPTION VARCHA
Python连接MySql(.py文件直接操作MySql)
最新推荐文章于 2024-04-14 17:30:00 发布