Python的where条件语句_惠州计算机Python软件开发

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

sql = "SELECT * FROM sites WHERE name ='BDQN'" 

mycursor.execute(sql) 

myresult = mycursor.fetchall()

for x in myresult:

  print(x)

(1, 'BDQN', 'https://www.bdqn.com')

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

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

mycursor.execute(sql) 

myresult = mycursor.fetchall() 

for x in myresult:

  print(x)

(1, 'BDQN', 'https://www.bdqn.com') 
(2, 'Google', 'https://www.google.com')

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 = ("BDQN", ) 

mycursor.execute(sql, na) 

myresult = mycursor.fetchall() 

for x in myresult:

  print(x)