Python3连接MySQL数据库

# 导入pymysql模块
import pymysql

# 连接database
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456',db='test',charset='utf8')
# 得到一个可以执行SQL语句的光标对象
cursor = conn.cursor() 

# 定义要执行的SQL语句
sql = """
CREATE TABLE USER1 (
id INT auto_increment PRIMARY KEY ,
name CHAR(10) NOT NULL UNIQUE,
age TINYINT NOT NULL
)ENGINE=innodb DEFAULT CHARSET=utf8;
"""

# 执行SQL语句
cursor.execute(sql) 
# 关闭光标对象
cursor.close() 
# 关闭数据库连接
conn.close()

# 导入pymysql模块
import pymysql

# 连接database
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456',db='test',charset='utf8')
# 得到一个可以执行SQL语句的光标对象
cursor = conn.cursor() 

# 定义要执行的SQL语句
sql = "INSERT INTO USER1(name, age) VALUES (%s, %s);"
username = "文博"
age = 18

# 执行SQL语句
cursor.execute(sql, [username, age])
# 提交事务
conn.commit()
# 关闭光标对象
cursor.close()
# 关闭数据库连接
conn.close()