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
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
Please Sign up or sign in to vote.

Solution 1

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

Solution 2


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