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上面,请问怎么改啊
CREATE PROCEDURE `dsf`(named VARCHAR(10))
BEGIN
SELECT * FROM `user` WHERE username = named;
END$$
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)