python3.6 -m pip install pymysql
import pymysql
# 创建连接
conn = pymysql.connect( # 打开数据库连接
host='10.0.3.60', # IP
port=3307, # 端口
user='root', # 数据库用户名
password="xxxx", # 密码
database='db3', # 要连那个库
charset='utf8') # 设置字符集
# 拿到游标
cur = conn.cursor() # 默认返回的是元祖 conn.cursor(pymysql.cursors.DictCursor) 返回字典
cur.execute('show databases;') # 返回1条数据 ('information_schema',)
# content = cur.fetchone()
content = cur.fetchmany(2) # 返回2条数据 (('information_schema',), ('db1',))
# content = cur.fetchall() # 返回所有数据
print(content)
cur.close() # 关闭游标
conn.close() # 关闭数据库连接
sql = """
CREATE TABLE admin(
id INT(20) primary key auto_increment,
username char(20) unique not null,
password char(20) not null,
email char(50) not null
)ENGINE=InnoDB CHARSET=utf8;
"""
try:
cur.execute(sql)
conn.commit() # 提交sql
except:
print("sql执行失败")
conn.rollback() #遇到异常回滚
cur.close() # 关闭游标
conn.close() # 关闭数据库连接