import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="您的用戶名",
  password="您的密碼",
  database="我的數(shù)據(jù)庫"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers LIMIT 5")
myresult = mycursor.fetchall()
for x in myresult:
  print(x)

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="您的用戶名",
  password="您的密碼",
  database="我的數(shù)據(jù)庫"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers LIMIT 5 OFFSET 2")
myresult = mycursor.fetchall()
for x in myresult:
  print(x)

import mysql.connector
# 連接到MySQL數(shù)據(jù)庫
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)
# 創(chuàng)建游標對象
mycursor = mydb.cursor()
# 使用INNER JOIN合并用戶和產(chǎn)品表格
sql = "SELECT \
  users.name AS user, \
  products.name AS favorite \
  FROM users \
  INNER JOIN products ON users.fav = products.id"
# 執(zhí)行SQL查詢
mycursor.execute(sql)
# 獲取查詢結(jié)果
myresult = mycursor.fetchall()
# 打印結(jié)果
for x in myresult:
  print(x)

sql = "SELECT \
  users.name AS user, \
  products.name AS favorite \
  FROM users \
  LEFT JOIN products ON users.fav = products.id"

sql = "SELECT \
  users.name AS user, \
  products.name AS favorite \
  FROM users \
  RIGHT JOIN products ON users.fav = products.id"