Click here to Skip to main content
12,943,367 members (76,778 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
hi i am trying to rename my SQL table i.e audit to Audit, but its not working. i am using MYSQL workbench IDE, pls help ASAP
Posted 17-Jan-13 0:13am
Updated 17-Jan-13 0:27am
v2
Comments
d@nish 17-Jan-13 6:21am
   
What do you mean by not working? Are getting some error?
Tejas Vaishnav 17-Jan-13 6:27am
   
Use proper tags while posting question.
inguva suryanarayana 18-Jan-13 1:06am
   
its nt showing any error but i am unable to rename it.
inguva suryanarayana 18-Jan-13 1:07am
   
my Q is related to MySQL and SQL only naa that's y i tagged them WATS wrong?
Tejas Vaishnav 18-Jan-13 2:09am
   
You are taging SQL and SQLServer i change them to SQL and MySQL
inguva suryanarayana 20-Jan-13 23:52pm
   
OK thank u
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

use this
mysql> ALTER TABLE orig_name RENAME new_name;
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 4,643
CHill60 2,930
Maciej Los 2,328
Jochen Arndt 1,900
ppolymorphe 1,765


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100