Is there any way in mysql to change a column that contains data from null = yes to be not null.
I want to enforce users to enter some value in column_x that was not a required field until now, by setting the column to not accept any record where column_x is null, is there any way to do this without distorting current data (I guess I will have to give some bogus value for all the data field's that are now null before I can change this).? If the column type cannot be changed what's the recommended way of doing something like this. Thanks Shia Shia Meisels B&H Photo Video 212-239-7500 Ext. 2158 http://www.bhphotovideo.com --------------------------------------------------------------------- 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