Newbee - MySQL create database/table

[Skip Montanaro]

    Danny> I wonder if someone could put here or send me a sample Python
    Danny> scrip on how to create a database and how to create a table using
    Danny> MySQL with MySQLdb. 

Danny,

I don't need to create databases or tables on-the-fly, so I create them
ahead of time with a sql script I feed directly to the mysql program, but
something like this ought to work:

    db = MySQLdb.Connection(host=host,
                            user=user,
                            passwd=password,
                            db=database)
    c = db.cursor()
    # create a database
    c.execute("create database concerts")
    # make it the current db
    c.execute("use concerts")
    # add a table named evperf
    c.execute("""create table evperf (
      id int unsigned DEFAULT 0 NOT NULL AUTO_INCREMENT,
      event int unsigned DEFAULT 0 NOT NULL,
      performer int unsigned DEFAULT 0 NOT NULL,
      unique id (id),
      key event (event),
      key performer (performer)
    )""")

-- 
Skip Montanaro (skip at pobox.com)
http://www.mojam.com/
http://www.musi-cal.com/