Select from table

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

Please log in to like, share and comment!

グローバル工業用水素燃焼装置市場の産業全体規模とシェア分析2025-2031

2025年5月30日に、QYResearch株式会社（所在地：東京都中央区）は「工業用水素燃焼装置―グローバル市場シェアとランキング、全体の売上と需要予測、2025～2031」の最新調査資料を発...

By 2025-05-30 08:21:49 0

Other

Regional Spotlight: IgA Nephropathy Market Dynamics in Southeast Asia Indonesia, Malaysia, Philippines, Thailand and Vietnam

"Executive Summary Indonesia, Malaysia, Philippines, Thailand and Vietnam IgA Nephropathy...

By 2025-06-18 08:03:42 0

Other

Wired for Growth: Opportunities in the Asia-Pacific Copper Market

"Executive Summary Asia-Pacific Copper Market : A credible Asia-Pacific Copper...

By 2025-06-18 06:08:18 0

Information Technology

2025年5月27日に、QYResearch株式会社（所在地：東京都中央区）は「ダブルディープフライヤー―グローバル市場シェアとランキング、全体の売上と需要予測、2025～2031」の最新調査資...

By 2025-05-27 08:44:15 0

Other

Generic Drugs Market Research Report 2025-2034 - Industry Insights, Trends & Competitive Outlook

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

By 2025-05-27 05:12:32 0