日期:2014-05-16  浏览次数:21124 次

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 ;