How to Rename SQL Table Names (Urgent Please)

Hi there,

I want to know that how to rename the SQL table names with a command.

Any help will be highly appreciated.

Regards
bushib

 

RENAME TABLE first_name TO second_name;

 

Hi,

I used the same command but it don't work.

I exported the database and changed the table names. Now When I import the database it gives me the error.

Any help please.

Thanks
bushib

 

Can you try this;
ALTER TABLE first_name RENAME TO second_name;

 

Hi there,

I tried it too but it generate the following error.

"Error

SQL query:

ALTER TABLE

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 "

Any help?

Regards
bushib

 

Select the table you want to change, go to operations, then go the the form table "Table options" then just change the name.

 

Hi,

I created the table by running SQL Query.

So there is no such option to select the table.

The only way to change the name is through command but no command seems to change the name of the table.

I get error when I try to change it through command.

Any help please.

Thanks
bushib

 

Are you sure?
i just found this...
http://www.electrictoolbox.com/rename-table-mysql/
You may understand now.

 

hi,

In PhyMyAdmin > Database > Operations, there is only option for renaming the database and not for the table.

Actually, I created the tables in question with command.

And

This command also don't work RENAME TABLE tablename TO tablename_renamed and give errors.

I don't know how to fix this problem.

Any more help please.

Regards
bushib

 

before running the command Check the privileges if it is not a Root user and try again

 

You have to actually go to the table you want to rename, when you click that you'll see browse, insert and so on click on operations on there.

phpmyadmin > database > table > operation