create procedure testproc()
delete from xxx
select a,b,c from xxx
上面这么写就不对?说语法错误,我想写个MYSQL存储过程先清除表数据,再插入新数据到此表里,再SELECT查询出来呢?
delete from xxx
select a,b,c from xxx
上面这么写就不对?说语法错误,我想写个MYSQL存储过程先清除表数据,再插入新数据到此表里,再SELECT查询出来呢?
begin
delete from xxx ;
insert xxx select 'a','b','c';
select a,b,c from xxx ;
end //
begin
delete from xxx;
insert into xxx values(1,2,3);
select a,b,c from xxx ;
end;
create procedure testproc()
begin
truncate table xxx ;
insert xxx select 'a','b','c';
select a,b,c from xxx ;
end //
create procedure testproc()
begin
delete from table xxx ;
insert into xxx(a,b,c) values (1,2,15) ;
select a,b,c from xxx ;
end //
delimiter ;
建议查一下MYSQL的官方文档的语法格式和例子。http://dev.mysql.com/doc/refman/5.1/zh/stored-procedures.html#create-procedure
1:定界符
2:你的“;”呢?
3:begin.....end;
delimiter //
drop procedure if exists proctest//
create procedure proctest()
begin
delete from xxx;
select * from xxxx;
end;
//
delimiter ;