请问如何在存储过程中使用变量、表名
DECLARE record_num INT default 0;set @sqlselect = concat("SELECT count(*) into @record_num FROM ",
table_name,
" WHERE trade_date = '",
ptrade_date,
"' AND trade_time = '",
ptrade_time,
"';");
prepare stmt from @sqlselect;
execute stmt;
DEALLOCATE PREPARE stmt;
---上面sql语句用于存储过程。每次执行record_num都是缺省值0。应该怎样写才能正常?谢谢。
页:
[1]