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