Python3对mysq数据库的常规操作(pymsql模块）

#Python3中用pymsql模块进行mysql数据库的操作#

# !/usr/bin/env python
# -*- coding: utf-8 -*-
"""
@Author: P♂boy
@License: (C) Copyright 2013-2017, Node Supply Chain Manager Corporation Limited.
@Contact: 17647361832@163.com
@Software: Pycharm
@File: Mysql.py
@Time: 2018/11/17 20:38
@Desc:MySql
"""

import pymysql

# 打开数据库连接
db = pymysql.connect('localhost', 'root', '', 'Python')	# ip,数据库用户名,密码,数据库名称


cursor = db.cursor()

try:
    cursor.execute('DROP TABLE IF EXISTS EMPLOYEE')
except:
    print('表EMPLOYEE不存在！，直接创建')

else:
    print('原表已删除！')
finally:
    pass

# data = cursor.fetchone()
#
# print("Database version : %s " % data)
#
sql = '''CREATE TABLE EMPLOYEE(
          FIRST_NAME CHAR(20) NOT NULL,
          LAST_NAME CHAR(20),
          AGE INT,
          SEX CHAR(1),
          INCOME FLOAT)'''
cursor.execute(sql)
sql = '''INSERT INTO EMPLOYEE(FIRST_NAME,LAST_NAME,AGE, SEX, INCOME)
        VALUES('gw','MOHAN', 24, 'M', 2000) '''

try:
    cursor.execute(sql)
    db.commit()
    print('事务已提交')
except:
    print('发生错误,数据回滚')
    db.rollback()

db.close()
print('数据库已关闭')

结果: