python连接Mysql

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()