KZsLNHuS

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
13import pyodbc
14conn_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)
21conn = pyodbc.connect(conn_str)
22crsr = conn.cursor()
23print("> MySQL variables ...")
24rows = crsr.execute("SHOW VARIABLES LIKE '%character%'").fetchall()
25for row in rows:
26	print('{}: {}'.format(row[0], row[1]))
27print()
28print("> row(s) retrieved from table ...")
29rows = crsr.execute("SELECT id, name, email FROM Employee").fetchall()
30for row in rows:
31	print(row)
32crsr.close()
33conn.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')