sql中查询操作

import pymysql
if __name__ == '__main__':
    conn = pymysql.connect(
        host="127.0.0.1",
        port=3306,
        database="myxs",
        user="root",
        password="1234",
        charset="utf8"
    )
    cursor = conn.cursor()
    sql = "SELECT * FROM users"
    cursor.execute(sql)
    '''
    获取查询结果
    '''
    users = cursor.fetchall()
    cursor.close()
    conn.close()

    for user in users:
        print("id:%d\t昵称:%s\t账号:%s\t密码:%s"%(user[0],user[3],user[1],user[2]))