Python API ...

[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 Python API mentioned:

seq1=cursor1.insert_id()

MySQLdb?

Or another specific Python-MySQL API?  [Should it be applicable to any 
Python Database API Specification v2.0  API ?]

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?)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Python API ...

[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(author_key, subject_key, title, description)
SELECT MAX(author_key) from authors,
SELECT MAX(subject_key), title, description, from subjects;  

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]