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))
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
