i have a database with table name like: satable1 satable2 satable3 satable4 satable5 and many in the same format now i want to make it like this patable1 patable2 patable3 patable4 patable5 and so on Is it possible with a single command pls help Thanks in advance
export the db from phpmysql admin . the edit the .sql file and replace the names of tables satable->patable import the db file again by first dropping all tables Regards Alex