Creating a MySQL Database : MySQL « Database « Python Tutorial






  1. Python Tutorial
  2. Database
  3. MySQL
import MySQLdb

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

cHandler = myDB.cursor()

cHandler.execute("CREATE DATABASE schedule")
cHandler.execute("USE schedule")

cHandler.execute("CREATE TABLE Arrivals (city TEXT,flight TEXT, time TEXT)")

cHandler.execute("SHOW TABLES")
results = cHandler.fetchall()
print results

cHandler.execute("DESCRIBE Arrivals")
results = cHandler.fetchall()
print results

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