Jump to content


Photo

change table name


  • Please log in to reply
3 replies to this topic

#1 Gaia

Gaia
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts
  • LocationCanada

Posted 09 October 2005 - 06:07 PM

hey,

How can i change a tables name? I noticed that hte option isn't avialable in phpMyAdmin.

Thanks.

#2 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 09 October 2005 - 06:09 PM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]RENAME TABLE `table_original` TO `table_new` [!--sql2--][/div][!--sql3--]

MySQL manual for RENAME TABLE
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#3 Zane

Zane
  • Administrators
  • Advanced Member
  • 4,134 posts

Posted 09 October 2005 - 07:53 PM

I noticed that hte option isn't avialable in phpMyAdmin.

View Post


It should be

Choose the table in particular and choose the Operations tab...it should be there

btn_donate_SM.gif Want to thank me? Contribute to my PayPal piggy-bank
 

172938.png

#4 Gaia

Gaia
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts
  • LocationCanada

Posted 09 October 2005 - 11:36 PM

ah never looked there before :P

Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users