Re: how to delete the records from one specific column

[nick]

This doesn't make sense to me. A record is equivalent to a row. You can delete data from a column, but it's non-sensical to say you want to delete a record from a column. You can delete a record by way of data in a column, however.

If you want to empty the data in a column, use an UPDATE setting the column (or field) that you want to empty equal to null or blank or zero.

For example:

UPDATE mytable SET columnb = null

Add whatever WHERE conditions you want.