大家好,本人初学mysql出现出现,麻烦大家帮忙看下是哪里出错,也希望能够写几个增。删。改。查的存储过程例子,谢了!
储存过程:
CREATE PROCEDURE `mysql`.`checkuser` (in name varchar(20))
BEGIN
delete FROM sqluser where username=name;
end错误:
mysql number 1034
PROCEDURE checkuser already exits!
储存过程:
CREATE PROCEDURE `mysql`.`checkuser` (in name varchar(20))
BEGIN
delete FROM sqluser where username=name;
end错误:
mysql number 1034
PROCEDURE checkuser already exits!
OR
加一句
drop procedure if exists checkuser
远程的例子是不是这样写
CREATE DEFINER=`root`@`192.168.0.1` PROCEDURE `111`(in name varchar(20))
BEGIN
delete from sqluser where username=name;
END