Re: about getting the auto increment to work in stored procedure

[Bob Smith]

I had no problem with this:

INSERT INTO users VALUES (null,'Jamie','Smith','oreo','[e-mail]','34 young street' );
SELECT LAST_INSERT_ID();

it work but when dealing with stored procedure I've tried:

DELIMITER go
Create procedure addusers(
Out UserID int(11),
IN FirstName varchar(10),
IN LastName varchar(10),
IN Password varchar(10),
IN EmailAddress varchar(10),
IN HomeAddress varchar(20)
BEGIN
insert into users(

FirstName,
LastName ,
Password ,
EmailAddress,
HomeAddress
)
Values
(
FirstName,
LastName ,
Password ,
EmailAddress ,
HomeAddress
)
set @UserID = null;

End
go
DELIMITER ;

and using
call addusers(

'Jamie',
'Smith',
'oreo',
'[e-mail]',
'34 young street',@UserID);
select @UserID;

I got an error that says:
#1318 - Incorrect number of arguments for PROCEDURE JonesCorp.addusers; expected 6, got 5"

I even tried:

call addusers(

'Jamie',
'Smith',
'oreo',
'[e-mail]',
'34 young street');
select @UserID;

and I still got the same error that says: #1318 - Incorrect number of arguments for PROCEDURE JonesCorp.addusers; expected 6, got 5"