1.连接数据库,首先应导入MySQLdb库:
con=MySQLdb.connect(host="192.168.10.205", port=3306, user="root", passwd="123456", db="seaares")
cursor=con.cursor()
2.写SQL语句,并执行SQL语句:
sql = "SELECT DISTINCT CUSTOMER_NO FROM custom_base WHERE CUSTOMER_NO IS NOT NULL AND START_TIME like '%s%s'" % (tm,'%')
cursor.execute(sql)
results_user=cursor.fetchall()
3.关闭数据库连接:
cursor.close()
con.close()
4.在关闭连接之前,如果对数据库进行了修改,应该执行下面的语句:
con.commit()