Click here to Skip to main content
14,982,471 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have this code for inserting values in mysql database in python, its bringing no error yet not inserting. Please help,,

import MySQLdb;

connect=MySQLdb.Connect('localhost','root','','company');
cursor=connect.cursor();


def createTable():
try:
cursor.execute('DROP TABLE IF EXISTS EMPLOYEE');
sql="""CREATE TABLE IF NOT EXISTS EMPLOYEE
(id INT(11) NOT NULL AUTO_INCREMENT , firstname
CHAR(20) NOT NULL, lastname CHAR(20) NOT NULL, age INT(3) NOT NULL,
sex CHAR(1),income FLOAT, PRIMARY KEY(id) )""";
cursor.execute(sql);
connect.commit()
except:
connect.rollback()

def insertValues():
query="INSERT INTO Employee(id, firstname, lastname, age,sex, income) VALUES (1,'Stanley','Nguma',22,'M',70000)";
try:<big></big>
cursor.execute(query);
connect.commit;
print "The employee has been inserted successfully";
except MySQLdb.Error, e:
print "There is an error ", e;
connect.rollback;

#createTable();
insertValues();
connect.close()
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900