Python的Limit语句_惠州计算机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 LIMIT 3") 

myresult = mycursor.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')

import mysql.connector 

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  passwd="123456",

  database="bdqn_db"

)

mycursor = mydb.cursor() 

mycursor.execute("SELECT * FROM sites LIMIT 3 OFFSET 1")  # 0 为 第一条，1 为第二条，以此类推 

myresult = mycursor.fetchall() 

for x in myresult:

  print(x)

(2, 'Google', 'https://www.google.com') 
(3, 'Github', 'https://www.github.com') 
(4, 'Taobao', 'https://www.taobao.com')