[Tutor] unable to insert data into database
kraus at hagen-partner.de
Fri Feb 17 14:24:04 CET 2006
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.
> import MySQLdb
> # connect
> db = MySQLdb.connect(host="localhost", user="root",
> # 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.
More information about the Tutor