By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,660 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,660 IT Pros & Developers. It's quick & easy.

insert the values into the database using python.

P: 8
Good Morning All,

I'm doing a small application using python and MySQL. I'm connecting the database and also creating a table using python application. But, I cannot Insert the values into the table. Can anyone help me to insert the values into the table.
I use the command to insert the values are as follows:

"Insert into custreg (First_Name,Middle_Name,Last_Name,Month,Day,Year,G ender,Address,City,Pin,State,Phone) values ('&fn','&mn','&ln','&month','&day','&year','&gende r','&add','&city','&pin','&state','&phone')"
Advance Thanks for helping me...
Warm Regards,

Mar 11 '09 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,851
I have never used MySQLdb, but after looking at some online documentation for a few minutes, I think your code should look like this:
Expand|Select|Wrap|Line Numbers
  1. import MySQLdb
  2. db = MySQLdb.connect(passwd="something",db="whatever")
  3. c = db.cursor()
  4. c.execute(
  5.     """INSERT INTO custreg (First_Name,Middle_Name,Last_Name,Month,Day,
  6.     Year,Gender,Address,City,Pin,State,Phone)
  7.     VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)""",
  8.     (fn,mn,ln,month,day,year,gender,add,city,pin,state,phone))
Note that last tuple must be valid Python identifiers.
Mar 11 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.