drop PROCEDURE IF EXISTS addColumn;
delimiter //
CREATE PROCEDURE addColumn()
begin
declare _SQL varchar(800);
DECLARE Done INT DEFAULT 0;
DECLARE table__Name varchar(100);
DECLARE rs CURSOR for select concat('adapter_metadata_',version) aaa from adapter_scheme_version;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET Done = 1;
OPEN rs;
REPEAT
Fetch rs Into table__Name;
set _SQL =concat('ALTER TABLE ',table__Name,' ADD COLUMN `adapter_info` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '\0\' COMMENT \'适配情况(0未适配,1疑似适配,2完全适配)\' AFTER `adapter_dict_id`') ;
set @_SQL=_SQL;
PREPARE statm from @_SQL;
EXECUTE statm;
FETCH NEXT FROM rs INTO table__Name;
UNTIL Done END REPEAT;
CLOSE rs;
END
//
delimiter ;
请问这是哪里有错?要怎么修改?