fork download
  1. import pymysql
  2.  
  3.  
  4. def connection():
  5. conn = pymysql.connect(db='x',
  6. user='x',
  7. passwd='x',
  8. host='x')
  9. return conn
  10.  
  11.  
  12. def test(conn):
  13. with conn.cursor() as cursor:
  14. sql = "SELECT id from xxxx"
  15. cursor.execute(sql)
  16. result = cursor.fetchall()
  17. print(result)
  18.  
  19. def main():
  20. test(connection())
  21.  
  22. main()
  23.  
  24.  
Runtime error #stdin #stdout #stderr 0.16s 23496KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Traceback (most recent call last):
  File "./prog.py", line 1, in <module>
ModuleNotFoundError: No module named 'pymysql'