import pymysql pymysql.install_as_MySQLdb() import MySQLdb conn = MySQLdb.Connection( host = 'localhost', user = 'root', password = 'root', port = 3306, database = 'test', charset = 'utf8' ) cursor = conn.cursor() sql = 'select * from equipment' cursor.execute(sql) data = cursor.fetchall() print(data)
cursor.close() conn.close()