Batch Script

[Lourenço de Paula]

Hi,

In my database I've a table with a field that control de version of may tables, now I 
need to make a script to update my tables and I would like to make something like that:

DECLARE
  i number;
BEGIN
  select version into i from mytable;
  if version = 1 then
    create table... 
    insert into...
  else
    drop table
END;

I'm using MySQL 4.0.18-max-nt, Have I any way to do it?

Any help will be usefull

Thanks.
Lourenço de Paula