George2 at 15:16, 25 February 2016

2016-02-25T15:16:53Z

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-25T12:07:08Z

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 = "SELECT * FROM EMPLOYEE \
WHERE INCOME > '%d'" % (1000)
try:
# Execute the SQL command
cursor.execute(sql)
# Fetch all the rows in a list of lists.
results = cursor.fetchall()
for row in results:
fname = row[0]
lname = row[1]
age = row[2]
sex = row[3]
income = row[4]
# Now print fetched result
print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \
(fname, lname, age, sex, income )
except:
print "Error: unable to fecth data"

# disconnect from server
db.close()

</source>

@@ Line 10: / Line 10: @@
 cursor = db.cursor()
-# Prepare SQL query to INSERT a record into the database.
+# Prepare SQL query to UPDATE required records
-sql = "SELECT * FROM EMPLOYEE \
+sql = "UPDATE EMPLOYEE SET AGE = AGE + 1
-       WHERE INCOME > '%d'" % (1000)
+                          WHERE SEX = '%c'" % ('M')
 try:
     # Execute the SQL command
     cursor.execute(sql)
-    # Fetch all the rows in a list of lists.
+    # Commit your changes in the database
-    results = cursor.fetchall()
+    db.commit()
-   for row in results:
-      fname = row[0]
-      lname = row[1]
-      age = row[2]
-      sex = row[3]
-      income = row[4]
-      # Now print fetched result
-      print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \
-             (fname, lname, age, sex, income )
 except:
-    print "Error: unable to fecth data"
+    # Rollback in case there is any error
 # disconnect from server
 db.close()
 </source>

Python update mysql - Revision history

George2 at 15:16, 25 February 2016

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