[DB-SIG] Sample Code of Python/MySQL

Andy Dustman adustman@comstar.net
Wed, 21 Jul 1999 13:47:50 -0400 (EDT)

On Wed, 21 Jul 1999, M.-A. Lemburg wrote:

> Brad Stec wrote:
> > 
> > I'm putting in some examples of the various SQL commands and ways to get the
> > data.  Its really for complete novices... like me. :)  I decided that as I
> > learn it I might as well document it.
> > 
> > I'll send you what I get when I get it done.
> Could you put the examples on web-pages ? That way Andrew could link
> to it from the database topics guide on www.python.org.

That really would be better. All the DB API database modules work
basically the same. The two main exceptions to this are: A) the connect
method (very database dependent) and B) formatting of parameters into
query strings (same). For example, mxODBC (or perhaps, more accurately,
ODBC) uses a question mark to indicate where a parameter should be
substituted in, and MySQLdb uses %s, and some others use :1, :2, etc. 

andy dustman  | programmer/analyst |  comstar communications corporation
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d