MySQL SELECT
Jadvaldan tanlang
MySQL-dagi jadvaldan tanlash uchun "SELECT" iborasidan foydalaning:
Misol
"Mijozlar" jadvalidan barcha yozuvlarni tanlang va natijani ko‘rsating:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
Misolni ishga tushirish »
Eslatma: Biz oxirgi bajarilgan operatordan barcha stringlarni oladigan fetchall() usulidan foydalanamiz.
Ustunlarni tanlash
Jadvaldagi faqat ba’zi ustunlarni tanlash uchun "SELECT" iborasidan keyin ustun(lar) nomidan foydalaning:
Misol
Faqat nom va manzil ustunlarini tanlang:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT name, address FROM customers")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
Misolni ishga tushirish »
fetchone() usulidan foydalanish
Agar siz faqat bitta qatorga qiziqsangiz,fetchone() usulidan foydalanishingiz mumkin.
fetchone() usuli natijaning birinchi qatorini qaytaradi:
Misol
Faqat bitta qatorni olish:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers")
myresult = mycursor.fetchone()
print(myresult)
Misolni ishga tushirish »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!