hanks,
Matt
> -Original Message-
> From: Matt Chatterley [mailto:[EMAIL PROTECTED]
> Sent: 23 April 2004 02:08
> To: 'MySQL List'
> Subject: LAST_INSERT_ID() and Stored Procs
>
> Hi all.
>
> Another hiccup along the happy road with MySQL 5.0!
>
>
Hi all.
Another hiccup along the happy road with MySQL 5.0!
The last bit of a stored procedure I have just put together does this:
-- insert cluster row
INSERT INTO clusters (Name) VALUES (sName);
SELECT LAST_INSERT_ID() INTO iNewClusterID;
-- insert map row
INSERT INTO map (X, Y) VALUES (iX,iY
