procedures in mysql

procedures in mysql

am 22.10.2005 14:23:56 von Siv Hansen

I've recenty discovered that mysql has support for user defined procedures.

I'm trying to create a procedure to insert a user into table brukere
like this
mysql> delimiter // /* so that I can use ; in my procedure */

mysql>create procedure insertUser(
'username' in tinytext,
'password' in tinytext,
'niva' in tinytext
)
as
begin
insert into brukere (navn, passord, niva) values ('username',
'password', 'niva');
end
//
but I keep getting an error near "der hvor parameterlistingen begynner)

My mysql version is 4.1.13a

Can anyone give me a basic syntax for procedures with parameters, please?