import MySQLdb db= MySQLdb.connect(host="localhost", user="python-test", passwd="python", db="python-test") try: title = raw_input("Please enter a book title: ") if title == "" : exit author = raw_input("Please enter the author's name: ") pubdate = int( raw_input("Enter the publication year: ") ) except: print "Invalid value" exit print "Title: [" + title + "]" print "Author: ["+ author + "]" print "Publication Date: " + str(pubdate) cursor = db.cursor() stmt = "INSERT INTO Books (BookName, BookAuthor, PublicationDate) VALUES ('" stmt = stmt + title stmt = stmt + "', '" stmt = stmt + author stmt = stmt + "', " stmt = stmt + str(pubdate) stmt = stmt + ")" cursor.execute(stmt) print "Record added!" cursor.close () db.commit ()
Wednesday, September 12, 2012
Inserting into MySQL Database Using Python Program
Subscribe to:
Post Comments (Atom)
Great Article
Final Year Projects for CSE in Python
FInal Year Project Centers in Chennai
JavaScript Training in Chennai
JavaScript Training in
Chennai
I have joined your feed and sit up for searching for more of your great post.
kajal hot