This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Rename table's name using MySQL Data Base Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Rename table Watch "Rename table New topic
Author

Rename table's name using MySQL Data Base

André Asantos
Ranch Hand

Joined: Nov 23, 2009
Posts: 234
hello,
anybody else can help me saying the way to rename the table's name "user" to "users" using the MySQL sintax... ???

thanks,
André AS


André AS
Rose Rimsky
Greenhorn

Joined: Feb 10, 2010
Posts: 25
Hi André, the command you should use in order to rename a table, is actually RENAME. Check this page to see the complete syntax, I'm sure this will help you


Fairy tales are more than true: not because they tell us that dragons exist, but because they tell us that dragons can be beaten. – G.K. Chesterton
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36478
    
  16
Moving to our databases forum, where we usually discuss such questions.
André Asantos
Ranch Hand

Joined: Nov 23, 2009
Posts: 234
really thanks...

AS
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Rename table's name using MySQL Data Base
 
Similar Threads
Use PL/SQL Loop and variable
MySQL database connection using DataSource + Context or Initial Context
how can i create war file in unix
JTable and combobox as the cellEditor
how can i create war file in unix