通过python连接操作mysql数据库

通过python连接操作mysql数据库

import mysql.connector#导入connector
my_db=mysql.connector.connect(#使用my_db接受，其他用户名也可，符合命名原则
        host="localhost",user="root",passwd="123")#连接数据库，获得数据库方法
mycursor=my_db.cursor()
mycursor.execute("create database mydb1")

‘’’

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="123")
mycursor=mydb.cursor()
mycursor.execute("show databases")#execute方法执行sql语句
for x in mycursor:
        print(x)
print("____________________")
mycursor.execute("drop database if exists mydb1")
mycursor.execute("show databases")
for x in mycursor:
        print(x)

‘’’
‘’’

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="123")
mycursor=mydb.cursor()
mycursor.execute("create database mydb3")
mycursor.execute("use mydb3")
mycursor.execute("create table user(userID varchar(10) primary key,userName varchar(10))")
#插入单个数据
mycursor.execute("insert into user values('001','cft')")
#批量插入
val=[('002','ccc'),('003','eee'),('004','ooo')]
ins="insert into user(userID,userName) values (%s,%s)"
mycursor.executemany(ins,val)

mycursor.execute("select * from user")
for x in mycursor:
        print(x)
mydb.commit();

‘’’

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="123")
mycursor=mydb.cursor()
mycursor.execute("create database mydb6")
mycursor.execute("use mydb6")
mycursor.execute("create table user(userID varchar(10),userName varchar(10),userAdd varchar(10))")
mycursor.execute("alter table user add useAge varchar(10)")
mycursor.execute("desc user")
for x in mycursor:
        print(x)
mydb.commit();