每日日报2021.11.11

完成内容：

python的学习 MySQL

1.update

import mysql.connector

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

mycursor = mydb.cursor()

sql = "UPDATE sites SET name = 'ZH' WHERE name = 'Zhihu'"

mycursor.execute(sql)

mydb.commit()

print(mycursor.rowcount, " 条记录被修改")

 2.%s

import mysql.connector

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

mycursor = mydb.cursor()

sql = "UPDATE sites SET name = %s WHERE name = %s"

val = ("Zhihu", "ZH") mycursor.execute(sql, val)

mydb.commit()

print(mycursor.rowcount, " 条记录被修改")

3.drop table

import mysql.connector

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

mycursor = mydb.cursor()

sql = "DROP TABLE IF EXISTS sites" # 删除数据表

sites mycursor.execute(sql)

 

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