조회출력

import pymysql

conn, cur = None,None

data1,data2,data3,data4 ='','','',''

row=None

conn = pymysql.connect(

    host="127.0.0.1",

    user="root",

    passwd="    ",

    db='soloDB',

    charset='utf8'

)

cur =conn.cursor()

cur.execute("SELECT * FROM userTable")

print("사용자ID     사용자이름    이메일     출생연도")

print("-----------------------------------------")

rows = cur.fetchall()

for row in rows:

    data1=row[0]

    data2=row[1]

    data3=row[2]

    data4=row[3]

    print(f"{data1:<10} {data2:<10} {data3:<20} {data4}")

conn.close()