Breaking News: Grepper is joining You.com. Read the official announcement!

pymysql connect port

Ugly Unicorn answered on November 22, 2022 Popularity 4/10 Helpfulness 5/10

answer pymysql connect port

pymysql connect port

Comment

db = pymysql.connect(host='funcoding-db.ca1fydhpobsc.ap-northeast-2.rds.amazonaws.com', port=3306, user='davelee', passwd='korea123', db='dave_db', charset='utf8')
try:
    cursor = db.cursor()
    sql = "SELECT * FROM cpu_info"
    cursor.execute(sql)
    result = cursor.fetchall()
    for row_data in result:
        print(row_data[0])
        print(row_data[1])
        print(row_data[2])
        print(row_data[3])        
finally:
    db.close()

Popularity 4/10 Helpfulness 5/10 Language sql

Source: www.fun-coding.org

Tags: port sql

Link to this answer
Share Copy Link