python连接数据库

#导入pymysql包
import pymysql
# 创建数据库连接
db = pymysql.connect(host="localhost",port=3306,user="root",password="anywhere",db="test1" )
#获取一个游标对象
cursor=db.cursor()

try:
    create_sqli = "create table sys (id int, name varchar(30),phone int);"
    cursor.execute(create_sqli)
except Exception as e:
    print("创建数据表失败:", e)
    print("创建数据表失败:", e)
else:
    print("创建数据表成功;")

# ---------------插入---------
try:
    insert_sqli = "insert into sys values(001, 'xiaoming',123456789);"
    cursor.execute(insert_sqli)
except Exception as e:
    print("插入数据失败:", e)
else:
    # 如果是插入数据， 一定要提交数据， 不然数据库中找不到要插入的数据;
    db.commit()
    print("插入数据成功;")

db.close()#关闭数据库连接
cursor.close()#关闭游标

在终端处：

mysql -uroot -p anywhere

 show database；

create database test1;

 use test1;

select * from sys;