On Mon, 2006-09-25 at 15:27 +0530, Mugunthan SIFY wrote: > If you have enough disk space, create a temporary table with the four new > columns. Insert into this table selecting records from the original table. > Finally rename the tables.
isn't this resource intensive? Then again, since the OP did already wait 24 hours, that must've loaded the server as well. > Hope this helps. > > Regards, > S.Mugunthan > > -----Original Message----- > From: Ehrwin Mina [mailto:[EMAIL PROTECTED] > Sent: Monday, September 25, 2006 12:35 PM > To: Helen M Hudson; MySQL List > Subject: Re: adding columns to a large table > > > At 12:53 PM 9/25/2006, Helen M Hudson wrote: > >I have a table with about 3million rows and I'm having trouble > >altering it to add 4 more columns. I'm using the MySQL > >Administrator and I've left it more than 24hours and its still not > >finished. I was going to try using a login to the console next, but > >is there a better way? Any advice much appreciated! > >Helen > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > Hi Helen, > > I would like to know what type of engine your using in mysql? > Is it mysisam or innodb? > > thank you, > > Ehrwin C. Mina > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > ********** DISCLAIMER ********** > Information contained and transmitted by this E-MAIL is proprietary to > Sify Limited and is intended for use only by the individual or entity to > which it is addressed, and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If this is a > forwarded message, the content of this E-MAIL may not have been sent with > the authority of the Company. If you are not the intended recipient, an > agent of the intended recipient or a person responsible for delivering the > information to the named recipient, you are notified that any use, > distribution, transmission, printing, copying or dissemination of this > information in any way or in any manner is strictly prohibited. If you have > received this communication in error, please delete this mail & notify us > immediately at [EMAIL PROTECTED] > > > Watch the latest updates on Mumbai, with video coverage of news, events, > Bollywood, live darshan from Siddhivinayak temple and more, only on > www.mumbailive.in > > Watch the hottest videos from Bollywood, Fashion, News and more only on > www.sifymax.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
