First page Back Continue Last page Overview Graphics

Example: Server Version (Python 3)

import mysql.connector as mc

connection = mc.connect (host = "localhost",

user = "pytester",

passwd = "monty",

db = "musicarchive")

cursor = connection.cursor()

cursor.execute ("SELECT VERSION()")

row = cursor.fetchone()

print("server version:", row[0])

cursor.close()

connection.close()