数据库第四节课:pymysql
一.基本使用:
import pymysql
conn = pymysql.connect(host='ip地址',port=端口号,user='账号',password='密码',database='数据库名',charset='字符集')
cursor = conn.cursor()
sql = 'sql操作语言'
res = cursor.execute(sql)
cursor.close()
conn.close()
二.建表建库
1).建库:
import pymysql
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',password='root',charset='utf8')
cursor = conn.cursor()
sql = 'create database sc1123 DEFAULT CHARACTER SET utf8'
cursor.execute(sql)
cursor.close()
conn.close()
建表:
import pymysql
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',password='root',database='sc1123',charset='utf8')
cursor = conn.cursor()
sql = 'create table hhh(h_id int PRIMARY KEY ,h_name VARCHAR(10),h_sex VARCHAR (3))'
cursor.execute(sql)
cursor.close()
conn.close()
三.增删改
import pymysql
def add_def_update(sql):
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',password='root',database='sc1123',charset='utf8')
cursor = conn.cursor()
try:
res = cursor.execute(sql)
except:
conn.rollback()
conn.commit()
cursor.close()
conn.close()
return res
四.查询
import pymysql
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',password='root',database='sc1123',charset='utf8')
cursor = conn.cursor()
sql = '查询语句'
cursor.execute(sql)
res = cursor.fetchall()
cursor.fetchone()
cursor.fetchmany(x)
print(res)
cursor.close()
conn.close()