Select from table

Postado 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)

Faça o login para curtir, compartilhar e comentar!

Outro

Aircraft Hangar Market Trends, Opportunities, Current Analysis and Forecast (2024-2032) | UnivDatos

Introduction: Aircraft Hangars are used to keep aircraft both rotary and fixed-wing for...

Por 2025-06-09 08:56:47 0

Health

Cenforce 100: Dosage, Benefits, and Side Effects for ED Treatment

Erectile Dysfunction (ED) is a condition that affects millions of men around the world, impacting...

Por 2025-06-02 09:17:27 0

Outro

Customisable Travel Accessories in singapore

Customisable Travel Accessories in Singapore – Stylish & Practical | GiftAssembly...

Por 2025-06-06 10:46:40 0

Sports

Tennis Academy Singapore

Premier Tennis Academy in Singapore for All Ages | Private Tennis Lessons with Certified Coaches...

Por 2025-06-13 08:13:37 0

Outro

Astrology Services by Pandit Ji On Call – 24/7 Expert Advice Pan

Understanding the Secrets of Life through Pandit Ji On Call Astrology Services Although...

Por 2025-05-29 12:56:37 0