Question

How to use SQL to left join two tables to combine rows in MySQL database 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()

sql = "SELECT \
       workers.first_name, salaries.salary \
       FROM workers \
       LEFT JOIN salaries ON workers.id = salaries.id"

db_cursor.execute(sql)

result = db_cursor.fetchall()

for row in result:
    print(row)

db.close()

 
'''
run:

('Fox', 12434.0)
('Aurora', 13098.0)
('Amy', 10898.0)
('Arthur', 15983.0)
('R2D2', 13000.0)
('Ben', None)

'''

 

70+ SQL courses for beginners and professionals