Python连接MySQL数据库,并创建数据库、数据表、插入删除查询修改记录等
1.下载安装并导入pymysql库
用cmd命令pip3 install pymysql下载安装
之后再导入库
import pymysql
2.连接并创建数据库,数据表
import pymysql
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = '123456'
DBNAME = 'test'
try:
db=pymysql.connect(DBHOST,DBUSER,DBPASS,DBNAME)
print('数据库成功连接!')
cur=db.cursor()
cur.execute("DROP TABLE IF EXISTS student")
sql='CREATE TABLE student(name VARCHAR(20) NOT NULL,Email VARCHAR(20),Age int)'
cur.execute(sql)
except pymysql.Error as e:
print('表格创建失败:'+str(e))
3.在表中插入一条数据
import pymysql
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = '123456'
DBNAME = 'test'
try:
db=pymysql.