MySQL Forums
Forum List  »  Newbie

Adding columns to live tables
Posted by: Dave S
Date: March 07, 2011 12:35AM

Hello,

I'm using phpMyAdmin to administer a MySQL database on a hosted account.

My question is: are there any "gotchas" that I should watch out for when I want to add a new column to an existing table that is live and potentially in use? (99.9% of the access to it is reading only)

Specifically, I'll be looking to add a non-indexed integer column after the last column, with a default value of 0. I know *how* to do this using both a SQL statement and the phpMyAdmin utility, but my question is whether or not I need to do anything special/extra, seeing as how it's a live table, or whether there are advantages to using the phpMyAdmin utility over a raw SQL statement, etc.

Thanks!
Dave

Options: ReplyQuote


Subject
Written By
Posted
Adding columns to live tables
March 07, 2011 12:35AM
March 17, 2011 11:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.