Re: Returning a Value from a Stored Procedure

2006-10-08 Thread Gabriel PREDA
Let's suppose you have a table `t` with these columns: id -> auto increment, primary key, not null a b c N If you do any of these: INSERT INTO `t` (a, b, c ..., K) VALUES(va, vab, vc, ... vK); INSERT INTO `t` (id, a, b, c ..., K) VALUES(0, va, vab, vc, ... vK); INSERT INTO `t` (id, a, b, c .

Returning a Value from a Stored Procedure

2006-10-08 Thread Greg Lindstrom
Hello- I am running MySQL 5.0 on Windows XP hitting it from Python (2.4) routines. I have an id column (auto increment, primary key) on every table that I use to join other tables. I use stored procedures to insert new records into each table and would like to know how to return the id value of t