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.创建数据库

def add_database():
    # 1.创建连接对象
    my_connector = mysql.connector.connect(
        host="localhost",
        user="root",
        password="liuwei.520",
        # mysql7之前的密码加密规则为mysql_native_password,mysql7之后是caching_sha2_password
        auth_plugin="mysql_native_password"
    )

    #2.创建游标(放置数据的容器)
    my_curse = my_connector.cursor()

    #3.操作
    sql = "create database test"
    my_curse.execute(sql)