每日日报2021.11.5

完成内容：

python的学习 mysql

1.读取指定字段

import mysql.connector

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

mycursor = mydb.cursor() mycursor.execute("SELECT name, url FROM sites")

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

 2.一条数据

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.fetchone()

print(myresult)

3.where

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 ='RUNOOB'" mycursor.execute(sql)

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

4.%

import mysql.connector

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

mycursor = mydb.cursor()

sql = "SELECT * FROM sites WHERE url LIKE '%oo%'"

mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult: print(x)

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