Python

Python RSS

Code to connect mysql through python

Please support our Python advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Apr 2008

Posts: 1

Reputation: krishnasaradhi is an unknown quantity at this point

Solved Threads: 0

krishnasaradhi krishnasaradhi is offline

Offline

Newbie Poster

Code to connect mysql through python

Apr 20th, 2008

hi,

i need the code to connect mysql through python programming language

•

Join Date: Jul 2006

Posts: 608

Reputation: jrcagle is on a distinguished road

Solved Threads: 150

jrcagle

Offline

Practically a Master Poster

Re: Code to connect mysql through python

Apr 20th, 2008

You'll need an interface module:

http://wiki.python.org/moin/DatabaseInterfaces

Pick your fave

Jeff

•

Join Date: May 2007

Posts: 311

Reputation: BearofNH is on a distinguished road

Solved Threads: 40

BearofNH

Offline

Posting Whiz

Re: Code to connect mysql through python

Apr 21st, 2008

Here's an example to get you started.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
import MySQLdb
 
conn = MySQLdb.connect (host = "nephews", user = "huey", passwd = "dewey", db = "louie")
cursor = conn.cursor ()
table_name = "kumquat"
 
nlines = cursor.execute ("DROP TABLE IF EXISTS " + table_name)
for x in range(nlines):
	print cursor.fetchone ()
cursor.close ()
 
tdesc  = "CREATE TABLE " + table_name + "("
tdesc  = tdesc + "IDseq INT(7) UNSIGNED,"
tdesc  = tdesc + "Protocol VARCHAR(8), "
tdesc  = tdesc + "Function VARCHAR(8), "
tdesc  = tdesc + "Threads INT(10) UNSIGNED, "
tdesc  = tdesc + "Speed DECIMAL(10,3) "
tdesc  = tdesc + ")"
cursor = conn.cursor ()
nlines = cursor.execute (tdesc)
for x in range(nlines):
	print cursor.fetchone ()
cursor.close ()
import MySQLdb

conn = MySQLdb.connect (host = "nephews", user = "huey", passwd = "dewey", db = "louie")
cursor = conn.cursor ()
table_name = "kumquat"

nlines = cursor.execute ("DROP TABLE IF EXISTS " + table_name)
for x in range(nlines):
	print cursor.fetchone ()
cursor.close ()

tdesc  = "CREATE TABLE " + table_name + "("
tdesc  = tdesc + "IDseq INT(7) UNSIGNED,"
tdesc  = tdesc + "Protocol VARCHAR(8), "
tdesc  = tdesc + "Function VARCHAR(8), "
tdesc  = tdesc + "Threads INT(10) UNSIGNED, "
tdesc  = tdesc + "Speed DECIMAL(10,3) "
tdesc  = tdesc + ")"
cursor = conn.cursor ()
nlines = cursor.execute (tdesc)
for x in range(nlines):
	print cursor.fetchone ()
cursor.close ()