delimiter //
create procedure oneKey(in newName varchar(250),in oldName varchar(250),in idNum INT)
BEGIN
SET @sqlStmt = CONCAT('insert into ',newName,' (`name`,`age`,`sex`,`major`,`pass`,`photo`)
select `name`,`age`,`sex`,`major`,`pass`,`photo` from ',oldName,' where id = ',idNum);
PREPARE stmt FROM @sqlStmt;
EXECUTE stmt;
END;
//
delimiter ;
call oneKey('stu1','student',5);delimiter //
create procedure oneKey(in new