Python insert into mysql - Revision history

George2 at 11:57, 25 February 2016

2016-02-25T11:57:46Z

George2 at 11:55, 25 February 2016

2016-02-25T11:55:24Z

George2: Created page with " #!/usr/bin/python import MySQLdb # Open database connection db = MySQLdb.connect("localhost","testuser","test123","TESTDB" ) # prepare a cursor objec..."

2016-02-25T11:52:55Z

Created page with "<source lang="python"> #!/usr/bin/python import MySQLdb # Open database connection db = MySQLdb.connect("localhost","testuser","test123","TESTDB" ) # prepare a cursor objec..."

New page

<source lang="python">
#!/usr/bin/python

import MySQLdb

# Open database connection
db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )

# prepare a cursor object using cursor() method
cursor = db.cursor()

# Prepare SQL query to INSERT a record into the database.
sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""
try:
# Execute the SQL command
cursor.execute(sql)
# Commit your changes in the database
db.commit()
except:
# Rollback in case there is any error
db.rollback()

# disconnect from server
db.close()

</source>

← Older revision		Revision as of 11:57, 25 February 2016
Line 58:		Line 58:


		+	</source>
		+
		+	Passing parameters directly<br>
		+
		+	<source lang="python">
		+	..................................
		+	user_id = "test123"
		+	password = "password"
		+
		+	con.execute('insert into Login values("%s", "%s")' % \
		+	(user_id, password))
		+	..................................
	</source>		</source>

@@ Line 25: / Line 25: @@
 # disconnect from server
 db.close()
 </source>