Is there a way, through PHP, to delete the contents of a column without deleting the actual column. I know I could do it by deleting the column and adding it again but just wondering if there's a more efficient way. Thanks.
if the col is nullable then you can run an update statement
update tableName set colName = null [optional where clause]
or if there is a default
update tableName set colName = someValue [optional where clause]