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 ;