Select from table

Сообщение 2022-11-12 01:22:42

239

To select from a table in MySQL, use the “SELECT” statement.

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)

Войдите, чтобы отмечать, делиться и комментировать!

Другое

Registered NDIS Provider in Ballarat

At Admire Support Services, we take pride in being a trusted and Registered NDIS Provider in...

От 2025-06-17 10:29:16 0

Другое

Asia-Pacific Solar Panel Cleaning Market: Market Landscape and Growth Outlook

Asia Pacific Solar Panel Cleaning Market The Asia-Pacific solar panel cleaning market is...

От 2025-06-11 06:08:04 0

Crafts

Rising Data Transfer Demands Propel Growth of USB 3.0 Market Worldwide

"Executive Summary USB 3.0 Market : Global USB 3.0 market size was valued at USD...

От 2025-06-19 04:46:37 0

Другое

Platelet Aggregation Devices Market Research, Review, Applications and Forecast to 2025

The most recent report published by Vantage Market Research indicates that the "Platelet...

От 2025-06-11 06:08:44 0