Python MySQL--通过mysql-connector实现数据库管理

通过mysql-connector由python实现数据库的建库、建表、添加主键以及数据的增删改查

import mysql.connector
my_db = mysql.connector.connect (   host="localhost",user="root")                           
mycursor=my_db.cursor()
mycursor.execute("drop database if exists mydb0")            #删库

createDB="create database mydb0"
useDB="use mydb0"
createT="create table users (uID varchar(10) primary key,uName varchar(10))"
ins="insert into users (uID,uName) values (%s, %s)"
val=[
        ('001','jxnu'),
        ('002','ncu'),
        ('003','pku')
    ]
delt="delete from users where uID=003"
sel="select * from users"
upd="update users set uName='jufe' where uID='002' "


mycursor.execute(createDB)     #建库
mycursor.execute(useDB)         #连接库
mycursor.execute("show databases")
for x in mycursor:
    print(x)
print("**********************")

mycursor.execute(createT)                   #建表，指定主键
mycursor.execute("desc users")
for x in mycursor:
    print(x)
print("**********************")

mycursor.executemany(ins,val)       #批量插入
 
mycursor.execute(delt)       #删除

mycursor.execute(upd)       #更新

mycursor.execute(sel)       #查找
for x in mycursor:
    print(x)

my_db.commit()             # 数据表内容有更新时 须使用该语句才能将修改添加到数据库中 

运行结果：