RE: change column to not null in MySQL

2002-03-04 Thread Paul DuBois
]] 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

change column to not null in MySQL

2002-03-03 Thread shiam
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

Re: change column to not null in MySQL

2002-03-03 Thread Paul DuBois
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