安装模块
pip3 install pymysql
python脚本
import pymysql
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
passwd='123',
db='host_info',
charset='utf8mb4'
)
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
sql = """
create table base_info
(id int auto_increment primary key,
host_name varchar(64) not null,
kernel varchar(64),
os varchar(64),
manufacturer varchar(32),
pod_name varchar(64),
sn varchar(128),
cpu_name varchar(64)
)"""
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()