mysql-Front总是报错。
use newssys
create PROCEDURE addCategory(in categoryName varchar(20),in owner varchar(20), out staus int)
begin
set staus=0;
start transaction
insert into newscategory(categoryName,owner) values(categoryName,owner);
set @userName=select userName from newsowner where userName=owner;
set @userPass=select userPass from newsowner where userName=owner;
set @total=select total from newsowner where userName=owner;
set @categoryId=select max(id) FROM newscagegory ;
set @loginNum=select loginNum from newsowner where userName=owner;
set @picture=select picture from newsowner where userName=owner;
insert into newsowner(userName,userPass,total,categoryId,picture) values(@userName,@userPass,@total,@categoryId,@loginNum,@picture);
set staus=1;
commit;
end
use newssys
create PROCEDURE addCategory(in categoryName varchar(20),in owner varchar(20), out staus int)
begin
set staus=0;
start transaction
insert into newscategory(categoryName,owner) values(categoryName,owner);
set @userName=select userName from newsowner where userName=owner;
set @userPass=select userPass from newsowner where userName=owner;
set @total=select total from newsowner where userName=owner;
set @categoryId=select max(id) FROM newscagegory ;
set @loginNum=select loginNum from newsowner where userName=owner;
set @picture=select picture from newsowner where userName=owner;
insert into newsowner(userName,userPass,total,categoryId,picture) values(@userName,@userPass,@total,@categoryId,@loginNum,@picture);
set staus=1;
commit;
end
解决方案 »
- 我这样修改mysql的root密码,为什么不行呢?
- 优化一条sql语句,常用sql的应该手到擒来。
- MYSQL WHERE+IN+ORDER BY 优化问题?
- 大侠!有事相求!关于sql的一个问题!急,在线等。
- 请问怎样导出mysql的自定义函数?
- 只有10分了,请各位见谅!
- 有读过postgresql源代码的高手吗?
- 请教条mysql语句
- mysql 更新数据并导出到文本文件
- MySqlCommand. Parameters.AddWithValue() 插入数据为null
- 目前mysql最稳定的是哪个版本呀?另外,各个版本的兼容性如何?
- 安装mysql时,出现注册帐号的提示,这一步可以跳过吗?有图,谢谢
delimiter ||
create PROCEDURE addCategory(in categoryName varchar(20),in owner varchar(20), out staus int)
begin
set staus=0;
start transaction;
insert into newscategory(categoryName,owner) values(categoryName,owner);
select @userName := userName from newsowner where userName=owner;
select @userPass := userPass from newsowner where userName=owner;
select @total :=total from newsowner where userName=owner;
select @categoryId := max(id) FROM newscagegory ;
select @loginNum := loginNum from newsowner where userName=owner;
select @picture := picture from newsowner where userName=owner;
insert into newsowner(userName,userPass,total,categoryId,picture) values(@userName,@userPass,@total,@categoryId,@loginNum,@picture);
set staus=1;
commit;
end||
delimiter ;