一、mysql-connector-python
1、安装
pip 安装 mysql-connector-python
2、代码
# 导入API
import mysql.connector
# 创建数据库
def create_db_sampledb():
# config为数据库的配置信息
config_root = {
"host":"localhost",
"user":"root",
"password":"1234"
} # 创建root用户的连接配置
sql = "Create Database IF Not Exists sampledb CHARSET=utf8 COLLATE=utf8_bin"
try:
conn = mysql.connector.connect(**config_root) #创建连接
cursor = conn.cursor() #设置游标
cursor.execute(sql) #执行sql语言
conn.commit() # 上传
finally:
conn.close() # 关闭连接
# 设置配置信息,模仿用户配置的信息
mysql_config_sampledb = {
"host":"127.0.0.1",
"database":"sampledb",
"user":"root",
"password":"1234"
}
# 创建表
def create_table_sampletb():
# 如果该表不存在,创建该表
sql = (
"Create Table If Not Exists sampletb("
"DateTime DateTime Primary key,"
"open float(32),"
"high float(32),"
"low float(32),"
"close float(32))"
)
try:
conn = mysql.connector.connect(**mysql_config_sampledb)
cursor = conn.cursor()
cursor.ex