import pymysql conn=pymysql.connect(host='ip',user='user',password='password',database='db',charset='utf8mb4') cur=conn.cursor() cur.execute("select * from table1 row=cur.fetchall() for content in list(row): print(content)
import pymysql if __name__ == "__main__": connect = pymysql.connect(host='localhost', user='root', password='root', database='music', charset='utf8mb4') cursor = connect.cursor() cursor.execute("select * from music_music") content = cursor.fetchall() for item in content: print(item)