MySQL数据库存储过程动态表建立(PREPARE)_MySQL

这是我项目当中用到的，用作参考使用：

DELIMITER $$DROP PROCEDURE IF EXISTS `gpsdata`.`sp_test`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`(	gpstime_ varchar(128),	gpsname_ varchar(128),	gpsinfo_ varchar(256))BEGINDECLARE tbname varchar(50) DEFAULT  &＃39;0&＃39;;DECLARE v_sql varchar(1024) DEFAULT &＃39;0&＃39;;SET v_sql=CONCAT(&＃39;select * from  &＃39;, tbname ,&＃39; where gpsname = &＃39;,gpsname_,&＃39;  order by gpstime desc limit 1&＃39;);SET @lastdata = v_sql;PREPARE lastdata FROM @lastdata;   EXECUTE lastdata;DEALLOCATE PREPARE lastdata;  select v_sql;END$$DELIMITER ;