我已经试过两种方式了,都行不通.方式一:
declare stmt varchar(500);
set @sqlstr=concat('SELECT * from ',tableName);
prepare stmt from @sqlstr;
DECLARE cursorTest CURSOR FOR execute stmt;
方式二:
set @sqlstr=concat('DECLARE cursorTest CURSOR FOR SELECT * FROM ',tableName,';');
prepare stmt from @sqlstr;
execute stmt;
DEALLOCATE PREPARE stmt;
declare stmt varchar(500);
set @sqlstr=concat('SELECT * from ',tableName);
prepare stmt from @sqlstr;
DECLARE cursorTest CURSOR FOR execute stmt;
方式二:
set @sqlstr=concat('DECLARE cursorTest CURSOR FOR SELECT * FROM ',tableName,';');
prepare stmt from @sqlstr;
execute stmt;
DEALLOCATE PREPARE stmt;
解决方案 »
- 请教各路高手:MySQL的Explain结果中Extra为空值代表什么意思?
- 如何在查不到数据的时候使用默认值?
- mysql数据库提问
- win 下mysql的数据如何移植到linux 下mysql?
- MYSQL 流量监测问题
- 哪儿有关于java与mysql联接的资料
- postgresql中有沒有語句修改表字段的數據類型?
- MySql有OLE DB的驱动吗?哪有下载的?MySql站点上好像只有ODBC的!急...
- 如何在linux下配置mysql-jdbc,以及在那里下载?
- 虚拟机乌班图下my.cnf无法修改
- Cannot convert value '0000-00-00 00:00:00' from column 37 to TIMESTAMP.
- Mysql 数据导入执行的时间差 (比较诡异!!!)求大家帮忙解决 谢谢各位了
set @sqlstr=concat( 'create table tt as SELECT * FROM ',tableName, '; ');
prepare stmt from @sqlstr;
execute stmt;
DEALLOCATE PREPARE stmt;.....