# python3 -m pip3 install mysql-connector
import mysql.connector
mydb = mysql.connector.connect(
host = '0.0.0.0', # 数据库主机地址
user = 'root', # 数据库用户名
password = '123456', # 数据库密码
database = 'demo' # 指定连接数据库
)
mycursor = mydb.cursor()
# mycursor.execute('SELECT * FROM capacity_number limit 3')
# fetchall() 获取所有记录
# myresult = mycursor.fetchall()
# for x in myresult:
# print(x)
mycursor.execute('SELECT * FROM capacity_number')
# 读取一条数据,可以使用 fetchone() 方法
myresult = mycursor.fetchone()
print(type(myresult),myresult)
# 批量插入使用 executemany() 方法,该方法的第二个参数是一个元组列表,包含了我们要插入的数据:
# sql = "INSERT INTO capacity_number (name, phone VALUES (%s, %s)"
# val = [
# ('xiaohong', '11111'),
# ('xiaoming', '22222'),
# ('zhang', '33333'),
# ('li', '44445')
# ]
#
# mycursor.executemany(sql, val)
#
# mydb.commit() # 数据表内容有更新(indert update delete),必须使用到该语句
python mysql.connector操作mysql
最新推荐文章于 2024-07-23 10:59:16 发布