import MySQLdb
db = MySQLdb.connect (host = "localhost", user="pikasphp", passwd="merakas", db="pikasphp_web")

Užklausa, rezultatai

cursor = db.cursor()
cursor.execute("SHOW TABLES")
result = cursor.fetchall()
for record in result:
	print record[0], "-->", record[1]

Kiek eilučių

# get the number of rows in the resultset
numrows = int(cursor.rowcount)
# get and display one row at a time
for x in range(0,numrows):
  row = cursor.fetchone()
  print row[0], "-->", row[1]

Kiek rezultatų spausdinti

# limit the resultset to 3 items
result = cursor.fetchmany(3)
# iterate through resultset
for record in result:
  print record[0] , "-->", record[1]

Paskutinio įrašo ID

# get ID of last inserted record
print "ID of inserted record is ", int(cursor.insert_id())

Keletas panašių užklausų

# dynamically generate SQL statements from  list
cursor.executemany("INSERT INTO animals (name, species) VALUES (%s,
%s)", [  ('Rollo', 'Rat'),  ('Dudley', 'Dolphin'),  ('Mark', 'Marmoset')

In this case, the same query is repeated multiple times, with a different set of values each time. The values for each iteration are provided to the executemany() method as a Python list; each element of the list is a tuple containing the values for that iteration.

Kiti MySQLdb klasės metodai

  • connection.begin() - start a transaction
  • connection.apilevel() - returns the current DB API level
  • connection.conv() - set type conversion options between MySQL and Python
  • connection.commit() - commit a transaction
  • connection.rollback() - roll back a transaction


This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information
Jei nenurodyta kitaip, šio wiki turinys ginamas tokia licencija: CC Attribution-Noncommercial-Share Alike 4.0 International
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki