Hancı Forum

[code]

import MySQLdb

[/code]

Öncelikle mysql için importu gerçekleştiriyoruz.


[code]mysql_opts = {
'host': "localhost",
'user': "mein_user",
'pass': "mein_pw",
'db': "meine_db"
}
mysql = MySQLdb.connect(mysql_opts['host'], mysql_opts['user'], mysql_opts['pass'], mysql_opts['db']) [/code]


[code]mysql.apilevel = "2.0"
mysql.threadsafety = 2
mysql.paramstyle = "format" [/code]


[code]cursor = mysql.cursor()
cursor.execute("SELECT * FROM `products`")
products = cursor.fetchall() [/code]

[code]cursor.execute("SELECT `id`, `name` FROM `customers` WHERE `product_id`=%s", products[0][0])
customer = cursor.fetchone() [/code]

http://www.online-tutorials.net/mysql/mysql-zugriff-mit-python/sourcecodes-t-130-316.html