每日日报2021.11.4

完成内容：

python的学习 mysql

1.插入数据

import mysql.connector

mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="runoob_db" )

mycursor = mydb.cursor()

sql = "INSERT INTO sites (name, url) VALUES (%s, %s)"

val = ("RUNOOB", "https://www.runoob.com")

mycursor.execute(sql, val)

mydb.commit() # 数据表内容有更新，必须使用到该语句

print(mycursor.rowcount, "记录插入成功。")

 2.大量数据

import mysql.connector

mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="runoob_db" )

mycursor = mydb.cursor()

sql = "INSERT INTO sites (name, url)VALUES (%s, %s)"

val = [ ('Google', 'https://www.google.com'), ('Github', 'https://www.github.com'), ('Taobao', 'https://www.taobao.com'), ('stackoverflow', 'https://www.stackoverflow.com/') ]

mycursor.executemany(sql, val) mydb.commit() # 数据表内容有更新，必须使用到该语句

print(mycursor.rowcount, "记录插入成功。")

3.获取ID

import mysql.connector

mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="runoob_db" )

mycursor = mydb.cursor() sql = "INSERT INTO sites (name, url) VALUES (%s, %s)"

val = ("Zhihu", "https://www.zhihu.com")

mycursor.execute(sql, val)

mydb.commit()

print("1 条记录已插入, ID:", mycursor.lastrowid)

4.查询

import mysql.connector

mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="runoob_db" )

mycursor = mydb.cursor() mycursor.execute("SELECT * FROM sites")

myresult = mycursor.fetchall() # fetchall() 获取所有记录 for x in myresult: print(x)

遇到问题：
无
目标：继续学习