Tables Rename

[alirezaok]

i have some tables. i want to add a perfix string to all of them.
it is dificult to rename them one by one.
is there any sloution or script to do it

[bogu]

This is a database question:

ALTER TABLE `table1` RENAME `table2` ;

[bradgrafelman]

What you could do is use a query like so:

SHOW TABLES FROM `database`;

Then, loop through the results and on each one issue an ALTER TABLE query as described by bogu.