This seems very basic to me but I can't find (though only really looked for a little bit) the syntax for issuing an alter table statement that will force a field to no longer allow NULL values. I have some fields in a MyISAM table of MySQL 3.23 and wish to require them to contain a value.
What is the syntax of this and how will it affect data in the table? Thanks in advance for the help. ===== Robert Reed 512-869-0063 home 512-818-2460 cell __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]