MySQL Forums
Forum List  »  MyISAM

Re: Alter table not working
Posted by: Ingo Strüwing
Date: March 09, 2006 04:19AM

Hi.

Can I have more information please?
MySQL version?
Did you upgrade recently? From which version?
SHOW CREATE TABLE ... ?
Exact ALTER TABLE statement?

Most probable it is a problem of the data. Try to select the row in question: SELECT column1 FROM table LIMIT 833299,1
or: SELECT column1 FROM table LIMIT 833297,6
to get some rows aournd the offending one.
These commands will take a while...

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2728
March 08, 2006 04:56AM
Re: Alter table not working
1788
March 09, 2006 04:19AM
2477
March 10, 2006 04:19AM


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.