Re: MySQL Stored Procedures

[Per-Erik Martin]

First of all, the procedure should be:

create procedure proc()
begin
declare count int;
select max(num) into count from table1;
delete from table1 where num <= count-5;
end

This works for me. The error you're getting suggest that you might be using an older version of 5.0.

pem, Senior Software Dev., MySQL AB