56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> set @sqlstr = concat('create table TABLE_',date_format(curdate(),'%Y%m%d'),' (id int)');
Query OK, 0 rows affected (0.00 sec)
mysql> PREPARE stmt1 FROM @sqlstr ;
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> EXECUTE stmt1 ;
Query OK, 0 rows affected (0.08 sec)
mysql> show tables like 'table_%';
+--------------------------+
| Tables_in_test (table_%) |
+--------------------------+
| table_20090506 |
+--------------------------+
3 rows in set (0.00 sec)
mysql>