Hi, We have a table (170K rows) and we altered the colum 'created_date' to not null with default value to '1900-01-01 00:00:00' , after the alter column statement is complited we select for the same column for nulls and I found 13K rows with null value select * from table1 where creted_date is null Run again an update for that column with the default date and it did not work too. I analyzed, checked, repaired the table looking for structural problems but I have no solved the problem yet. Could some body please tell me if there is a fix for this problem or a work around, patch or something to fix it please. Thank you. Edgart
--------------------------------------------------------------------- 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
