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
解决方案 »
- 用批处理导入.sql
- 一个帐号可以针对不同的表设定权限不?比如帐户A对T1表可读写,对T2表只读?
- 如果用phpmyadmin删除了root用户会如何
- 如何实现模乎查询
- mysql与Access数据库连接问题
- 怎样让使用代理服务器来访问MYSQL网络数据库
- 请教: 两种不同的数据表结构设计, 到底哪个更好一点呢? 谢谢!!!
- Can't connect to MySQL server on .......' (10048)
- mysql死翘翘啦
- 我安装了一个mysql数据库在win2000server中,可是在服务中启动他却总是出错,请问为什么?
- 目前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 ;