MySQL 3.23.47: I want to change a column that is currently non-indexed. SessionID is a nullable int column:
alter table tbl_Orders add unique SessionID(SessionID); results in Column 'SessionID' is used with UNIQUE or INDEX but is defined as NOT NULL (A throwback to version 3.22???) I have tried creating new (simple) tables with such indices and they work fine. I've also tried adding an index to an existing test table, in the same scenario as this one. I can't seem to reproduce the error under test conditions, but I simply cannot add this index! In the end, I deleted recreated the entire table with the index I was trying to create defined. It worked. Some vestige of mysql's pre-nullable-index days are still haunting it for the alter, though. -- Jamie --------------------------------------------------------------------- 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