fork download
copy 
  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. connection()
  12.  
  13. def test(conn):
  14.     with conn.cursor() as cursor:
  15.         sql = "SELECT id from xxxx"
  16.         cursor.execute(sql)
  17.         result = cursor.fetchall()
  18.         print(result)
  19.  
  20. test()
  21.  
  22.  
  23.  
Runtime error #stdin #stdout #stderr 0.14s 23560KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Traceback (most recent call last):
  File "./prog.py", line 1, in <module>
ModuleNotFoundError: No module named 'pymysql'
https://ideone.com/XaTPfr
language:
Python 3 (python  3.9.5)
created:
3 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!