MySQL Store Procedure with Parameters?

[random1]

I've got the SQL:

 

CREATE PROCEDURE `procedure_add_new_user`(IN `p_user_name` VARCHAR(50))
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'Adds a new user (registration) to the \'user\' table.'
BEGIN
/* Adds a new user (Registration) */

INSERT INTO `user` (`user_profile_id`, `user_avatar_id`,
`user_status`, `user_username`, `user_password`, `user_passphrase`,
`user_title`, `user_firstname`, `user_lastname`,
`user_datetime_utc_last_login`, `user_datetime_utc_created`,
`user_date_of_birth`)
VALUES (2, 1, 1, p_user_name,
'password',
'passphrase',
'Mr', 'Jacob', 'Mendlebury', UTC_DATE,
UTC_DATE,
'1984-08-12 00:00:00');

SELECT `user_id` FROM `user` WHERE `user_username` = p_user_name;

END

 

'p_user_name' is the parameter I've created and I am calling it using:

 

procedure_add_new_user('test');

 

It complains about syntax about an error on line 1 but I can't find an issue.

 

Any ideas?

[fenway]

Did you change the delimiter?

[random1]

I don't thinks so. Do you mean like:

 

http://dev.mysql.com/doc/refman/5.4/en/stored-programs-defining.html