[Tutor] unable to insert data into database
Servando Garcia
garcia.servando at gmail.com
Fri Feb 17 14:06:29 CET 2006
Hello to all
I have been trying to insert data into a database using MySQLdb
with no success. I have no idea why this script is not working. I took
it from a tutorial from DEV Shed.
#!/usr/bin/python
import MySQLdb
# connect
db = MySQLdb.connect(host="localhost", user="root",
passwd="******",db="tutorial")
# create a cursor
cursor = db.cursor()
#User Input
name = raw_input("Please enter a name: ")
color = raw_input("Please enter a color: ")
#Insert data into table "Horses"
cursor.execute("INSERT INTO horses(Names,Color) VALUE (%s,%s)",(name,color))
More information about the Tutor
mailing list