存储过程的alter 不能使用变量吗

ytjwt

存储如下：

while i<=@outweek
do
set @weekname=i;
alter table weekstock add  @weekname int(5);
set i=i+1;
end while;

报这个错
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@weekname int(5);

难道在存储过中，alter是不能增加带有变量的列么

cccxxx

这样说不是很清楚,楼主能把整个存储过程贴出来吗

cccxxx

或者可以用这样的形式   
SET @SqlCmd ="update data_index SET Edit_date = UNIX_TIMESTAMP()";

      SET @SqlCmd = CONCAT(@SqlCmd , ',Keywords = ?');
      SET @a = 1_keywords;
      SET @SqlCmd = CONCAT(@SqlCmd , ' WHERE Pid=?');
      SET @b = id;
      PREPARE stmt from @SqlCmd;
      EXECUTE stmt USING @a,@b;

ytjwt

谢谢你，我就是这样解决的
set @weekname=i;
set @stmt=concat('alter table weekstock add week',@weekname,' int(5)');
prepare s1 from @stmt;
      execute s1;
      deallocate prepare s1;