Help

[nagarjuna_kotha]

Hi All,

I have extracted data from MySQL ,after loading data from Databade i got some synthatic keys i need renamed it to avoid those sythatic keys.But what i want is i dont want to rename it my script i want it in database itself.How to do that?

Can anyone help me on this.....

Its Urgent>>>>>>>>>>>>>>>>>.

Regards

Nag

[#2]

Try something like this

ALTER TABLE "table_name" CHANGE "old_column_name" "new_column_name" DATATYPE;


But this will change your database in SQL, so not something to be done lightly.

[MayilVahanan]

Hi

If you need to change the name in database itself. You need to have rights for that.

sql - How to rename a table column in MySQL - Stack Overflow

Or, you can rename in qv itself.