python - 在Python中显示选择Mysql查询，输出漂亮且可读

Question

我需要 python 脚本来显示具有良好输出的 sql 查询，并且可读，这对于繁重的表来说不可读...

cnx = mysql.connector.connect(user='root', password='*****',
                              host='127.0.0.1',
                              database='dietetique')
c = cnx.cursor()
sys.stdout = open('mysql_data.log', 'w')
c.execute("SELECT * FROM administrations;")

for row in c:
    print row

Answer 1

import pypyodbc
ID=2
ConnectionDtl='Driver={SQL Server};Server=WIN7-297;Database=AdventureWorks2014;trusted_connection=yes'
connection = pypyodbc.connect(ConnectionDtl)

print("Retrieve row based on [FirstName]='Mani'")
cursor = connection.cursor()
SQLCommand = ("SELECT [FirstName],[LastName] "
               "FROM Person.SampleData "
               "WHERE FirstName =?")
Values = ['Mani']
print(SQLCommand)
cursor.execute(SQLCommand,Values)
i=1
for x in cursor :
  row = cursor.fetchone()
  print str(i) + ". FirstName: " + row[0] + " LastName: " + row[1]
  i=i+1

connection.close()