Re: [SQL] Return Primary Key from Procedure

2002-07-25 Thread Richard Huxton
On Wednesday 24 Jul 2002 3:12 pm, Peter Atkins wrote: > All, > > I have two tables t_proj, t_task see below: > > CREATE TABLE t_proj ( > proj_id INT NOT NULL AUTO_INCREMENT, > PRIMARY KEY (proj_id), > task_id integer(12), > user_id integer(6), > title varchar(35), > description varchar(80) > ); >

[SQL] Return Primary Key from Procedure

2002-07-24 Thread Peter Atkins
All, I have two tables t_proj, t_task see below: CREATE TABLE t_proj ( proj_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (proj_id), task_id integer(12), user_id integer(6), title varchar(35), description varchar(80) ); CREATE TABLE t_task ( task_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (task_