Is it possible to change the name of a table.

Do somebody knows a script for this, or something in MySQL?

Kind regards,

    mysql_db_query('databasename','rename table 'tablename' to 'newname');

      Originally posted by ramas
      mysql_db_query('databasename','rename table 'tablename' to 'newname');

      my god, let these people do some work for themselves.... a simple search for rename on mysql.com would have gotten him how to do it..... :rolleyes:

        try

        mysql> ALTER TABLE old_tbl_name RENAME new_tbl_name

          a month later

          Hi

          Is there a way to do multiple changes in the one DB, i.e. I have a DB that has 226 tables prefixed with AB and I want to chnage that to ab - i.e. lowercase.

          I have had a look at www.mysql.com for rename tables etc but could not locate anything on doing multiple name changes

          Thanks

          Greg

            Write a Reply...