Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Trees

Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

8,956 questions

12,358 answers

573 users

How to use SQL to right join two tables to combine rows in MySQL database with Python

1 Answer

0 votes
# 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 \
       RIGHT 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)
(None, 11983.0)

'''

 




answered 3 days ago by avibootz
...