Re: Setting a field to NULL (default value)

On Monday 16 April 2007 07:56, Tim Johnson wrote: > Hi: > I have a table with a column of type char(120). > default is NULL > How do I a set a 'cell' back to NULL? > Example: > alter customers set all_colslist=NULL where ID=57; > returns a syntax error. > Mysql version 4.0.20 > thanks This is embar

Setting a field to NULL (default value)

Hi: I have a table with a column of type char(120). default is NULL How do I a set a 'cell' back to NULL? Example: alter customers set all_colslist=NULL where ID=57; returns a syntax error. Mysql version 4.0.20 thanks -- Tim Johnson <[EMAIL PROTECTED]> Palmer, Alaska, USA -- MySQL General Mailin