Posted by Siv Hansen on 10/22/05 15:23

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?

• Next in forum: Glitch in php or count() in mysql?
• Prev in forum: Re: image into mysql and out of mysql
• Thread view: procedures in mysql

[Reply to this message]