At 9:43 +0800 3/4/02, Al Caponi wrote:
>Check out the MySQL website for altering table structure:
>
>http://www.mysql.com/doc/A/L/ALTER_TABLE.html
>
>You could use MODIFY to change the columns definition in your tables. Note
>that specifying NOT NULL on a column will not affect existing rows where
Check out the MySQL website for altering table structure:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
You could use MODIFY to change the columns definition in your tables. Note
that specifying NOT NULL on a column will not affect existing rows where
that field already contains a NULL value.
R
At 16:59 -0500 3/3/02, [EMAIL PROTECTED] wrote:
>Is there any way in mysql to change a column that contains data
>from null = yes to be not null.
Use the ALTER TABLE statement.
>
>I want to enforce users to enter some value in column_x that was
>not a required field until now, by setting the col