Revision [1481]

Last edited on 2010-07-09 13:55:20 by KlenwellAdmin
Additions:
db.close()

Revision [1480]

Edited on 2010-07-09 13:51:06 by KlenwellAdmin
Additions:
===Select Query===
Deletions:
===Select Queries===

Revision [1479]

Edited on 2010-07-09 13:50:35 by KlenwellAdmin
Additions:
import MySQLdb
# set or replace constants
db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASS, db=DB_NAME)
import MySQLdb
db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASS, db=DB_NAME)
c = db.cursor()
c.execute("""SELECT * FROM table WHERE condition = 1""")
rows = c.fetchall()
print type(rows), rows
c.close()

Revision [1477]

The oldest known version of this page was created on 2010-07-09 10:45:24 by KlenwellAdmin
Valid XHTML 1.0 Transitional • Valid CSS • WikkaWiki