It is very good.

Thanks, thats what I need :)

Dont we all love google :D

Hey that was simple I thought it wouldn't work but it did...

That did not work for me. Using MySQL 4.1.25.

thank you

thx a lot smarty

vey nice i'm impressed by the precise answer
keep it up
i wish i could get answers this way....
:-)

Giant of yours! thanks for the tip.

Thanks! Very straight to the point.

beautiful - thnx

Great Thx, simple but effective!

Very Impressive

thank you for this post, really helpful, and yes Senaia, thank God there's google :)

Thanks for the syntax and it is very useful for my learning ...

Thanks for the advice to "make sure that no one and no program are using this table before making the name change." Are there commands to do this? Could it possibly have been a joke, implying that we should telephone hundreds of users, email dozens of developers, make a list of who is logged on to what (which security people frown on doing), restrict logins for a week, and stop all processes? Doesn't the atomic nature of the rename mean that it is safe to update a second table, rename the first table to backup and the new table to the first table atomically?

Thanks! it worked!
Gracias! Funcionó!