读书人

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

发布时间: 2012-04-07 17:31:52 作者: rapoo

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 ;

读书人网 >Mysql

热点推荐