Hi,
As Paul said, since concat gives a string, you can use this fact in preparing
statement (v4.1). This works fine for me :
But use replace to change '-' to '_' in the table_name.
set @tt:=concat('rename table flows_2005_05_27 to ',CONCAT("flows_",
replace(DATE_SUB(CURDATE(), interval 2 day),'-','_')),';');
select @tt;
mysql> show tables like 'flow%';
+-------------------------+
| Tables_in_world (flow%) |
+-------------------------+
| flows_2005_05_27 |
+-------------------------+
1 row in set (0.00 sec)
mysql>
mysql> set @tt:=concat('rename table flows_2005_05_27 to ',CONCAT("flows_",
replace(DATE_SUB(CURDATE(), interval 2 day),'-','_')),';');
mysql> prepare stmt from @tt;
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> execute stmt ;
mysql> deallocate prepare stmt;
mysql> show tables like 'flow%';
+-------------------------+
| Tables_in_world (flow%) |
+-------------------------+
| flows_2005_05_26 |
+-------------------------+
1 row in set (0.00 sec)
Mathias
Selon Paul DuBois <[EMAIL PROTECTED]>:
> At 11:00 -0400 5/28/05, Jason Dixon wrote:
> >On May 28, 2005, at 8:51 AM, Paul DuBois wrote:
> >
> >>At 8:12 -0400 5/28/05, Jason Dixon wrote:
> >>>I'm trying to rename some tables for archival, but the table
> >>>renaming is failing when I use CONCAT() to form the table string
> >>>name:
> >>
> >>CONCAT() produces a string, not an identifier.
> >
> >Fine. Is there any way to do this in MySQL or do I need to fall
> >back on my Perl? It's not a big deal, I'm just curious now.
>
> Perl. Construct the table identifier and place the result into your
> SQL statement, then execute the statement.
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
