aspose file tools*
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 Java 8 in Action this week in the Java 8 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: 36579
    
  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
MySQL database connection using DataSource + Context or Initial Context
Use PL/SQL Loop and variable
how can i create war file in unix
JTable and combobox as the cellEditor
how can i create war file in unix