[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