每日日报2021.11.8

完成内容：

python的学习 mysql

1.%s

 import mysql.connector

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

mycursor = mydb.cursor()

sql = "SELECT * FROM sites WHERE name = %s"

na = ("RUNOOB", )

mycursor.execute(sql, na)

myresult = mycursor.fetchall() for x in myresult: print(x)

2.ORDER BY

import mysql.connector

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

mycursor = mydb.cursor()

sql = "SELECT * FROM sites ORDER BY name"

mycursor.execute(sql)

myresult = mycursor.fetchall() for x in myresult: print(x)

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