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 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, if you use the MySQLdb driver for DB-API, yes, you should be able to convert it to use other drivers relatively easily. There are some differences between drivers, such as variation in connect parameters, and in placeholder syntax.
That approach will really help, thanks.
Eric Pederson
P.S. 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.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
