Hi All,
I was to rename a table as below
set @t_name=now();
rename table amc to concat('amf_',t_name);
but i am getting below error. How do i fix this.
ERROR 1064 (42000): 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 'concat('amf_',t_name)' at line 1
I can do the same using unix script, but just wanted to check if i can do
this in mysql itself.
regards
anandkl
