python通过mysql-connector操作数据库
1.增删改查数据,改sql即可
import mysql.connector
#1.创建连接对象
my_connector = mysql.connector.connect(
host="localhost",
user="root",
password="liuwei.520",
database="mybatis",
#mysql7之前的密码加密规则为mysql_native_password,mysql7之后是caching_sha2_password
auth_plugin="mysql_native_password"
)
#2.创建游标(放置数据的容器)
my_curse = my_connector.cursor()
#3.操作数据库
sql = "select * from blog"
my_curse.execute(sql)
my_curse.fetchall()
my_curse.fetchmany()
2.创建数据库
ef add_database():
共有 0 条评论