Python查询数据_惠州计算机Python软件开发

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

mycursor.execute("SELECT * FROM sites") 

myresult = mycursor.fetchall()     # fetchall() 获取所有记录 

for x in myresult:

  print(x)

(1, 'BDQN', 'https://www.bdqn.com') 
(2, 'Google', 'https://www.google.com') 
(3, 'Github', 'https://www.github.com') 
(4, 'Taobao', 'https://www.taobao.com') 
(5, 'stackoverflow', 'https://www.stackoverflow.com/') 
(6, 'Zhihu', 'https://www.zhihu.com')

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

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

myresult = mycursor.fetchall() 

for x in myresult:

  print(x)

('BDQN', 'https://www.bdqn.com') 
('Google', 'https://www.google.com') 
('Github', 'https://www.github.com') 
('Taobao', 'https://www.taobao.com') 
('stackoverflow', 'https://www.stackoverflow.com/') 
('Zhihu', 'https://www.zhihu.com')

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

mycursor.execute("SELECT * FROM sites") 

myresult = mycursor.fetchone()

print(myresult)

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