MySQL学习_python操作MySQL

用python连接数据库分为以下几个步骤
1.首先下载pymysql

pip install pymysql

2.创建数据

# 1.导入pymysql
import pymysql
# 2.连接MySQL
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',charset=utf8,db='unicom')
cursor = conn.cursor(cursor=pymysql.cursors.DicCursor)
# 3.发送指令
# 3.1 生成指令
# cursor.execute("insert into admin(username,password,mobile) values('rui','123qwe','14563246789')")
sql = 'insert into admin(username,password,mobile) values(%s,%s,%s)'
cursor.execute(sql,['qwe','qwe12345','15678987654'])
# 3.2 执行命令
conn.commit()
# 4.关闭
cursor.close()
conn.close()

两个问题：

1. SQL拼接
2. SQL注入