一、代码实现
python2使用MySQLdb模块
python3使用pymysql模块
代码用的是python2，去掉注释可换成python3
#-*- encoding: utf-8 -*-
'''
MysqlUtil.py
Created on 2020/8/27 20:33
Copyright (c) 2020/8/27, Google Copy right
@author: com
'''
import MySQLdb
# import pymysql
try:
db = MySQLdb.connect(host="localhost", user="root", passwd="123456", db="test", charset="utf8")
# db = pymysql.connect(host="localhost", user="root", passwd="123456", db="test", charset="utf8")
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
print("MySQL Version : %s" % data)
cursor.execute("SELECT * FROM user")
result = cursor.fetchall()
for row in result:
print("%d \t %s \t %d" % row)
db.commit()
except:
db.rollback()
finally:
db.close()二、执行结果
三、测试数据
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50722
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 50722
File Encoding : 65001
Date: 22/09/2020 16:44:52
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`age` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '新中国', 70);
INSERT INTO `user` VALUES (2, '吴京', 50);
INSERT INTO `user` VALUES (3, '李小龙', 32);
INSERT INTO `user` VALUES (4, '科比', 43);
INSERT INTO `user` VALUES (5, '胡歌', 40);
INSERT INTO `user` VALUES (6, '汪大东', 30);
INSERT INTO `user` VALUES (7, '汪大东', 30);
SET FOREIGN_KEY_CHECKS = 1;
