Advertisement
Guest User

Untitled

a guest
Mar 15th, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. ## test table used:
  2. ##
  3. ## CREATE TABLE IF NOT EXISTS `employee` (
  4. ## `id` int(11) NOT NULL AUTO_INCREMENT,
  5. ## `name` varchar(255) NOT NULL,
  6. ## `email` varchar(255) NOT NULL,
  7. ## PRIMARY KEY (`id`)
  8. ## ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  9. ##
  10. ## INSERT INTO `employee` (`id`, `name`, `email`) VALUES
  11. ## (1, 'André the Giant', 'atg@example.com');
  12.  
  13. import pyodbc
  14. conn_str = (
  15. "Driver={MySQL ODBC 5.3 Unicode Driver};"
  16. "Server=192.168.1.122;"
  17. "Port=3307;"
  18. "Database=mydb;"
  19. "User=root;Password=whatever;"
  20. )
  21. conn = pyodbc.connect(conn_str)
  22. crsr = conn.cursor()
  23. print("> MySQL variables ...")
  24. rows = crsr.execute("SHOW VARIABLES LIKE '%character%'").fetchall()
  25. for row in rows:
  26. print('{}: {}'.format(row[0], row[1]))
  27. print()
  28. print("> row(s) retrieved from table ...")
  29. rows = crsr.execute("SELECT id, name, email FROM Employee").fetchall()
  30. for row in rows:
  31. print(row)
  32. crsr.close()
  33. conn.close()
  34.  
  35. ## console output:
  36. ##
  37. ## > MySQL variables ...
  38. ## character_set_client: utf8
  39. ## character_set_connection: utf8
  40. ## character_set_database: utf8
  41. ## character_set_filesystem: binary
  42. ## character_set_results:
  43. ## character_set_server: latin1
  44. ## character_set_system: utf8
  45. ## character_sets_dir: C:\Users\Public\Downloads\USBWebserver v8.6\mysql\share\charsets\
  46. ##
  47. ## > row(s) retrieved from table ...
  48. ## (1, 'André the Giant', 'atg@example.com')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement