Setting a field to NULL (default value)

2007-04-16 Thread Tim Johnson 
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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setting a field to NULL (default value)

2007-04-16 Thread Tim Johnson 
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]