Connecting to a MySQL Database Server : MySQL « Database « Python Tutorial





import MySQLdb

myDB = MySQLdb.connect(host="127.0.0.1", port=3306)
cHandler = myDB.cursor()

cHandler.execute("SHOW DATABASES")
results = cHandler.fetchall()
for item in results:
    print item[0]

cHandler.execute("SELECT DATABASE()")
results = cHandler.fetchall()
for item in results:
    print item[0]

cHandler.execute("USE schedule")

cHandler.execute("SELECT DATABASE()")
results = cHandler.fetchall()
for item in results:
    print item[0]
myDB.close()










15.3.MySQL
15.3.1.Basic connection to MySQL with mysqldb
15.3.2.Connecting to a MySQL Database Server
15.3.3.Creating a MySQL Database
15.3.4.Adding Entries to a MySQL Database
15.3.5.Retrieving Entries from a MySQL Database
15.3.6.Create table, insert data, update data and select data