how to delete content of column?

[secretspot]

Hello group,

I want to delete the content of a single column on a MySQL 3.23
database. Tried
DELETE column_name FROM table_name;
and other varieties with e.g. WHERE clause. No luck until now.

The above statement gives the error msg:
ERROR 1066: Not unique table/alias: column_name

How to get rid of the content of a certain column?

Thanks for any hint.
Saludos,
George

[secretspot]

OK, it seems that DELETE command just deletes content of a whole table.
Is it possible to delete a specific column?

- George

[secretspot]

Is it recommended to overwrite all entries with an empty string value
(''), or NULL?
e.g. UPDATE table_name SET column_name='';

[Gordon Burditt]

>I want to delete the content of a single column on a MySQL 3.23

database. Tried
DELETE column_name FROM table_name;
and other varieties with e.g. WHERE clause. No luck until now.

The above statement gives the error msg:
ERROR 1066: Not unique table/alias: column_name

How to get rid of the content of a certain column?

Do you want to get rid of the COLUMN, or the CONTENT?

alter table table_name drop column_name;

does the first. If you want the second, a column has to
have *something* in it, even if it's null. Perhaps you want

update table_name set column_name = null;

Gordon L. Burditt