mysql 存储引擎如何传字符串参数

mysql 存储引擎怎么传字符串参数

CREATE DEFINER = `root`@`localhost` PROCEDURE `sanguo`.`dsf`(named varchar)

LANGUAGE SQL

NOT DETERMINISTIC

CONTAINS SQL

SQL SECURITY DEFINER

COMMENT ”

BEGIN

select * from user where username = named;

END

如上面所示，现在添加报语法错误！

问题在最后一条select上面，请问怎么改啊

DELIMITER $$

CREATE PROCEDURE `dsf`(named VARCHAR(10))

BEGIN

SELECT * FROM `user` WHERE username = named;

END$$

DELIMITER ;