|
Topic review - MySql rename table
| Author |
Message |
|
Post subject: Re: MySql rename table |  Posted: Mon Nov 28, 2011 3:39 am |
|
|
You can try to do exact same thing with Information_Schema.Columns table
Something like
select concat('rename table ', column_name, ' to ' , lower(column_name) , ';')
from information_schema.columns where table_schema = 'your_schema_name';
You can try to do exact same thing with Information_Schema.Columns table
Something like
select concat('rename table ', column_name, ' to ' , lower(column_name) , ';')
from information_schema.columns where table_schema = 'your_schema_name';
|
|
|
|
| Post subject: Re: MySql rename table | Posted: Sun Nov 13, 2011 2:01 pm |
|
|
If the table's name happens to use special mysql characters ( like percentage char %), enclose the table name as follows: Code: mysql> rename table `%TABLE_PREFIX%email` to email;
Query OK, 0 rows affected (0.02 sec)
If the table's name happens to use special mysql characters ( like percentage char %), enclose the table name as follows:
[code]mysql> rename table `%TABLE_PREFIX%email` to email;
Query OK, 0 rows affected (0.02 sec)
[/code]
|
|
|
|
| Post subject: MySql rename table | Posted: Wed Feb 02, 2011 6:15 pm |
|
|
To rename a mysql table from old_name to new_name, command is: Quote: mysql> RENAME TABLE old_name TO new_name To rename a mysql table from old_name to new_name, command is:
[quote]mysql> RENAME TABLE old_name TO new_name[/quote]
|
|
|
  News  Site map  SitemapIndex  RSS Feed Channel list
|
|
