Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## test table used:
- ##
- ## CREATE TABLE IF NOT EXISTS `employee` (
- ## `id` int(11) NOT NULL AUTO_INCREMENT,
- ## `name` varchar(255) NOT NULL,
- ## `email` varchar(255) NOT NULL,
- ## PRIMARY KEY (`id`)
- ## ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- ##
- ## INSERT INTO `employee` (`id`, `name`, `email`) VALUES
- ## (1, 'André the Giant', 'atg@example.com');
- import pyodbc
- conn_str = (
- "Driver={MySQL ODBC 5.3 Unicode Driver};"
- "Server=192.168.1.122;"
- "Port=3307;"
- "Database=mydb;"
- "User=root;Password=whatever;"
- )
- conn = pyodbc.connect(conn_str)
- crsr = conn.cursor()
- print("> MySQL variables ...")
- rows = crsr.execute("SHOW VARIABLES LIKE '%character%'").fetchall()
- for row in rows:
- print('{}: {}'.format(row[0], row[1]))
- print()
- print("> row(s) retrieved from table ...")
- rows = crsr.execute("SELECT id, name, email FROM Employee").fetchall()
- for row in rows:
- print(row)
- crsr.close()
- conn.close()
- ## console output:
- ##
- ## > MySQL variables ...
- ## character_set_client: utf8
- ## character_set_connection: utf8
- ## character_set_database: utf8
- ## character_set_filesystem: binary
- ## character_set_results:
- ## character_set_server: latin1
- ## character_set_system: utf8
- ## character_sets_dir: C:\Users\Public\Downloads\USBWebserver v8.6\mysql\share\charsets\
- ##
- ## > row(s) retrieved from table ...
- ## (1, 'André the Giant', 'atg@example.com')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement