一、连接数据库
安装pymysql库后
#导入库
import pymysql
#连接数据库
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = 'root' #数据库密码
DBNAME = 'python_mysql' #自己建立的库的名称
#用try except捕获异常
try:
db = pymysql.connect(host=DBHOST,user=DBUSER, password=DBPASS, database=DBNAME)
print('数据库连接成功!')
except pymysql.Error as e:
print('数据库连接失败'+str(e))
二、增加一个新表格
#导入库
import pymysql
#连接数据库
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = 'root'
DBNAME = 'python_mysql'
#用try except捕获异常
try:
db = pymysql.connect(host=DBHOST,user=DBUSER, password=DBPASS, database=DBNAME)
print('数据库连接成功!')
cur = db.cursor() #声明一个游标
cur.execute('DROP TABLE IF EXISTS new_table3') #检查表格是否存在
sqlQuery = "CREATE TABLE new_table3(Name CHAR(20) NOT NULL ,Email CHAR(20),Age int )" # 创建表格的sql语句
cur.execute(sqlQuery)
print('表格创建成功')
except pymysql.Error as e:
print('表格创建失败' +