Noah,
Try something like:
insert into author
(id, name, sort_name, email, bio, initials)
values
(null,
,
,
,
,
)
select LAST_INSERT_ID()
hth
Phil
[EMAIL PROTECTED]
- Original Message -
From: "Noah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunda
multiple non-select statements (max 1 select) are done through the use
of
kapil
Noah wrote:
>
> Hi,
>
> I'm using MySQL. I need to have a ZSQL Method that does an insert and a select in
>one call.
> After I do an insert I need to check the LAST_INSERT_ID to get the primary key of the
> rec