avete ragione.... copiato ed incollato codice e errore....

Stored Procedure:
codice:
DELIMITER $$

DROP PROCEDURE IF EXISTS `mysql`.`Prova`$$
CREATE PROCEDURE `mysql`.`Prova` ()
BEGIN
	DECLARE errore BOOLEAN DEFAULT FALSE;
	
	SET AUTOCOMMIT = 0;
	
	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET errore = TRUE;	
		
	
	DROP DATABASE IF EXISTS db_prova;
	CREATE DATABASE db_prova;
	CREATE TABLE db_prova.pdc (nome char(10), cognome char(10));
	INSERT INTO db_prova.pdc SELECT * FROM db_old.pippo;
	
	
	IF errore THEN ROLLBACK; ELSE COMMIT;
	END IF;

END; $$

DELIMITER ;
Errore:
codice:
Error while execeuting query: CREATE PROCEDURE `mysql`.`Prova` ()
BEGIN
	DECLARE errore BOOLEAN DEFAULT FALSE;
	
	SET AUTOCOMMIT = 0;
	
	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET errore = TRUE;	
		
	
	DROP DATABASE IF EXISTS db_prova;
	CREATE DATABASE db_prova;
	CREATE TABLE db_prova.pdc (nome char(10), cognome char(10));
	INSERT INTO db_prova.pdc SELECT * FROM db_old.pippo;
	
	
	IF errore THEN ROLLBACK; ELSE COMMIT;
	END IF;

END; :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET errore = TRUE;	
		
	
	DROP DATABAS' at line 7 (errno: 1064)
Click 'Ignore' if you'd like to have this error ignored until the end of the script.
Versione Server Mysql : 5.0.32 @ Debian

EDIT: visto ora reply...provo e vi dico