stored prcedures giving me the blues

[sd0t1]

I'm new to stored procedures. I found plenty of tutorials, but not any really good ones that started from beginner lever and worked indepth enough or either to indepth and assumed I knew more than I know.

I'm not sure what I'm doing wrong here.

delimiter //
CREATE PROCEDURE showUser(
in jistag varchar(10),
out user varchar(40))
begin
SELECT * FROM master
WHERE jis_tag = jistag
INTO user;
END //

it's stored ok, but when I call it I get this error.

Unknown column '?????' in 'field list'

any ideas??

 

[DonQuichote]

What are you trying to do? You are trying to put more than one value into one variable? Supply the field name that holds the user name. How else can MySQL know which field to use?

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)