delimiter //
drop procedure if exists myprocedure;
create procedure myprocedure ()
begin
declare tablesql varchar(200);
set tablesql = CONCAT ('select * from','student');
prepare statement from tablesql;
execute statement;
end
//错在那里?
drop procedure if exists myprocedure;
create procedure myprocedure ()
begin
declare tablesql varchar(200);
set tablesql = CONCAT ('select * from','student');
prepare statement from tablesql;
execute statement;
end
//错在那里?
DROP PROCEDURE IF EXISTS myprocedure //
CREATE PROCEDURE myprocedure ()
BEGIN
SET @tablesql = CONCAT ('select * from','student');
PREPARE statement FROM @tablesql;
EXECUTE statement;
END //
DELIMITER ;
drop procedure if exists myprocedure//
create procedure myprocedure ()
begin
declare tablesql varchar(200);
set tablesql = CONCAT ('SELECT * FROM ','student');
set @s := tablesql;
prepare statement from @tablesql;
execute statement;
end
//
delimiter ;
结贴,感谢大神