Re: couldn't drop column in Innodb table
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 suggestions. > > > > __ > Yahoo! Mail Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. > http://mobile.yahoo.com/learn/mail > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
couldn't drop column in Innodb table
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://mobile.yahoo.com/learn/mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldnt 3.23.36 (WIN32) crashed after ALTER TABLE DROP COLUMN
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 with ca. 200.000 records into a separate table (successful) - dropping the blob_column from the large table (success) consecutive access to the database by an odbc-client caused the server to crash. stack_trace (dump.txt) attached How-To-Repeat: bug has been reproduced a 2nd time by dropping another column from the same table. Actually, the original table is not available anymore, because the crash corrupted the indexfile. Further attempts to reproduce the failure on backup-tables in progress. Fix:none so far Synopsis: mysqldnt crashed after ALTER TABLE DROP COLUMN Submitter-Id: ASC Originator: Armin Schöffmann Organization: Aegaeon technologies GmbH MySQL support: licence Severity: critical Priority: Category: mysqld Class: sw-bug Release:mysql-3.23.36 Exectutable:mysqld Environment:Dell Optiplex, Intel PIII, 256mb, nt5sp1(us)ws System: Win2000 Compiler: VC++ 6.0 Architecture: i686 Aegaeon technolgies GmbH Stadtamhof 15 93059 Regensburg Germany fon:+49.941.8107344 fax:+49.941.8107356 www.aegaeon.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
What are you using? MySQL or Microsoft SQL? If it's Microsoft SQL, you have come to the wrong place otherwise try using MyODBC instead. Why do you have to store information in a temporary column? Do you want to keep the data in the column? - Original Message - From: "Wernher 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 string: "ALTER TABLE WorkGroups DROP COLUMN Personnel" > i read somewhere something about having to store the information in a > temporary column before dropping it but cant rememebr where i read it, i > get an error that says:Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax > near 'Personnel'. > thanx regards wernher > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
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 TABLE > WorkGroups DROP COLUMN Personnel" and i get the error message: Error > Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect > syntax near 'Personnel'. please help I think you've confused MySQL and Microsoft SQL Server. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
Werner, Your syntax is correct and valid for MySQL. The problem could lie with your ODBC driver. What version are you on? Try downloading a utility for administering MySQL. UrbSQL is good from www.urbanresearch.com and see if that can drop the column. Good luck. Andy Woolley 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 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: > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax > near 'Personnel'. > please help me, tis urgent that it works soon > > thanx regards wernher > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP COLUMN
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: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help me, tis urgent that it works soon thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP COLUMN
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: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 string: "ALTER TABLE WorkGroups DROP COLUMN Personnel" i read somewhere something about having to store the information in a temporary column before dropping it but cant rememebr where i read it, i get an error that says:Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php