MySQL Forums :: Newbie :: Adding columns to live tables


Advanced Search

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 Dave S 03/07/2011 12:35AM
Re: Adding columns to live tables Rick James 03/08/2011 09:11AM
Re: Adding columns to live tables Dave S 03/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.