56,687
社区成员
发帖
与我相关
我的任务
分享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上面，请问怎么改啊
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
select * from user where username = named;
END
如上面所示，现在添加报语法错误！
问题在最后一条select上面，请问怎么改啊
...全文
请发表友善的回复…
发表回复
wolfwu_kg5 2012-03-08
- 打赏
- 举报
varchar没定义长度吧 把varchar改成varchar(20)试试
mysql> delimiter //
mysql> create procedure proc_stud (stud varchar(20))
-> begin
-> select * from stud where students = stud;
-> end//
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter //
mysql> create procedure proc_stud (stud varchar(20))
-> begin
-> select * from stud where students = stud;
-> end//
Query OK, 0 rows affected (0.00 sec)
feicanfly 2012-03-08
- 打赏
- 举报
楼上上正解，需要加长度
feicanfly 2012-03-08
- 打赏
- 举报
自己已解决
谢谢大家
谢谢大家
wwwwb 2012-03-08
- 打赏
- 举报
DELIMITER $$
CREATE PROCEDURE `dsf`(named VARCHAR(10))
BEGIN
SELECT * FROM `user` WHERE username = named;
END$$
DELIMITER ;
CREATE PROCEDURE `dsf`(named VARCHAR(10))
BEGIN
SELECT * FROM `user` WHERE username = named;
END$$
DELIMITER ;
