Shulou(Shulou.com)06/01 Report--

This article mainly introduces the output mode of python to read the value of mysql query results, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance to everyone's reference, so let's learn about the output mode of reading mysql query result values by python together with the author.

#! / bin/python

# coding=utf-8

Import MySQLdb

Import time

Import sys

Import MySQLdb.cursors

# add character set parameters to prevent Chinese garbled

Print "- TOP OS SLAVE 10 -"

Conn = MySQLdb.connect (host= "XXXX", db= "mysql", user= "user", passwd= "password", port=338

0BET = "utf8")

Cursor = conn.cursor ()

Query = "select distinct t.userroomhostMagnet.sqlroomtext from mysql.slow_log t where t.query_time > 5 and t.start_time > = SUBDATE (CURDATE (), DATE_FORMAT (CURDATE (),'% w') + 3) and t.start_time5 and

T.start_time > = SUBDATE (CURDATE (), DATE_FORMAT (CURDATE (),'% w') + 3) and t.start_time

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.