RE: change column to not null in MySQL

2002-03-04 Thread Paul DuBois
Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >> 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 contai

RE: change column to not null in MySQL

2002-03-03 Thread Al Caponi
. Regards, Al > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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

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 col

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 w