Creating films table


import MySQLdb
import sys
try:
conn = MySQLdb.connect (host = "SQL09.FREEMYSQL.NET",
user = "utsavsabharwal",
passwd = "primanuts",
db = "moviebook")
except MySQLdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
sys.exit (1)
cursor = conn.cursor ()
cursor.execute ("create table films(uid INT, name VARCHAR(999), year INT)")
print "hello"


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: