]]
Sent: Monday, March 04, 2002 6:00 AM
To: [EMAIL PROTECTED]
Subject: change column to not null in MySQL
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
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
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 column