Hello.
What was the error? How was it related to the size problem?
What 'SHOW INNODB STATUS' says?
TT <[EMAIL PROTECTED]> wrote:
> I use "alter table tbl_name drop col_name" but failed.
> The table has 20 million rows, and this turns out to
> be a size problem. appreciate any suggesti
I use "alter table tbl_name drop col_name" but failed.
The table has 20 million rows, and this turns out to
be a size problem. appreciate any suggestions.
__
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:table modification [ALTER TABLE DROP COLUMN name];
on large table (1.7gb) crashed mysqldnt
Description:- attempt to extract a longblob column from a large table
nher Korff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 17:47
Subject: DROP COLUMN
> im new to this list and to the SQL language, id like to know if anyone
> knows how to drop a column from a SQL database,i currently have the
> following
On Fri, Feb 16, 2001 at 11:20:58AM +0100, Wernher Korff wrote:
> hello list;)
>
> i have a SQL command to DROP a COLUMN from a mySQL database, the
> problem is that the syntax i am using doesnt seem to be the right
> syntax for mySQL, my statement currently read:"ALTER TAB
www.databasewatch.com
- Original Message -
From: "Wernher Korff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 2:40 PM
Subject: DROP COLUMN
> hello list;)
>
> i have a SQL command to DROP a COLUMN from a mySQL database, the problem
> is that
hello list;)
i have a SQL command to DROP a COLUMN from a mySQL database, the problem
is that the syntax i am using doesnt seem to be the right syntax for
mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN
Personnel" and i get the error message:
Error Type:
Micros
hello list;)
i have a SQL command to DROP a COLUMN from a mySQL database, the problem
is that the syntax i am using doesnt seem to be the right syntax for
mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN
Personnel" and i get the error message:
Error Type:
Micros
im new to this list and to the SQL language, id like to know if anyone
knows how to drop a column from a SQL database,i currently have the
following string: "ALTER TABLE WorkGroups DROP COLUMN Personnel"
i read somewhere something about having to store the information in a
temporary col
