MySQL学习_python操作MySQL

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

pip install pymysql
1

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
2
3
4
5
6
7
8
9
10
11
12
13
14
15

两个问题：

1. SQL拼接
2. SQL注入