Re: Python API ...

2004-01-07 Thread EP
. In absence of this kind of technique I was struggling with the idea of multiple "SELECT FROM's" within a single "INSERT" (is that even possible?) I'm not sure what you mean here. Will something like this work (with a correction of syntax which is unknown to me)? INSERT INTO webpages(autho

Re: Python API ...

2004-01-07 Thread EP
. In absence of this kind of technique I was struggling with the idea of multiple "SELECT FROM's" within a single "INSERT" (is that even possible?) I'm not sure what you mean here. Will something like this work (with a correction of syntax which is unknown to me)? INSERT INTO webpages(autho

Re: Python API ...

2004-01-07 Thread Paul DuBois
d strategy advice. Is the Python API mentioned: seq1=cursor1.insert_id() MySQLdb? MySQL Cookbook covers Perl DBI, PHP, Python DB-API (MySQLdb), and JDBC. Or another specific Python-MySQL API? [Should it be applicable to any Python Database API Specification v2.0 API ?] In general,

Python API ...

2004-01-07 Thread EP
Paul DuBois wrote: By the way, you may want to visit http://www.kitebird.com/mysql-cookbook and grab a copy of the "recipes" distribution. In net style led me to: http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index2.html?page=1 Much appreciated strategy advice. Is the