python连接Mysql

python 3.x 开始需要下载安装PyMySQL 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
import pymysql

ip = 'localhost'
user = 'root'
password = ''
db = 'spr'

if __name__ == '__main__':
    print('开始连接~')
    # 打开数据库连接
    con = pymysql.connect(host=ip, port=3306, user=user, passwd=password, db=db, charset='utf8')
    # 游标对象
    cur = con.cursor()
    # 执行sql
    cur.execute('select * from food')
    res = cur.fetchall()
    print(res)

    # 插入
    sql = "insert into food (fName,fDesc) values('%s','%s')"
    data = ('小西瓜', '一毛一个')
    cur.execute(sql % data)
    con.commit()
    print('成功插入', cur.rowcount, '条数据')

    # 关闭连接
    con.close()