数据库

import pymysql

#ip port user password  db

#118.24.3.40  3306 jxz 123456 jxz

conn = pymysql.connect(host=‘118.24.3.40‘,user=‘jxz‘,
                password=‘123456‘,db=‘jxz‘,port=3306,
                charset=‘utf8‘,autocommit=True)#建立连接
cur = conn.cursor(pymysql.cursors.DictCursor) #建立游标
# sql = "insert1 app_student ( `name`, `sex`, `age`, `addr`, `grade`, `phone`, `gold`) values" \
#       " ( ‘小黑‘, ‘男‘, ‘18‘, ‘河南省济源市北海大道32号‘, ‘天蝎座‘, ‘18612539443‘, ‘100‘);"



操作数据库的函数 

import pymysql

def op_mysql(host,user,password,db,sql,port=3306,many_tag=False):
    conn = pymysql.connect(host=host,user=user,password=password,
                           db=db,port=port,charset=‘utf8‘,
                           autocommit=True)
    cur = conn.cursor(pymysql.cursors.DictCursor)
    cur.execute(sql)
    if many_tag:
        result = cur.fetchall()
    else:
        result = cur.fetchone()
    cur.close()
    conn.close()
    return result

# sql2 = ‘select * from app_student where phone="18612539443"‘;
sql2 = ‘select * from app_student limit 4‘;

cur.execute(sql2)#只是帮你执行sql语句
print(cur.fetchall()) #取到所有的数据
# print(cur.fetchone()) #只取一条
# print(cur.fetchmany(10)) #取几条
cur.close()
conn.close()

数据库

原文：https://www.cnblogs.com/Dorami/p/11096766.html