24 messages in com.mysql.lists.mysqlRe: adding columns to a large table
FromSent OnAttachments
Ahmad Al-Twaijiry18 Sep 2006 14:27 
André Hänsel18 Sep 2006 14:30 
Edward Macnaghten18 Sep 2006 14:42 
Ahmad Al-Twaijiry18 Sep 2006 14:43 
Ahmad Al-Twaijiry19 Sep 2006 06:12 
Ahmad Al-Twaijiry19 Sep 2006 07:05 
Price, Randall19 Sep 2006 07:18 
Ahmad Al-Twaijiry19 Sep 2006 07:23 
Quentin Bennett19 Sep 2006 14:02 
Douglas Sims20 Sep 2006 09:43 
Felix Geerinckx21 Sep 2006 06:20 
Ahmad Al-Twaijiry24 Sep 2006 08:08 
Ahmad Al-Twaijiry24 Sep 2006 08:09 
Douglas Sims24 Sep 2006 12:59 
Ahmad Al-Twaijiry24 Sep 2006 13:26 
Douglas Sims24 Sep 2006 16:46 
Helen M Hudson24 Sep 2006 21:52 
Ehrwin Mina25 Sep 2006 00:04 
Mugunthan SIFY25 Sep 2006 02:57 
Ow Mun Heng25 Sep 2006 03:05 
Ahmad Al-Twaijiry25 Sep 2006 03:41 
Peter Brawley25 Sep 2006 03:57 
praj25 Sep 2006 04:22 
Helen M Hudson25 Sep 2006 04:35 
Subject:Re: adding columns to a large table
From:Ehrwin Mina (ehr@chikka.com)
Date:09/25/2006 12:04:59 AM
List:com.mysql.lists.mysql

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/mysql?unsub=emi@chikka.com

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