Question

How to return all rows with specific columns from SQL SELECT in MySQL database table with Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
   
import mysql.connector
   
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
  
db_cursor = db.cursor()
  
db_cursor.execute("SELECT first_name, profession FROM workers")

result = db_cursor.fetchall()

for row in result:
    print(row)

db.close()

'''
run:
 
('Fox', 'C Programmer')
('Aurora', 'C++ Programming')
('Amy', 'Python Programmer')
('Arthur', 'Java Programmer')
('R2D2', 'Super Programmer')

'''

 

70+ SQL courses for beginners and professionals