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 embarrassing.... I used alter instead of update. I should not start work before having all of my coffee. :-) Correct syntax is update customers set all_colslist=NULL where ID=57; | sorry! tim
-- Tim Johnson <[EMAIL PROTECTED]> Palmer, Alaska, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]