I'm trying to remove the DEFAULT value from some mediumint and int columns in a MyISAM table.ALTER TABLE `table_name` ALTER COLUMN `column_name` DROP DEFAULT;MySQL says that this query is executed ...

You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...