[Tutor] unable to insert data into database

[Wolfram Kraus]

Servando Garcia wrote:
> 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))
> 
> 
First of all: Does the database "tutorial" exists? Is there a table 
"horses" in that database?
Please show the complete error message you get. The code looks good so far.

HTH
Wolfram